This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes how to make a page type recordset Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "how to make a page type recordset" Watch "how to make a page type recordset" New topic
Author

how to make a page type recordset

Jagmohan Negi
Greenhorn

Joined: Aug 24, 2005
Posts: 27
How can i make a page type(ex google search) recordset as my SQL query returns a large number of records and to display them in a single page is not possible, so i want to display them 20 per page and buttons like perv. and next to move to prev. and next records.

Thanx for the help
vishwam gandi
Greenhorn

Joined: Jun 03, 2005
Posts: 2
You can do this by different methods
1. by setting up record set ,max row number in ur page as a session objects
traverse record set each time ur page called upto max row number of prevoius page.

2.fire ur query in page each time it is called & traverse upto max row number of prevoius page.

3. You can use a datagrid tag lib which is available at http://jakarta.apache.org/taglibs/index.html

I hope this solves ur problem
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: how to make a page type recordset
 
Similar Threads
Recordset Navigator
Print Jsp page(s)
Displaying next 10 records from resultset
Insert/Update recordset
recordset in different pages