U can store the PK with http session, and modify ur query
select * from MY_TABLE
where name='---' and ...... and pk > 1234
to get the next 10.
u can do some optm using sliding window technique too
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Just
Pham
Sent: Tuesday, May 30, 2000 7:47 PM
To: [EMAIL PROTECTED]
Subject: Implements a search engine by using Servlet and JDBC
Hi All,
I am building a search engine for our company project. Here are the
problems:
We have database keep thousand of records of users. We would like to search
based on name, address, telephone number, SIN.. In my project, I build a
servlet and simple JDBC object to do a query and return results back to user
screen. Supposingly, we do a search and get hundreds records back and want
to display 10 per time, should we keep all of them in the HttpSession or
some Hidden Input Text Field so that we don't have to hit back to database
again?
Does any one implement an internal search engine like this in the web
application?
Thanks in advance,
Justin Pham.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
