How to search a db?

[Andrew Parker]

Hi,
I want to create a very simple search function on my jsp page which connects to servlet and mysql database.
I want to search the ID attribute of the Staff database and then list out it's record.
What is the algorithm to do it?
Thanks
Andrew

[Bruce Jin]

1. Write a bean that reads your database and formats a html table. (you need to do several things: load the mySQL driver, get a connection, query the database, format the table using the result set).
2. Use the bean in your jsp file.

[Andrew Parker]

Here is the JSP page:

<%@ page contentType="text/html; charset=iso-8859-1" %>
<%@ page import="java.net.*" %>
<jsp:include page="/header.jsp" flush="true"/>
<table>
<tr><td>
<%  String ID ="";  String Name  ="";  String Salary  ="";%><form method="post" action="/servlet/StaffServlet">  
<table><tr>
<td>Search Staff ID:</td>
<td><input type="text" name="StaffID" value=<%=StaffID%>>
</td></tr>
<tr><td>Search Staff Name:</td>
<td><input type="text" name="StaffName" value=<%=StaffName%>>
</td></tr><tr>
<td>Search Salary:</td>
      <td>
        
<input type="text" name="Salary" value=<%=Salary%>      
</td>    
</tr>    
<tr>      
<td>        
<input type="reset" value="Reset">      </td>      
<td>        
<input type="submit" name="Submit" value="Submit">      
</td>    
</tr>  
</table>  
<input type="hidden" name="o" value=<%=o%>>  <input type="hidden" name="StaffID" value=<%=StaffID%>></form>
</td></tr></table><jsp:include page="/footer.jsp" flush="true"/>

Here is the method in Servlet:

public synchronized void SearchStaff(Staff staff)throws StaffException  
{    
//int result = 0;    
java.sql.PreparedStatement pstmt = null;    try    
{     
pstmt = conn.prepareStatement("select * from staffrecords values(?,?,?)");     
pstmt.setInt(1,staff.getStaffID());     pstmt.setString(2,staff.getStaffName());     pstmt.setDouble(3,staff.getStaffSalary());     
//result = pstmt.executeUpdate();     
while(pstmt.next())     
out.println(pstmt.getInt(staff.getStaffID())+ ", "     
+ pstmt.getString(staff.getStaffName()) + ", "     
+ pstmt.getDouble(staff.getSalary()));    }    catch(SQLException se)    
{     
throw new StaffException("Search Staff error");    }    
finally    {        
try {if(pstmt!=null)pstmt.close(); }        
catch (Exception e) { throw new StaffException("Search Staff error"); }    }    
//if(result < 1)      
//throw new StaffException("Search Staff error");  }

I want to make a search for
Staff ID, Staff Name OR Staff Salary.
Once input either of these 3 fields, it will show display the result on the same jsp page.
But, how should I write the servlet:
while(pstmt.next())
out.println(pstmt.getInt(staff.getStaffID())+ ", " + pstmt.getString(staff.getStaffName()) + ", " + pstmt.getDouble(staff.getSalary()));

and those code in the JSP page?
Thanks for any help.
Andrew