一、查询操作
(1)Servlet中的查询主体代码:
//1、调用CustomerDAO的getAll()得到Customer的集合
java.util.List<Customer> customers = customerDAO.getAll();
//2、把Customer的集合放入request中
request.setAttribute("customers", customers);
//3、转发页面到index.jsp(不能使用重定向)
request.getRequestDispatcher("/index.jsp").forward(request, response);
(2)JSP查询主体代码:
<form action="query.do" method="post">
<table>
<tr>
<td>CustomerName:</td>
<td><input type="text" name="name"/></td>
</tr>
<tr>
<td>Address:</td>
<td><input type="text" name="address"/></td>
</tr>
<tr>
<td>Phone:</td>
<td><input type="text" name="phone"/></td>
</tr>
<tr>
<td><input type="submit" value="Query"/></td>
<td><a href="add.jsp">Add New Customer</a></td>
</tr>
</table>
</form>
二、模糊查询
(1)模糊查询Servlet中的主体代码:
String name = request.getParameter("name");
String address = request.getParameter("address");
String phone = request.getParameter("phone");
CriteriaCustomer cc = new CriteriaCustomer(name, address, phone);
java.util.List<Customer> customers = customerDAO.getForListWithCriteriaCustomer(cc);
//2、把Customer的集合放入request中
request.setAttribute("customers", customers);
//3、转发页面到index.jsp(不能使用重定向)
request.getRequestDispatcher("/index.jsp").forward(request, response);
三、删除操作
(1)删除操
String idStr = request.getParameter("id");
int id = 0;
try {
id = Integer.parseInt(idStr);
customerDAO.delete(id);
} catch (NumberFormatException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
response.sendRedirect("query.do");