Implementation of Advanced search

Thanx for responding graviton.The advanced search text box accepts a part number or product name , compares it with a table, in the data base,which contains the part number or part name and the associated page to open.

HI graviton,I am new to JSP.So,though I know the logic I donot know the exact syntax to code.Can U provide me with a sample code.

here some jsp code to connect to a mysql database, you will need to change the connection string to suit the database your using. find some connection code for the database your using.

The code will search a table where the field 'Text' is like the strSearch string.

<%@ page import="java.sql.*" %>
<%
String strSearch = request.getParameter( "Search" ); // <-- html input field name
Connection connection2 = null;
Statement statement2 = null;
ResultSet rs2 = null;
String print_item[];
int k=0;
%>

<%
try
{

Class.forName("com.mysql.jdbc.Driver").newInstance();
connection2 = DriverManager.getConnection("jdbc:mysql:///DBName", "username", "password");
statement2 = connection.createStatement();
rs2 = statement2.executeQuery("SELECT * FROM Table_name WHERE Text like ='%" + strSearch + "%'");

while (rs2.next()){
out.write (rs2.getString(1));
}

}

catch (Exception e){}
%>

as the example shows you need two things:
1. Class.forName("com.mysql.jdbc.Driver").newInstance();
a jdbc driver to connect to the specific database. in case there is no specific jdbc driver, you can use a jdbc to odbc driver. the example uses a jdbc driver for mysql.

2. you need to use a connection url for your jdbc driver, which will differ from the connection string for the jdbc driver for mysql as denoted in the example:
connection2 = DriverManager.getConnection("jdbc:mysql:///DBName", "username", "password");

hiii i am new to lucene.... some how i hav manages to index and search my database but couldn't delete the index........can anyone help me with it......
i am posting the funtion

public void delete(long userid) throws IOException
{
String uid = Long.toString(userid);
try
{
final IndexReader reader = IndexReader.open(dir);
final Term term = new Term(add.ID, uid);
reader.delete(term);
reader.close();


}
catch (IOException e)
{
System.out.println("Error while removing student data from index" +e);
e.printStackTrace();
}
}