hi
you have to use scrollable result set and
setAbsolutePosition() in jdbc2.0. You can set
the fetch size to 20 so that you can take
records in batches of 20 from the database. This
is faster than the usual method of scrolling
through the entire resultset.
regards
Nagaraj
--- Vineet Sethi <[EMAIL PROTECTED]> wrote:
> hi
>
> I have created a module to search for a keyword in a
> database in JSP.
>
> I need to display the database 20 results per page.
> How is this done on most
> sites?
>
> do i store all the results in a vector or array ?
>
> do i use some special cursors which will help me
> display the results?
>
> i would appreciate any help in this regard.
>
> thanks in advance
>
> Vineet Sethi
>
>
===========================================================================
> 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
__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/
===========================================================================
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
