Hi,
Use a bean, with session scope, to retrieve the data from the database.
Store the result set in a Vector. This should be done the first time the
page is loaded. Your bean will have two functions, one that returns a
specific range (min to max) of the result set stored in the Vector, and
another one that checks if there are more results in the Vector. Clicking on
next or previous (your buttons on your page) you will reload the page with
min and max incremented by e.g. 10 or deincremented by 10 respectively. You
will know when the page is loaded for the first time because the request
parameters min and max will be null. In this case the min and max will be
initialized with 0 and 9 (for 10 records at a time).
You should probably be able to follow this approach easily.
Costas
-----Original Message-----
From: Prakasan OK [mailto:[EMAIL PROTECTED]]
Sent: Ôñßôç, 31 Éïõëßïõ 2001 9:28 ðì
To: [EMAIL PROTECTED]
Subject: Split the ResultSet Values
Hi All,
I want to split the resultset values into different parts.
I want to display the 10 results first and if the user clicks next
button
i would like to display the next 10 results and so on similar
to the search results in Google. Any idea about how this can be done
using JSP?
Thanks in Advance,
Prakasan
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
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".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
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
