This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
if you are looking for ways to fetch 10 records, then fetch the next ten, etc... like some web pages, then have a look at this article which discusses this in detail. If you only want the first X number of rows, and that's it, have a look at the Statement.setMaxRows() method Jamie
Joined: Jan 30, 2002
thanks for reply, I really want to look for ways to fetch 10 records, then fetch the next ten, etc... I read the JDBC 2.0 API, and not sure Statement.setFetchSize(10); Statement.setFetchDirection(forward); can deal with my problem? Does anyone use this and know what the exactly above function's usage? thanks Krussi