Make ur bean statefull. And for the first query put all the results in the
vector. and when user presses next and prev buttons extract the specifies
no of records from it and return to jsp. You have to maintain the current
row pointer for that in ur bean
Regds
Ashwani
> ----------
> From: Donald E. Vandenbeld
> Reply To: Donald E. Vandenbeld
> Sent: Saturday, February 19, 2000 4:24 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Help!!!
>
> I have a similar situation. My initial thought is to create a Vector
> object
> and store it in the session. Another session variable would keep track of
> what 'page' you are on. This enables you to move back and forth through
> the
> pages without querying the database each time. Would it be wise to make
> this Vector object kind of a result set object that could be used for
> several different listing JSPs throughout the site?
>
> I should state, though, that if you have a busy site (lots of concurrent
> users) and are returning huge result sets, this would eat up memory like
> crazy.
>
> Donald
>
> ----- Original Message -----
> From: "OG Project(Chennai)" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, February 17, 2000 6:06 AM
> Subject: Help!!!
>
>
> >
> >
> > Hi All,
> >
> > How do I display (say) 100 records from the database in the same JSP
> page
> > while restricting the nos. of displayed datas to 20 at a time on the
> page.
> > Something like a search page where you get hundreds of matches and
> displays
> > 20 at a time and with links for the rest.
> >
> > Regards
> > Subendu
> >
> >
> ==========================================================================
> =
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> > FAQs on JSP can be found at:
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> >
>
> ==========================================================================
> =
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> FAQs on JSP can be found at:
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
>
>
>
Visit http://www.niit.com for eCommerce Solutions.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
