I need to do pagination in jsp by getting the resultset with large rows , The result set may contain 70,000 rows .
But i have to display it 100 rows per page . How can i fetch 100 rows per request and while fetching the result for second request the result i should get from 200 to 300
Try displayTag library if you are using JSPs. Check this link http://displaytag.sourceforge.net/11/
Message was edited by: Vishwas
Vishwas_Prasanna
Is there any options to do pagination using jdbc to retrive 70,000 records and displaying 100 records per page
How about simply sending the start and end indices as parameters to the request?
hi,
might be u will be useful 4r u!
http://jroller.com/coreteam/entry/pagination_in_jsp
> Is there any options to do pagination using jdbc to
> retrive 70,000 records and displaying 100 records per
> page
This is very stupid. Don't do this. No user wants to page through 70,000 records.
> Yes , IS there any option to do it using jdbc
Sure. Modify your SELECT statement accordingly. :p
Can any one tell the query to retrive 100 records per each page . how to query the table to retrive 100 records per page in which 70,000 record exists.
The result should be displayed as like search engine result.
