This week's book giveaway is in the OCAJP forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide 1Z0-808 and have Jeanne Boyarsky & Scott Selikoff on-line!
See this thread for details.
The moose likes JSP and the fly likes large result sets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "large result sets" Watch "large result sets" New topic

large result sets

Sreenivas Vulli

Joined: Mar 24, 2003
Posts: 2
I am using struts freamework to develop a project. I have a need to dispaly large results on the jsp page with search capability, I have
to show only 20 results per page and need to have next and previous buttons to navigate the results that I retrived from database. I also
need to provide the user a text box where he can enter a value (say a telephone number), and I sould be able to show the user only the
record containing that field value. Is there any pattern in struts frame work which can provide me this and what is the best way to handle this situation. I need not goto the databse to get new results
each time b'cos my database does not change.
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

What you are looking for is commonly refered to as resultset paging or paged resultsets. There have been multiple conversations on it in the JDBC forum, and I recommend a search there first.
One solution that has been quite popular (although I'm not sold) is the Data List Handler pattern. Details are available here
Don't get me started about those stupid light bulbs.
subject: large result sets