thanks for the advice. Now it displays without any errors, but no query displays. Here is the code again with some more documentations.
<%@ page contentType="text/html; charset=utf-8" import="java.sql.*, java.util.*" errorPage="error.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Chemistry Search</title>
</head>
<body>
<br>
<br>
<form method="POST" action="ChemistryDataSearchVar.jsp">
<table border="0" width="270" id="table1">
<tr>
<td colspan="2">Please choose</td>
</tr>
<tr>
<td width="150"><input type="text" name="Pnumber" size="20"></td>
<td><input type="submit" value="Search" name="B2"></td>
</tr>
<tr>
<td colspan="2"><input type="radio" value="username" checked name="searchChoice">user name
<input type="radio" value="userrole" name="searchChoice">User role
<input type="radio" value="firstname" name="searchChoice">first name</td>
</tr>
</form>
</table>
<br>
<br>
<br>
<tt class="1">User Information</tt><br><br>
<table border="1" width="300" id="table1" cellspacing="0" cellpadding="4">
<tr bgcolor="bcbcbc">
<td width="30">First Name</td>
<td width="50">Last Name</td>
<td width="30">User Name</td>
<td width="20">Password</td>
<td width="30">Role</td>
<td width="140">E-mail Address</td>
</tr>
<%
//load the MS Access JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//open a connection to the "chemistry_test" database
String url="jdbc:odbc:chemistry_test";
Connection testConn= DriverManager.getConnection(url,"test1","test1");
String userSearch = request.getParameter("Pnumber") ; //get data from the textbox
String buttonChoice = request.getParameter("searchChoice") ; //get choice from the radio button
String abu = null;
if (buttonChoice == ("username"))
abu = "uName"; //search by radio button user name DB Field Name: uName
else if(buttonChoice == ("userrole"))
abu = "Role" ; //search by radio button user role DB Field Name: Role
else if (buttonChoice == ("firstname"))
abu = "Fname" ; //search by radio button user First name, DB Field Name: Fname
String jsql= "Select *from UserList WHERE "+abu+" = '"+userSearch+"'";
System.out.println(jsql);
//create a statement object for sending SQL queries
Statement stmt = testConn.createStatement();
ResultSet rs = stmt.executeQuery(jsql);
%>
<% //assign ResultSet's column 1 to a String variable
while(rs.next()){
%>
<tr>
<td><%=rs.getString("Fname")%> </td>
<td><%=rs.getString("Lname")%> </td>
<td><%=rs.getString("Uname")%> </td>
<td><%=rs.getString("pword")%> </td>
<td><%=rs.getString("Role")%> </td>
<td><%=rs.getString("email")%> </td>
</tr>
<%
}
//clean up all objects
rs.close();
%>
</body>
</html>
<%
testConn.close();
%>
uid uName pword Fname Lname Role email
72 admin admin Reza Mahmud Admin
[email protected]
78 pet pet Pet Shop Pet Shop ShopOwner
[email protected]
Dynamic Query
