The short answer to this is that you use a scrollable result set you figure
out based on the page number which record number you are after (page - 1) *
rowsperpage and then read rowsperpage or end of resultset from there after
using result.absolute to position at the row number. You just have to get
the logic right so that you show the right things when you have result set <
= and > the number of page links you show.
I was looking at this just the other day and have got it working but I'm
sure there's better logic. I've reproduced the logic they use at
http://www.jobsite.co.uk when you do a job search and I've also done the
much much easier altavista one where you only _Ever_ show links to the first
25 pages and then use NEXT to go to the next page.
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of Chia Ti Loon TELCO NCS
> Sent: Monday, September 18, 2000 6:54 PM
> To: [EMAIL PROTECTED]
> Subject: Displaying rows from a Scrollable ResultSet
>
>
> Hi,
>
> I am very new to JSP and JDBC, and I faced the following
> programming
> problem :
>
> How do I access the rows returned in a scrollable resultset and
> display it on a html page (one that is embedded in a .jsp file). The html
> page should have controls or buttons that can allow the user to view the
> records in the following way:
>
> 1. scroll the page 10 records per page at a time, (backward and
> forward)
> 2. first 10 records, and last 10 records.
> 3. scroll the page one records per page at a time, (backward and
> forward)
>
> I would appreciate any help and advice on these matter
> from anyone,
> thanks.
>
> ==================================================================
> =========
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
