Originally posted by lakshmi rajagopal:
pass a parameter called page numer to the jsp page which is going to display result set.Restrict the no.of records per page like 25.now go to the record 25 * pagenumber and start to display upto 25 records. Put two buttons as previouse<< and next>> . In on click event handler of the previous button reduce the page number and call the same page. In on click event handler of the next button increase the page number and call the same page.
Where will you have th ResultSet onject. ?
In Session??
Since you are passing the request to same JSP page. naturally you will not Query the database everytime.
Do you have any idea of using RowSet or CachedRowSet instead of this.
Thanks.