<body>
<center>
<form action="" method="post">
请输入查询关键字:<input type="text" name="keyword">
<input type="submit" value="查询">
</form>
<table border="1" cellspacing="0">
<tr>
<td>雇员编号</td>
<td>雇员姓名</td>
<td>雇员工作</td>
<td>雇佣日期</td>
<td>雇员工资</td>
</tr>
<%
%>
<%
try {
String keyWord = request.getParameter("keyword");
if (keyWord != null) {
// List<Emp> all = EmpDao.doFind(keyWord); //取得查询数据
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
conn = DBUtil.getConnection(); //连接数据库
List<Emp> all = new ArrayList<Emp>(); //定义一个集合all
String sql = "SELECT empno,ename,job,hiredate,sal FROM emp WHERE ename LIKE ? OR job LIKE ?";
stmt = conn.prepareStatement(sql);
stmt.setString(1, "%" + keyWord + "%");
stmt.setString(2, "%" + keyWord + "%");
rs = stmt.executeQuery();
Emp emp = null;
while (rs.next()) {
emp = new Emp();
emp.setEmpno(rs.getInt(1));
emp.setEname(rs.getString(2));
emp.setJob(rs.getString(3));
emp.setHiredate(rs.getDate(4));
emp.setSal(rs.getFloat(5));
all.add(emp);
}
DBUtil.close(rs, stmt, conn);
Iterator<Emp> iter = all.iterator();
while (iter.hasNext()) {
Emp emp1 = iter.next();
%>
<tr>
<td><%=emp1.getEmpno() %></td>
<td><%=emp1.getEname() %></td>
<td><%=emp1.getJob() %></td>
<td><%=emp1.getHiredate() %></td>
<td><%=emp1.getSal() %></td>
</tr>
<%
}
}
%>
</table>
</center>
<%
}catch(Exception e) {
e.printStackTrace();
}finally {
}
%>
</body>