This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman 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 Elasticsearch in Action this week in the Big Data 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
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: large result sets