ssm客户管理系统的设计与实现

ssm客户管理系统

注意：系统是在实现我的上一篇文章 https://www.cnblogs.com/peter-hao/p/ssm.html的基础上开发

1 需求

1.1 添加客户

客户填写信息，提交，将信息保存到数据库中。

1.2 删除客户

在每条查询出来的客户信息设置删除操作，点击即可删除。更新数据库。

1.3 更新客户信息

在每条查询出来的客户信息设置修改操作，点击进入修改界面，提交，更新数据库。

1.4 查询客户

查询所有的客户信息；根据客户名称进行模糊查询；根据客户类型进行查询。

2 编写思路

从后端向前端开始编写的思路。首先，编写dao层的增删改查的方法，这里大部分利用逆向工程生成的mapper接口中的crud的方法，模糊查询和根据客户类型查询则是重新自定义mapper和xml文件。其次，编写service接口和service实现类，通过spring注解开发，在service实现类中注入mapper接口类，在service实现类中调用mapper中的方法，实现crud操作。然后，开发controller层，注入service接口类，调用service接口中的方法，查询到的数据通过视图解析器解析modelAndView传到jsp界面。修改、删除和更新后通过redirect重定向到查询页面，查看操作后的客户信息。

2.1 dao层

2.1.1 逆向工程中mapper接口中的crud的方法。

运用到逆向工程中mapper接口的以下四个方法:

2.1.2 模糊查询的mapper接口和xml

Mapper接口:

public interface CustomMapper {
   public List<HhCustom> findAllCustom(HhCustomVo hhCustomVo)throws Exception;
}

Mapper.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- namespace:命名空间，作用是对sql进行分类化管理，sql隔离 -->
<mapper namespace="cn.haohan.ssm.mapper.CustomMapper">
   <sql id="query_custom_where">
       <if test="hhCustom!=null">
       <if test="hhCustom.name!=null and hhCustom.name!=''">
          name like '%${hhCustom.name}%'
       </if>
       <if test="hhCustom.category!=null and hhCustom.category!=''">
          and category = #{hhCustom.category}
       </if>
       </if>
   </sql>
   <resultMap type="hhCustom" id="hhCustomResultMap">
   <id column="id" property="id"/>
   <result column="phone_number" property="phoneNumber"/>
   </resultMap>
   <select id="findAllCustom" parameterType="cn.haohan.ssm.po.HhCustomVo" resultMap="hhCustomResultMap">
      SELECT
      * FROM hh_custom
       <where>
         <include refid="query_custom_where"></include>
     </where>
   </select>
</mapper>

2.2 service层

2.2.1 service接口

public interface CustomService {
   //根据客户id查询
   public HhCustom findCustomById(Integer id)throws Exception;
   //模糊查询客户信息
   public List<HhCustom> findAllCustom(HhCustomVo hhCustomVo)throws Exception;
   //根据客户id删除客户
   public void deleteCustomById(Integer id)throws Exception;
   //添加用户
   public void addCustom(HhCustom hhCustom)throws Exception;
   //更新用户信息
   public void updateCustom(Integer id,HhCustom hhCustom)throws Exception;
}

2.2.2 service实现类

public class CustomServiceImpl implements CustomService{

   @Autowired
   HhCustomMapper hhCustomMapper;

   @Autowired
   CustomMapper customMapper;

   @Override
   public HhCustom findCustomById(Integer id) throws Exception {
      return hhCustomMapper.selectByPrimaryKey(id);
   }

   @Override
   public List<HhCustom> findAllCustom(HhCustomVo hhCustomVo) throws Exception {
      return customMapper.findAllCustom(hhCustomVo);
   }

   @Override
   public void deleteCustomById(Integer id) throws Exception {
      int row  = hhCustomMapper.deleteByPrimaryKey(id);
   }

   @Override
   public void addCustom(HhCustom hhCustom) throws Exception {
      hhCustomMapper.insertSelective(hhCustom);
   }

   @Override
   public void updateCustom(Integer id, HhCustom hhCustom) throws Exception {
      hhCustom.setId(id);
      hhCustomMapper.updateByPrimaryKeySelective(hhCustom);
   }
}

2.3 controller层

@Controller
public class CustomController {

   @Autowired
   CustomService customService;

   // 客户分类
   // customTypes表示最终将方法返回值放在request域中的key
   @ModelAttribute("customTypes")
   public Map<String, String> getcustomTypes() {
      Map<String, String> customTypes = new HashMap<String, String>();
      customTypes.put("101", "普通客户");
      customTypes.put("102", "意向客户");
      customTypes.put("103", "活跃客户");
      customTypes.put("104", "Vip客户");
      return customTypes;
   }
 
   // 模糊查询客户
   @RequestMapping("/findAllCustom")
   public ModelAndView findAllCustom(HhCustomVo hhCustomVo) throws Exception {
      List<HhCustom> customlist = customService.findAllCustom(hhCustomVo);
      ModelAndView modelAndView = new ModelAndView();
      modelAndView.addObject("customlist", customlist);
      modelAndView.setViewName("customlist");
      return modelAndView;
   }
 
   // 根据客户id查询
   @RequestMapping("/findCustomByid")
   public ModelAndView findCustomByid(Integer id) throws Exception {
      HhCustom hhCustom = customService.findCustomById(id);
      ModelAndView modelAndView = new ModelAndView();
      modelAndView.addObject("hhCustom", hhCustom);
      modelAndView.setViewName("customlist");
      return modelAndView;
   }

