File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Need to divide ResultSet data into different groups Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Need to divide ResultSet data into different groups" Watch "Need to divide ResultSet data into different groups" New topic
Author

Need to divide ResultSet data into different groups

Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

Hi ,

By querying database i had got large data on to my Resultset (assume nearly 10000)
Now i want to display 100 by 100 per page (similar to google search)

Please let me know what is the approach to go on this .
(I am not using Hibernate Framework )

Is this requirement is same as Pagination ??

Please Share your ideas .
Thanks in advance .


Save India From Corruption - Anna Hazare.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Yes this is pagenation. Have a search through this forum, this technique has been descibed here many times before.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Need to divide ResultSet data into different groups
 
Similar Threads
ResultSet Update problem with Oracle 9i using JDBC
How to return data from a database table using Apache CXF web service?
Aggregate functions problem in jsp
Fetching Rows From ResultSets (JDBC).
How to define ResultSet limit by PL/SQl in Oracle database