write"search" code using jsp?

Hi, I want to create a jsp page that enable the user to do "search" operation based on criteria and the search will be performed in the sql database
the scenario again as follows:
1-user insert the search phrase in the specifide field
2- select option on dropdown menu "for example"
2- click the search button
4- the search will happen in my database "sql server2000" based on the phrase and the choice in the drop down menu
5- the web page will display the result
Do you have a code or a good reference to do that ??
master_programmerAsked:
Who is Participating?
 
TheMajesticConnect With a Mentor Commented:
hi,

here is the java code for the search engine.

http://www.roseindia.net/sourcecode/searchengine/download.shtml

hope this will help u .
0
 
Eugene ZCommented:
0
 
master_programmerAuthor Commented:
Thanx, I know all of these things,but the problem is how to do the search
0
 
ManishLeadCommented:
You need to create query which will search the database.
In which field you want to search?
If you want to search in all fields then add this q in
Database/MS-SQL-Server/ section, if there is any better way?
0
 
master_programmerAuthor Commented:
Thanx, I'll try this link

http://www.roseindia.net/sourcecode/searchengine/download.shtml

it seems that it is what i want
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.