File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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
I agree. Here's the link:
subject: large result sets
It's not a secret anymore!