master_programmer
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 ??
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 ??
ASKER
Thanx, I know all of these things,but the problem is how to do the search
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
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?
ASKER
Thanx, I'll try this link
http://www.roseindia.net/sourcecode/searchengine/download.shtml
it seems that it is what i want
http://www.roseindia.net/sourcecode/searchengine/download.shtml
it seems that it is what i want
How to connect JSP with SQL Server 2000?
http://www.visualbuilder.com/viewAnswer.php?question_id=38&group_id=4
then sql tag:
http://java.sun.com/j2ee/1.4/docs/tutorial/doc/JSTL7.html
and
JSP Source Code : Applications
http://www.visualbuilder.com/sourcecode_cat_listing.php?cat_id=356