62,612
社区成员
发帖
与我相关
我的任务
分享
package bean;
public class Employee {
private String EmployeeID;
private String EmployeeName;
private String BirthDate;
private String HireDate;
public String getEmployeeID() {
return EmployeeID;
}
public void setEmployeeID(String employeeID) {
EmployeeID = employeeID;
}
public String getEmployeeName() {
return EmployeeName;
}
public void setEmployeeName(String employeeName) {
EmployeeName = employeeName;
}
public String getBirthDate() {
return BirthDate;
}
public void setBirthDate(String birthDate) {
BirthDate = birthDate;
}
public String getHireDate() {
return HireDate;
}
public void setHireDate(String hireDate) {
HireDate = hireDate;
}
public Employee(String employeeID, String employeeName, String birthDate,
String hireDate) {
EmployeeID = employeeID;
EmployeeName = employeeName;
BirthDate = birthDate;
HireDate = hireDate;
}
}
public ArrayList<Employee> sort(String dest) {
ArrayList<Employee> list = new ArrayList<Employee>();
Employee em = null;
ResultSet rs = null;
String sql = "select EmployeeID,LastName+' '+FirstName as EmployeeName,"
+ "BirthDate,HireDate from Employees order by " + dest + " asc";
PreparedStatement ps = null;
try {
Connection con = getConnection();
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
em = new Employee(rs.getString("EmployeeID"), rs
.getString("EmployeeName"), rs.getString("BirthDate"),
rs.getString("HireDate"));
list.add(em);
}
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
DBUtil db=new DBUtil();
ArrayList<Employee> list=db.sort("EmployeeID");
request.setAttribute("list", list);
request.getRequestDispatcher("index.jsp").forward(request, response);
}
<c:forEach var="list" items="${list}">
<tr>
<td>${list.EmployeeID }</td>
<td>${list.EmployeeName }</td>
<td>${list.BirthDate}</td>
<td>${list.HireDate }</td>
</tr>
</c:forEach>
<c:forEach var="list" items="${list}">
<tr>
<td>${list.employeeID }</td>
<td>${list.employeeName }</td>
<td>${list.birthDate}</td>
<td>${list.hireDate }</td>
</tr>
</c:forEach>