Pagination in jsp

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

[298 byte] By [Invalid_Column_Namea] at [2007-11-27 11:53:39]
# 1

Try displayTag library if you are using JSPs. Check this link http://displaytag.sourceforge.net/11/

Message was edited by: Vishwas

Vishwas_Prasanna

Vishwas_Prasannaa at 2007-7-29 18:51:29 > top of Java-index,Java Essentials,New To Java...
# 2

Is there any options to do pagination using jdbc to retrive 70,000 records and displaying 100 records per page

Invalid_Column_Namea at 2007-7-29 18:51:29 > top of Java-index,Java Essentials,New To Java...
# 3

How about simply sending the start and end indices as parameters to the request?

CeciNEstPasUnProgrammeura at 2007-7-29 18:51:29 > top of Java-index,Java Essentials,New To Java...
# 4

Yes , IS there any option to do it using jdbc

Invalid_Column_Namea at 2007-7-29 18:51:29 > top of Java-index,Java Essentials,New To Java...
# 5

hi,

might be u will be useful 4r u!

http://jroller.com/coreteam/entry/pagination_in_jsp

naveenchowdharya at 2007-7-29 18:51:29 > top of Java-index,Java Essentials,New To Java...
# 6

> 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.

cotton.ma at 2007-7-29 18:51:29 > top of Java-index,Java Essentials,New To Java...
# 7

> Yes , IS there any option to do it using jdbc

Sure. Modify your SELECT statement accordingly. :p

CeciNEstPasUnProgrammeura at 2007-7-29 18:51:29 > top of Java-index,Java Essentials,New To Java...
# 8

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.

Invalid_Column_Namea at 2007-7-29 18:51:29 > top of Java-index,Java Essentials,New To Java...
# 9

The result should be displayed as like search engine result.

Invalid_Column_Namea at 2007-7-29 18:51:29 > top of Java-index,Java Essentials,New To Java...