File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes How paging by JDBC ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How paging by JDBC ?" Watch "How paging by JDBC ?" New topic

How paging by JDBC ?

Yang XZ

Joined: Apr 26, 2004
Posts: 1
We making a local java application, there is a screen for display the search results. but, the data is too much. so, I hope use Statement (setFetchSize())paging.
Can you help me ! thanks very much!
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63548

"Yang XZ",
We're really glad that you are here with us in the JDBC forum, and there aren't many rules you'll have to worry about, but one is that proper names are required. Please take a look at the JavaRanch Naming Policy and change your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
Forum Bartender

[Asking smart questions] [About Bear] [Books by Bear]
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

There are better ways to achieve this. Do a search in this forum for "ResultSet paging" and have a look at some of the discussions.
Lavern Matthew
Ranch Hand

Joined: Jun 05, 2004
Posts: 38
Take a look at the project.

Matthew Wilson<br />-
I agree. Here's the link:
subject: How paging by JDBC ?
It's not a secret anymore!