search facility

[manasa teja]

i need ur help..
I need to implement "search" facility in a JSP.. Once the "last name" entered in the text box and subimitted, it should the result in the same page.
Can any one help on this....
thanks
raman

[Andres Gonzalez]

I don't fully understand what you want to achive.
However, have a look at apache lucene, it might help.

[manasa teja]

Thanks fr ur reply..
My question is
I have text box in a jSP.. This text box takes "last name" of teh employee.
Once the form is submitted, it will go to databse and fetch the details of all teh employees , whose last name matches with the one entered in the text box.. and the results need to be displayed in teh same JSP..
please help me on this

[manasa teja]

Any pleas help me or prove any link..

[Andres Gonzalez]

Originally posted by M K Raman:
Thanks fr ur reply..
My question is
I have text box in a jSP.. This text box takes "last name" of teh employee.
Once the form is submitted, it will go to databse and fetch the details of all teh employees , whose last name matches with the one entered in the text box.. and the results need to be displayed in teh same JSP..
please help me on this

can't you just build your own query using JDBC, getting the "last name" parameter?
something like this:

String queryItem = "SELECT * from YOUR_TABLE where last_name = ?";
PreparedStatement statement = conn.prepareStatement(queryItem);
String lastName = request.getParameter("lastName");
statement.setString(1,lastName);
result = statement.executeQuery();

that's probably what you need....