   // 添加客户
   // String返回逻辑视图名，在springmvc中配置的视图解析器中配置jsp文件前后缀
   @RequestMapping("/addCustom")
   public String addCustom() throws Exception {
      return "add_custom";
   }

   // 添加客户submit
   @RequestMapping("/addCustomSubmit")
   public String addCustomSubmit(HhCustom hhCustom) throws Exception {
      customService.addCustom(hhCustom);
      // 重定向
      return "redirect:findAllCustom.action";
   }

   // 删除客户
   @RequestMapping("/deleteCustom")
   public String deleteCustom(Integer id) throws Exception {
      customService.deleteCustomById(id);
      return "redirect:findAllCustom.action";
   }

   // 更新客户信息
   @RequestMapping("/updateCustom")
   public String updateCustom(Model model, Integer id) throws Exception {
      HhCustom hhCustom = customService.findCustomById(id);
      model.addAttribute("hhCustom", hhCustom);
      return "update_custom";
   }

   // 更新客户信息submit
   @RequestMapping("/updateCustomSubmit")
   public String updateCustomSubmit(Integer id, HhCustom hhCustom) throws Exception {
      customService.updateCustom(id, hhCustom);
      return "redirect:findAllCustom.action";
   }
}

2.4 jsp界面

2.4.1 customlist.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://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<!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">
<script type="text/javascript">
function addCustom(){
document.customForm.action="${pageContext.request.contextPath}/addCustom.action";
   document.customForm.submit();
}
</script>
<title>客戶列表</title>
</head>
<body>
  <form name="customForm"
 action="${pageContext.request.contextPath}/findAllCustom.action"      method="post">
      查询条件：
      <table width="100%" border=1>
         <tr>
            <td>客戶名称：<input name="hhCustom.name" />
            </td>
            <td>客戶类型： <select name="hhCustom.category">
                   <option selected="selected"></option>
                  <c:forEach items="${customTypes}" var="customType">
                      <option value="${customType.value }">${customType.value}</option>
                   </c:forEach>
            </select>
            </td>
           <td><button type="submit" value="查询" >查询</button></td>
            <td><input type="button" value="添加客户" onclick="addCustom()"/></td>
         </tr>
      </table>
      客戶列表：
      <table width="100%" border=1>
         <tr>
            <!-- <th>选择</th>  -->
            <th>客戶名称</th>
            <th>客戶邮箱</th>
            <th>客戶电话</th>
            <th>客户类型</th>
            <th>操作</th>
         </tr>
         <c:forEach items="${customlist}" var="custom">
            <tr>
                <%-- <td><input type="checkbox" name="custom_id" value="${custom.id}" /></td> --%>
                <td>${custom.name }</td>
                <td>${custom.mail }</td>
                <td>${custom.phoneNumber }</td>
                <td>${custom.category }</td>
                <%--<td><fmt:formatDate value="${custom.birthday }" pattern="yyyy-MM-dd HH:mm:ss"/></td>--%>
                <td><a href="${pageContext.request.contextPath }/updateCustom.action?id=${custom.id }">修改</a>
                  <a href="${pageContext.request.contextPath }/deleteCustom.action?id=${custom.id }">删除</a>
                </td>
            </tr>
         </c:forEach>
      </table>
   </form>
</body>
</html>

2.4.2 add_custom.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://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<!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>
</head>
<body>
<form id="customForm" action="${pageContext.request.contextPath}/addCustomSubmit.action" method="post">
添加客户信息：
<table width="100%" border=1>
   <tr>
      <td>客户名称</td>
      <td><input type="text" name="name" /></td>
   </tr>
   <tr>
      <td>客户邮箱</td>
      <td><input type="text" name="mail" /></td>
   </tr>
   <tr>
      <td>客户电话号码</td>
      <td><input type="text" name="phoneNumber" /></td>
   </tr>
   <tr>
      <td>客户类型</td>
      <td><select name="category">
         <c:forEach items="${customTypes}" var="customType">
            <%-- <option value="${customType.key }">${customType.value}</option> --%>
            <option value="${customType.value }">${customType.value}</option>
         </c:forEach>
      </select>
      </td>
   </tr>
</table>
   <input type="submit" value="提交">
   <input type="reset" value="重置">
</form>
</body>
</html>

2.4.3 update_custom.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://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<!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>
</head>
<body>
   <form id="customForm"      action="${pageContext.request.contextPath}/updateCustomSubmit.action"
      method="post">
      <input type="hidden" name="id" value="${hhCustom.id }" /> 修改客户信息：
      <table width="100%" border=1>
         <tr>
            <th>客户名称</th>
            <td><input type="text" name="name" value="${hhCustom.name }" /></td>
         </tr>
         <tr>
            <td>客户邮箱</td>
           <td><input type="text" name="mail" value="${hhCustom.mail }" /></td>
         </tr>
         <tr>
            <td>客户电话号码</td>
            <td><input type="text" name="phoneNumber"
                value="${hhCustom.phoneNumber }" /></td>
         </tr>
         <tr>
            <td>客户类型</td>
            <td><select name="category">
　　        <c:forEach items="${customTypes}" var="customType">
                      <%-- <option value="${customType.key }">${customType.value}</option> --%>
                      <c:if test="${hhCustom.category==customType.value }">
                         <option value="${customType.value }" selected="selected">${customType.value }</option>
                      </c:if>                    
                         <option value="${customType.value }" >${customType.value}</option>    
                   </c:forEach>
            </select></td>
           <%-- <td><input type="text" name="category" value="${hhCustom.category }"/></td> --%>
         </tr>
      </table>
      <input type="submit" value="提交">
   </form>
</body>
</html>