If i want to fetch 100 rows first and then begin retrieve data normally.is the statement listed below correcttly?
myResultSet.setFetchSize(100); if(!myResultSet.fecth()) return false; myResultSet.setFetchSize(1); while(myResultSet.fetch()) { //do something. } BTW : If u want to retrieve the first n rows only,u can use the sql clause defined by special provider.such as “limit ” to mysql . “fetch frist n rows only ” to db2 and “rownum <= n" to oracle. I have a weak english.and i am so weak.
Related Questions
- If i want to fetch 100 rows first and then begin retrieve data normally.is the statement listed below correcttly?
- How to configure the QEngine to fetch the data from the database table to use it in the parameters value?
- Are there statistics to trace data changes (e.g. how many rows were inserted, updated, or deleted)?
