客户列表
首先修改main.jsp的跳转路径及PageServlet后台路径的转发,代码如下
<dd><a href="page.do?page=customerList" target="con">客户管理</a></dd>
protected void customerList(HttpServletRequest req, HttpServletResponse resp) throws
req.getRequestDispatcher("WEB-INF/jsp/customer/list.jsp").forward(req,resp);
}
1.1参考用户列表jsp
重点关注如下内容: code / count / data 的最后一个参数名. 要和当前工程定义的类的属性同名.否
则列表无数据
另外,layui默认code响应成功是0. 而工程中定义成功为200 , 那么此处需要明确给出是200
parseData:function(rs){
//数据格式解析
if(rs.code == 200){
return {
"code":rs.code,
"msg":rs.msg,
"count":rs.data.total,
"data":rs.data.list
}
}
},
response:{
// 设置响应码
statusCode: 200 //规定成功的状态码,默认:0
}
1.2CustomerServlet的列表实现
protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletE
String page = req.getParameter("page");
String limit = req.getParameter("limit");
String cust_name = req.getParameter("cust_name");
String cust_position = req.getParameter("cust_position"); //职位
String minTime = req.getParameter("minTime");
String maxTime = req.getParameter("maxTime");
String company = req.getParameter("company");
String cust_phone = req.getParameter("cust_phone");
String userId = req.getParameter("userId");
Map<String,Object> map = new HashMap<String, Object>();
if(!StrUtil.isBlank(cust_name)){
map.put("cust_name",cust_name);
}
if(!StrUtil.isBlank(cust_position)){
map.put("cust_position",cust_position);
}
if(!StrUtil.isBlank(minTime)){
map.put("minTime",minTime);
}
if(!StrUtil.isBlank(maxTime)){
map.put("maxTime",maxTime);
}
if(!StrUtil.isBlank(company)){
map.put("company",company);
}
if(!StrUtil.isBlank(cust_phone)){
map.put("cust_phone",cust_phone);
}if(!StrUtil.isBlank(userId)){
map.put("userId",userId);
}
JsonData jsonData = customerService.findCustsByPage(page,limit,map);
PrintJsonData.printJson(resp,jsonData);
}
1.3 Customer业务层
public JsonData findCustsByPage(String page, String limit, Map<String, Object> map) {
PageBean<Customer> pageBean = customerDao.findCustsByPage(Integer.valueOf(pag
return JsonData.buildSuc(pageBean);
}
1.4Customer持久层
注意:因为客户是属于User(用户) 的 ,和用户是 "多对1"关系,此处为显示关联的客户名,使用外连接
select u.real_name userRealName , c. from t_customer c left join t_user u on u.id=c.user_id where 1=1
另外在Customer类中,多写1个属性userRealName 记录上面sql查询的用户名的别名*
public PageBean<Customer>