Ced 1) Requery the database for each user query (and include a startrow parameter) : this is DB intensif, but completely stateless (my option) 2) Query the DB and store results in a session. (not the resultset : but the data) : only for static data 3) Store the statement/resultset in the users session. : beware for lots of users, session timeout etc. Jan -----Original Message----- From: Chin Cedric Sung Kit [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 11, 2000 13:21 To: [EMAIL PROTECTED] Subject: display of resultset Hi fellow developers, I have a JDBC connection to a Oracle Database. I wish to write the first ten records to the browser first, and when the user clicks on the Next button/link, then the next ten records shall be displayed. It's like the search results displayed by any search engine. How do I go about in making this application? Thanks for any help. Ced ___________________________________________________________________________ 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
