Link to home
Start Free TrialLog in
Avatar of master_programmer
master_programmerFlag for Saudi Arabia

asked on

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 ??
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Avatar of master_programmer

ASKER

Thanx, I know all of these things,but the problem is how to do the search
ASKER CERTIFIED SOLUTION
Avatar of TheMajestic
TheMajestic

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
Thanx, I'll try this link

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

it seems that it is what i want