Solved

write"search" code using jsp?

Posted on 2007-11-20
5
5,235 Views
Last Modified: 2012-08-13
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 ??
0
Comment
Question by:master_programmer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 43

Expert Comment

by:Eugene Z
ID: 20320976
0
 

Author Comment

by:master_programmer
ID: 20322489
Thanx, I know all of these things,but the problem is how to do the search
0
 
LVL 4

Accepted Solution

by:
TheMajestic earned 500 total points
ID: 20325646
hi,

here is the java code for the search engine.

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

hope this will help u .
0
 
LVL 11

Expert Comment

by:Manish
ID: 20325664
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
 

Author Comment

by:master_programmer
ID: 20327209
Thanx, I'll try this link

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

it seems that it is what i want
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL / Table Lock? 7 40
VMware PVSCSI SQL Server 2016 AlwaysOn 2 34
SQL Server Pivot 5 39
Sql group by orderdate and ordertotal 3 6
In this post we will learn different types of Android Layout and some basics of an Android App.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question