Thanks AjiTesh,
Can i save all the PKs (maybe 100) into the HtppSession and perform the next
query to get 10 records like this:
select * from Mytable where PK in(101,202,303...). Please notice that
(101,202,303..) is the set of PKs i get out of the HttpSession. Also, could
you tell me what does the Sliding Window technique look like?
Thanks in advance,
Justin PHam
>From: Ajitesh Das <[EMAIL PROTECTED]>
>Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology." <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Implements a search engine by using Servlet and JDBC
>Date: Wed, 31 May 2000 09:47:17 -0700
>
>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
________________________________________________________________________
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
