| ID |
First Name |
Last Name |
Department |
Vote |
<%
try {
con = DatabaseConnection.initializeDatabase();
Statement st = (Statement) con.createStatement();
String sql = "";
String query = request.getParameter("search");
if (query != null) {
sql = "select * from register where Fname like '%" + query + "%' or Lname like '%" + query + "%' ";
} else {
sql = "select * from register order by ID ASC";
}
ResultSet rs = st.executeQuery(sql);
while (rs.next()) {
%>
| <%=rs.getString(1)%> |
<%=rs.getString(2)%> |
<%=rs.getString(6)%> |
<%=rs.getString(7)%> |
|
<%
}
con.close();
} catch (Exception e) {
e.printStackTrace();
}
%>