Design Question - Database Queries 1

[MarleneD]

I have a thin client application that will bo doing database queries against Oracle.

The return results are over 500 for the query.

I want to dispay 10 results on a page in the browser at a time. And then the user can use the 'next' link to see the next 10 results. They can also hit the 'back' link on the page to view the previous 10 results.

I am using JSP and servlets - how is it best to do this?

Thanks,

JD

 

[venur]

Hi,

If you are allowed to use the TagLibrary's in your webapplication then you can use the Pager tag library.

http://jsptags.com/tags/navigation/pager/pager-taglib-2.0.html

If you are intersted to write your own code. then Store the the resultSet in your session object and write and Java file which has next and previous methods which takes the offset value and the SessionObject and returns the Part of the arrayList.

Cheers,
Venu