Hi Eric,
Look at Karl Mosses book "Java Servlets", there is a good example of what
you are trying to do in there (somewhere). You need support for JDBC-2 if
you want to do the BACK button using the previous() method. If you don't
have JDBC 2 you can use javascript putting code in like below which puts a
back button in:
outputToBrowser.println("<div align=\"right\"><INPUT TYPE=\"button\"
VALUE=\"Back\" ONCLICK=\"history.go(-1)\">");
Tom Kochanowicz
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Eric
Noriega
Sent: Friday, April 07, 2000 2:08 PM
To: [EMAIL PROTECTED]
Subject: Re: Handling large records
You can use SQL cursors if the DB supports them, and if the jdbc
drivers support them. This requires that you hold the DB connection open
for long periods of time though, and is usually avoided. Another way is
to fetch and cache the results on the servlet server. Both have their
down sides.
On Wed, 5 Apr 2000, Umashankar Balasubramanian wrote:
> I get a huge number of records (in thousands) when I
> issue query from a servelet. Presently I pump all this
> info. to the browser and it is very slow.
>
> I want to implement prev/next buttons on the browser
> so that only a set of records is fetched from the
> servlet.
>
> What changes need to be done on the servlet (I have
> the constraint of not issuing the query more than
> once)
>
> Regards,
> Uma
>
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://im.yahoo.com
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
