Hi guys
I am trying to write some code here in jsp. I want to select some employee using its attributes. The first option is to select the criteria on which I want to base my search e.g. EMP ID. When I select this it should load for me all the data in that particular column in the database to the adjacent textbox. If I select EMP NAME, It should load for me all the data in the empname column in the database and display it in adjacent textbox and so on.
Here is my code and any help will be appriciated.Database name: employ, table name:emp and the fields are:
<html>
` <body bgcolor="#d0d0d0">`
<br></br>
<br></br>
<br></br>
<h2 align="center">Enter Farmer details</h2>
<form name="searchfarmer" action="search" method="post">
<table border="2" width="300" align=center bgcolor="#e9fh">
<%
Connection con = null;
PreparedStatement stmt = null;
Statement st = null;
ResultSet rs = null;
String search = request.getParameter("search");
String field = "";
String category = "";
try{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/employ", "root", "");
st=con.createStatement();
String id=session.getValue("login").toString();
String str = "Select * from emp where search ="+search;
rs =st.executeQuery(str);
// if () {
field=rs.getString(1);
while(rs.next() ){
field = rs.getString(1);
out.println(field);
}
// elseif{
// rs = st.executeQuery("Select empno from emp");
// }
}
catch(Exception e){e.printStackTrace();
}
%>
<tr><td>
<b>Select Category:</b>
<select name="search">
<option value="">
<option value="code">EMP NO
<option value="name">EMP NAME
<option value="category">CATEGORY
</td>
<td>
<b>Fields:</b>
<select name="search">
<option value=field>
</td></tr>
</table>
<center>
<input type="submit" value="Search"/>
<input type="reset" value="Reset"/>
</form>
</body>
</html>
