客户管理
更新客户
更新规则如下
1.实现效果
1.1 业务员操作效果
1.2 管理员操作效果
2.实现步骤
2.1 customer.jsp
改变修改按钮的地址信息
<a href="/customer/customerUpdate?id=${dto.customer.customerId }" class="tablelink">修改</a> 2.2 CustomerController
内容不用改变，和添加的时候一样
@RequestMapping("/customerUpdate")
public String customerUpdate(Integer id,Model model){
customerService.getUpdateInfo(id, model);
return "customer/customerUpdate";
} 2.2 CustomerServiceImpl
注意：和添加时有调整
/**
* 新增客户
* 查询 所有的角色是业务员的用户
* 查询 常用区间 基础数据
* 修改客户
* 查询 所有的角色是业务员的用户
* 查询 常用区间 基础数据
* 根据客户ID 查询详细信息
*/
@Override
public void getUpdateInfo(Integer id, Model m) {
// 1.查询所有具有业务员角色的用户信息
List<User> users = userService.queryUserByRoleName(Constant.ROLE_SALESMAN);
// 2.查询 常用区间的基础数据
List<BasicData> intervals = basicService.getBasicDataByParentName(Constant.BASIC_COMMON_INTERVAL);
if(id!=null && id > 0){
Customer customer = new Customer();
customer.setCustomerId(id);
// 查询更新需要的数据
List<CustomerDto> list = customerMapper.queryView(customer);
if(list != null&& list.size()==1){
m.addAttribute("dto", list.get(0));
}
}
m.addAttribute("users", users);
m.addAttribute("intervals", intervals);
} 2.3 CustomerMapper.xml
给queryView添加了查询条件
<select id="queryView" resultMap="baseCustomerDto" parameterType="com.bobo.pojo.Customer" >
select
t1.customer_id
,t1.customer_name
,t1.address
,t1.c_sex
,t1.email
,t1.base_id
,t1.id_card
,t1.mobile_phone
,t1.order_id
,t1.remark
,t1.user_id
,t1.user_name
,t1.real_name
,t1.base_name
from v_customer t1
<where>
<if test="userId !=null and userId > 0">
user_id = #{userId}
</if>
<if test="customerId !=null and customerId > 0 ">
customer_id = #{customerId}
</if>
</where>
</select> 2.4 customerUpdate.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://shiro.apache.org/tags" prefix="shiro" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<link href="/css/style.css" rel="stylesheet" type="text/css" />
<link href="/css/select.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="/js/jquery.js"></script>
<script type="text/javascript" src="/js/jquery.idTabs.min.js"></script>
<script type="text/javascript" src="/js/select-ui.min.js"></script>
<script type="text/javascript">
$(document).ready(function(e) {
$(".select1").uedSelect({
width : 345
});
$(".select2").uedSelect({
width : 167
});
$(".select3").uedSelect({
width : 100
});
});
</script>
</head>
<body>
<div class="place">
<span>位置：</span>
<ul class="placeul">
<li><a href="/">首页</a></li>
<li><a href="/user/query">客户管理</a></li>
</ul>
</div>
<div class="formbody">
<div class="formtitle">
<span>新增客户信息</span>
</div>
<form action="/customer/saveOrUpdate">
<ul class="forminfo">
<input type="hidden" name="customerId" value="${dto.customer.customerId}">
<li><label>客户姓名</label>
<input name="customerName" type="text" value="${dto.customer.customerName}" class="dfinput" />
<i></i>
</li>
<li><label>客户电话</label>
<input name="mobilePhone" type="text" value="${dto.customer.mobilePhone}" class="dfinput" />
</li>
<li><label>性别 ${dto.customer.cSex}</label>
<input type="radio" name="cSex" value="0" ${dto.customer.cSex eq true?"checked":"" }> 男
<input type="radio" name="cSex" value="1" ${dto.customer.cSex eq false?"checked":"" }> 女
</li>
<li><label>电子邮箱</label>
<input name="email" type="text" class="dfinput" value="${dto.customer.email}"/><i></i>
</li>
<li><label>通讯地址</label>
<input name="address" type="text" class="dfinput" value="${dto.customer.address}"/><i></i>
</li>
<li><label>身份证号码</label>
<input name="idCard" type="text" class="dfinput" value="${dto.customer.idCard}"/><i></i>
</li>
<li><label>业务员</label>
<div class="vocation">
<select class="select1" name="userId">
<!-- 和新增客户区分开 -->
<c:if test="${empty dto}">
<c:forEach items="${ users}" var="user">
<option value="${user.userId }" >
${user.realName }
</option>
</c:forEach>
</c:if>
<c:if test="${not empty dto }">
<shiro:hasAnyRoles name="业务员,操作员">
<option value="${dto.customer.userId }" >${dto.salesMan }</option>
</shiro:hasAnyRoles>
<shiro:hasRole name="管理员">
<c:forEach items="${ users}" var="user">
<option value="${user.userId }" ${user.userId eq dto.customer.userId?"selected":"" } >
${user.realName }
</option>
</c:forEach>
</shiro:hasRole>
</c:if>
</select>
</div>
<i></i>
</li>
<li><label>常用区间</label>
<div class="vocation">
<select class="select1" name="baseId">
<c:forEach items="${ intervals}" var="it">
<option value="${it.baseId }" ${it.baseId eq dto.customer.baseId?"selected":"" }>
${it.baseName }
</option>
</c:forEach>
</select>
</div>
<i></i>
</li>
<li><label>备注</label>
<textarea name="remark" cols="" rows="" class="textinput" >
${dto.customer.remark }
</textarea>
</li>
<li><label> </label>
<input name="" type="submit"
class="btn" value="确认保存" /></li>
</ul>
</form>
</div>
<div style="display: none">
<script src='http://v7.cnzz.com/stat.php?id=155540&web_id=155540'
language='JavaScript' charset='gb2312'></script>
</div>
</body>
</html> 2.5 CustomerController
保存修改的内容
@RequestMapping("/saveOrUpdate")
public String saveOrUpdate(Customer customer) throws IOException{
if(customer.getCustomerId()!=null && !"".equals(customer.getCustomerId())){
// 更新
customerService.updateCustomer(customer);
}else{
// 添加
customerService.addCustomer(customer);
}
return "success";
} 2.6 ICustomerService
public void updateCustomer(Customer customer) 2.7 CustomerServiceImpl
@Override
public void updateCustomer(Customer customer) {
// TODO Auto-generated method stub
customerMapper.updateByPrimaryKey(customer);
} ok 实现~