SpringMVC+mybatis+maven+登录注册+增删改查

红太狼 2022-02-22 15:46 294阅读 0赞

# 一.SpringMVC #

MVC框架是由Model模型（JavaBean），View视图(Jsp) 和 Controller控制器(Servlet)构成。

其中每一部分的作用为：

1.  Model：承载数据，并对用户提交请求进行计算的模块。其分为两类，一类称为数据承载Bean，一类称为业务处理Bean。所谓数据承载Bean是指实体类，专门承载业务数据的，如Student、User等。而业务处理Bean则是指Service或Dao对象，专门用于处理用户提交请求的。
2.  View：为用户提供使用界面，与用户直接进行交互
3.  Controller：用于将用户请求转发给相应的Model进行处理，并将处理Model的计算结果向用户提供相应响应。

# 二.SpringMVC+mybatis各层关系 #

**Controller层（springMVC）**通过要调用Service层的接口来控制业务流程，负责url映射（action），控制界面跳转。  
**Service层（Spring）**负责业务模块的逻辑应用设计。首先设计其接口，然后再实现他的实现类（Serviceimpl类）。  
通过对Spring配置文件中配置其实现的关联，完成此步工作，我们 就可以通过调用Service的接口来进行业务处理。最后通过调用DAO层已定义的接口，去实现Service具体的实现类。  
**Dao层/Mapper层（Mybatis）**负责与数据库进行交互设计，用来处理数据的持久化工作。DAO层的设计首先是设计DAO的接口，然后在Spring的配置文件中定义此接口的实现类，就可在其他模块中调用此接口来进行数据业务的处理，而不用关心接口的具体实现类是哪个类，这里用到的就是反射机制， DAO层的数据源配置，以及有关数据库连接的参数都在Spring的配置文件中进行配置。  
**View层（视图层）**负责前台jsp页面的展示。

# 二.项目简介 #

**简单的用户管理项目：实现用户登录注册，以及对用户信息的增删改查功能。**

**![20190410083804412.gif][]**

##                                                      项目流程图 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMzIwMDQ4_size_16_color_FFFFFF_t_70][]

# 四.源码实现 #

### 文件目录 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMzIwMDQ4_size_16_color_FFFFFF_t_70 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMzIwMDQ4_size_16_color_FFFFFF_t_70 2][]![20190410133750899.png][]

### **JSP文件：** ###

**1.login.jsp**

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
        <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
     <!DOCTYPE html>
    <html lang="zh-CN">
    <head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
          <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
    <title>登录页面</title>
    </head>
    <body style="background:url('http://localhost:8080/maven02/resources/img/backimg.jpg') no-repeat;background-size: cover;">
    <div style="width:33% ;height:300px;margin:100px auto;border-radius:25px;;box-shadow: 5px 5px 5px #888888;background-color: white">
    	<img src="http://localhost:8080/maven02/resources/img/IDcard.png" style="width: 50px;height: 50px;position:absolute;left:649px;top:76px;"/>
    	<form class="form-horizontal" method="POST" id="form" style="position:absolute;left:492px;top:152px;">
      <div class="form-group">
        <label for="inputEmail3" class="col-sm-2 control-label" style="padding-right:5px">用户名:</label>
        <div class="col-sm-10">
          <input type="text" class="form-control" name="username" id="inputEmail3"style="width:285px;" >
        </div>
      </div>
      <div class="form-group">
        <label for="inputPassword3" class="col-sm-2 control-label" style="padding-right:5px">密码:</label>
        <div class="col-sm-10">
          <input type="password" class="form-control" id="inputPassword3" name="password" style="width:285px;">
        </div>
      </div>
      <div class="form-group">
        <div class="col-sm-offset-2 col-sm-10" style="width:202px;margin:10px auto;float:left">
          <button type="submit" class="btn btn-default btn-info" style="width:170px; margin:10px auto" onclick="login()">登录</button>
        </div>
        <div class="col-sm-offset-2 col-sm-10" style="width:202px;margin:10px auto;float:left">
          <button type="submit" class="btn btn-default btn-info "style="width:170px; margin:10px auto" onclick="registe()">注册</button>
        </div>
      </div>
     </div>
    </form>
      
          <script src="https://code.jquery.com/jquery.js"></script>
    </body>
    <script type="text/javascript">
    var login=function(){
    	$("#form").attr("action","http://localhost:8080/maven02/user/userlogin");
    	$("#form").submit();
    };
    var registe=function(){
    	$("#form").attr("action","http://localhost:8080/maven02/user/registration");
    	$("#form").submit();
    };
    </script>
    </html>

**2.registration.jsp**

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <!DOCTYPE html>
    <html lang="zh-CN">
    <head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
          <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
    <title>修改用户信息页面</title>
    </head>
    <body>
    <div style="width:50%;margin:10px auto">
    <div style="height:70px;">
    <h1 style="font: bold em Brush Script MT ; color:#222; text-shadow: 0px 2px 3px #666;float:left;">User Management<h1/>
    <img src="http://localhost:8080/maven02/resources/img/List.png" style="width: 50px;height: 50px;float:left;margin-top: 13px;"/>
    </div>
    	<form class="form-horizontal" action="http://localhost:8080/maven02/user/useradd" method="POST">
      <div class="form-group">
        <label class="col-sm-2 control-label">用户名:</label>
        <div class="col-sm-10 center-block">
         <input type="text" class="form-control" name="username" id="inputEmail3"> 
        </div>
      </div>
      <div class="form-group">
        <label for="inputPassword3" class="col-sm-2 control-label">密码</label>
        <div class="col-sm-10">
          <input type="password" class="form-control" id="inputPassword3" name="password">
        </div>
      </div>
      <div class="form-group">
        <label for="inputPassword3" class="col-sm-2 control-label">联系方式</label>
        <div class="col-sm-10">
          <input type="password" class="form-control" id="inputPassword3" name="phonenum">
        </div>
      </div>
      <div class="form-group">
        <div class="col-sm-offset-2 col-sm-10">
          <button type="submit" class="btn btn-default">确定</button>
        </div>
      </div>
    </form>
    </div>
      
          <script src="https://code.jquery.com/jquery.js"></script>
          
          <script src="js/bootstrap.min.js"></script>
          <script type="text/javascript">
    	$(function(){
    		if(""=="${code}"){
    			console.log("没有异常");
    		}else if("500"=="${code}"){
    			alert("${msg}");
    		}
    	});
    </script>
    </body>
    </html>

**3.userList.jsp**

<%@ page language="java" contentType="text/html; charset=UTF-8"
    	pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
    <!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>Insert title here</title>
    <jsp:include page="../_header.jsp" />
    </head>
    <body>
    <div style="width:80%;margin:10px auto">
    <div style="height:70px;">
    <h1 style="font: bold em Brush Script MT ; color:#222; text-shadow: 0px 2px 3px #666;float:left;">User Management<h1/>
    <img src="http://localhost:8080/maven02/resources/img/List.png" style="width: 50px;height: 50px;float:left;margin-top: 13px;"/>
    </div>
    	<form id="select" method="post" action="http://localhost:8080/maven02/user/select" style="margin-left: 631px">
    		<input id="selectbyname" class="form-control" type="text" name="selectbyname"  placeholder="请输入用户名" style="width:200px;float:left;margin-top: 19px;"/>
        	<div class="col-sm-offset-2 col-sm-10 form-group" style="width:202px;margin:10px auto;float:left">
        	  <button type="submit" class="btn btn-default btn-info" style="width:170px; margin:10px auto">查询</button>
       	 </div>
    	</form>
    	<form id="form1"  method="post">
    		<table class="table table-hover table-striped">
    			<tr>
    				<th>用户账号</th>
    				<th>用户密码</th>
    				<th>联系方式</th>
    				<th>操作</th>
    			</tr>
    			<c:forEach items="${userList}" var="user">
    				<tr>
    					<td>${user.user_name }</td>
    					<td>${user.user_password }</td>
    					<td>${user.user_phonenum }</td>
    					<td>
    						<div class="btn btn-default" onclick="update('${user.user_name}')">更新</div>
    						<div class="btn btn-default" onclick="deleteUser(${user.user_id})">删除</div>
    					</td>
    				</tr>
    			</c:forEach>
    		</table>
    		<input id="user_name" type="hidden" name="username" />
    		<input id="user_id" type="hidden" name="userid" />
    	</form>
    	</div>
    </body>
    <jsp:include page="../_footer.jsp" flush="true" />
    <script src="https://code.jquery.com/jquery.js"></script>
    <script type="text/javascript">
    $(function(){
    	if(""=="${code}"){
    		console.log("没有异常");
    	}else if("200"=="${code}"){
    		alert("${msg}");
    	}
    });
    var user_name;
    var update=function(user_name){
    	$("#user_name").val(user_name);
    	$("#form1").attr("action","http://localhost:8080/maven02/user/toUpdate");
    	$("#form1").submit();
    };
    var deleteUser=function(id){
    	$("#user_id").val(id);
    	$("#form1").attr("action","http://localhost:8080/maven02/user/delete");
    	$("#form1").submit();
    };
    /* var deleteUser=function(id){
    	$.ajax({
    		"url":"http://localhost:8080/maven02/user/delete",
    		"data":{"id":id},
    		"dataType":"JSON",
    		"type":"post",
    		success:function(data){
    			if(data.code==200){
    				alert(data.msg);
    			}else{
    				alert(data.msg);
    			}
    			
    		},
    		error:function(){
    			
    		}
    	}); 
    }*/
    </script>
    </html>

**4.userEdit.jsp**

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <!DOCTYPE html>
    <html lang="zh-CN">
    <head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
          <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
    <title>修改用户信息页面</title>
    </head>
    <body>
    <div style="width:80%;margin:10px auto">
    <div style="height:70px;margin-left: 390px;">
    <h1 style="font: bold em Brush Script MT ; color:#222; text-shadow: 0px 2px 3px #666;float:left;">User Management<h1/>
    <img src="http://localhost:8080/maven02/resources/img/List.png" style="width: 50px;height: 50px;float:left;margin-top: 13px;"/>
    </div>
    	<form class="form-horizontal" action="http://localhost:8080/maven02/user/update" method="POST">
      <div class="form-group">
        <label class="col-sm-2 control-label">用户名:</label>
        <div class="col-sm-10 center-block">
         <input type="text" class="form-control" name="username" id="inputEmail3" value="${user.user_name}"> 
        </div>
      </div>
      <div class="form-group">
        <label for="inputPassword3" class="col-sm-2 control-label">密码</label>
        <div class="col-sm-10">
          <input type="password" class="form-control" id="inputPassword3" name="password" value="${user.user_password}">
        </div>
      </div>
      <div class="form-group">
        <label for="inputPassword3" class="col-sm-2 control-label">联系方式</label>
        <div class="col-sm-10">
          <input type="password" class="form-control" id="inputPassword3" name="phonenum" value="${user.user_phonenum}">
        </div>
      </div>
      <div class="form-group">
        <div class="col-sm-offset-2 col-sm-10">
          <button type="submit" class="btn btn-default">确定</button>
        </div>
      </div>
    </form>
    </div>
      
          <script src="https://code.jquery.com/jquery.js"></script>
          
          <script src="js/bootstrap.min.js"></script>
          <script type="text/javascript">
    	$(function(){
    		if(""=="${code}"){
    			console.log("没有异常");
    		}else if("500"=="${code}"){
    			alert("${msg}");
    		}
    	});
    </script>
    </body>
    </html>

**5.error.jsp**

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <!DOCTYPE html>
    <html>
    <head>
    <meta charset="UTF-8">
    <title>错误页面</title>
    </head>
    <body>
    错误页面
    </body>
    </html>

**6.success.jsp**

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <!DOCTYPE html>
    <html>
    <head>
    <meta charset="UTF-8">
    <title>登陆成功</title>
    </head>
    <body>
    登陆成功
    </body>
    </html>

### Controller层 ###

**7.Login.java**

package com.javen.controller;
    
    import java.util.ArrayList;
    import java.util.List;
    
    import javax.servlet.http.HttpServletRequest;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestMethod;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    import com.javen.vo.UserVO;
    import com.javen.model.User;
    import com.javen.service.IuserInfoService;
    
    @Controller
    @RequestMapping("/user")
    public class Login {
    	
    	@Autowired
    	private IuserInfoService login;
    	@RequestMapping("index")
    	public String Index() {
    		return "login";
    	}
    	
    	@RequestMapping(value = "/userlogin")
    	public String user(HttpServletRequest request, Model model, UserVO userVo) {
    		System.err.println(userVo);
    		User select = login.selectByName(userVo.getUsername());
    		if(login.selectByAS(request.getParameter("username"), request.getParameter("password"))==1) {
    			request.getSession().setAttribute("userId", select.getUser_id());// 写入session
    			List<User> selectAll = login.selectAll();
    			model.addAttribute("userList", selectAll);
    			return "userList";
    		}else {
    			return "error1";
    		}
    	}
    	@RequestMapping("/select")
    	public String select(HttpServletRequest request, Model model) {
    		System.err.println(request.getParameter("selectbyname"));
    		User a = login.selectByName(request.getParameter("selectbyname"));
    		List<User> select=new ArrayList<User>();
    		select.add(a);
    		System.err.println("查询"+select);
    			model.addAttribute("userList", select);
    			return "userList";
    	}
    	
    	@RequestMapping("/userList")
    	public String userList(HttpServletRequest request, Model model, UserVO userVo) {
    		Object attribute = request.getSession().getAttribute("userId");
    		if (attribute != null) {
    			List<User> selectAll = login.selectAll();
    			model.addAttribute("userList", selectAll);
    			System.err.println(attribute.toString());
    			return "userList";
    		}else {
    			return "user/index";
    		}
    	}
    	
    	@RequestMapping("/toUpdate")
    	public String toUpdate(UserVO userVo, Model model) {
    		System.err.println(userVo);
    		User select = login.selectByName(userVo.getUsername());
    		model.addAttribute("user", select);
    		return "userEdit";
    
    	}
    	
    	@RequestMapping("/update")
    	public String update(UserVO userVO, Model model) {
    		System.err.println(userVO);
    		User user = login.selectByName(userVO.getUsername());
    		//user.setUser_name(userVO.getUsername());//用户名不可修改，因为查询USER是按照用户名查找的
    		user.setUser_password(userVO.getPassword());
    		user.setUser_phonenum(userVO.getPhonenum());
    		System.err.println(user);
    		login.updateById(user);
    		List<User> selectAll = login.selectAll();
    		model.addAttribute("userList", selectAll);
    		if (true) {
    			model.addAttribute("code", "200");
    			model.addAttribute("msg", "成功");
    			return "userList";
    		} else {
    			model.addAttribute("code", "500");
    			model.addAttribute("msg", "ssss更失败了");
    			return toUpdate(userVO, model);
    		}
    	}
    	
    	@RequestMapping("/delete")
    	public String delete(UserVO userVO,Model model) {
    		System.err.println(userVO.getUserid());
    		login.deleteById(userVO.getUserid());
    		List<User> selectAll = login.selectAll();
    		model.addAttribute("userList", selectAll);
    		/*
    		 * if (true) { responseVO.setCode(200); responseVO.setMsg("sssss成功"); return
    		 * "user/userList"; } else { responseVO.setCode(500); responseVO.setMsg("失败");
    		 * return "error1"; }
    		 */
    		return "userList";
    	}
    	
    	@RequestMapping("/registration")
    	public String registration() {
    		return "registration";
    	}
    	
    	@RequestMapping("/useradd")
    	public String useradd(UserVO userVO,Model model) {
    		System.err.println(userVO);
    		User user=new User(userVO.getUsername(), userVO.getPassword(),"0",userVO.getPhonenum());
    		login.insert(user);
    		return "login";
    	}
    
    
    }

### Dao层 ###

**8.UserMapping.java**

package com.javen.dao;
    
    import java.util.List;
    
    import com.javen.model.User;
    
    public interface UserMapper {
        int deleteByPrimaryKey(Integer user_id);
    
        int insert(User record);
    
        int insertSelective(User record);
    
        User selectByPrimaryKey(Integer user_id);
        
        User selectByName(String user_name);
    
        int updateByPrimaryKeySelective(User record);
    
        int updateByPrimaryKey(User record);
        
        List<User> selectAll();
        
    	int selectByAS(String account, String password);
    }

### **Mapping层** ###

**9.UserMapping.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">
    <mapper namespace="com.javen.dao.UserMapper">
      <resultMap id="BaseResultMap" type="com.javen.model.User">
        <id column="user_id" jdbcType="INTEGER" property="user_id" />
        <result column="user_name" jdbcType="VARCHAR" property="user_name" />
        <result column="user_password" jdbcType="VARCHAR" property="user_password" />
        <result column="user_Identity" jdbcType="VARCHAR" property="user_Identity" />
        <result column="user_phonenum" jdbcType="VARCHAR" property="user_phonenum" />
      </resultMap>
      
      <sql id="Base_Column_List">
        user_id, user_name, user_password, user_Identity, user_phonenum
      </sql>
      
      <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
        select 
        <include refid="Base_Column_List" />
        from user_information_copy1
        where user_id = #{user_id,jdbcType=INTEGER}
      </select>
      
        <select id="selectByName" parameterType="java.lang.String" resultMap="BaseResultMap">
        select 
        <include refid="Base_Column_List" />
        from user_information_copy1
        where user_name = #{user_name,jdbcType=VARCHAR}
      </select>
      
      <select id="selectByAS" resultType="java.lang.Integer">
        select 
        count(*)
        from user_information_copy1
        where user_name = #{0} and user_password = #{1}
      </select>
      
       <select id="selectAll" resultMap="BaseResultMap">
        select 
        <include refid="Base_Column_List" />
        from user_information_copy1
      </select>
      
      <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
        delete from user_information_copy1
        where user_id = #{user_id,jdbcType=INTEGER}
      </delete>
      
      <insert id="insert" parameterType="com.javen.model.User">
        insert into user_information_copy1 (user_name,user_password,user_Identity,user_phonenum)
        values (#{user_name,jdbcType=VARCHAR}, #{user_password,jdbcType=VARCHAR}, 
         #{user_Identity,jdbcType=VARCHAR}, #{user_phonenum,jdbcType=VARCHAR})
      </insert>
      
      <insert id="insertSelective" parameterType="com.javen.model.User">
        insert into "user_information_copy1"
        <trim prefix="(" suffix=")" suffixOverrides=",">
          <if test="user_id != null">
            user_id,
          </if>
          <if test="user_name != null">
            user_name,
          </if>
          <if test="user_password != null">
            user_password,
          </if>
          <if test="user_Identity != null">
            user_Identity,
          </if>
          <if test="user_phonenum != null">
            user_phonenum,
          </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
          <if test="user_id != null">
            #{user_id,jdbcType=INTEGER},
          </if>
          <if test="user_name != null">
            #{user_name,jdbcType=VARCHAR},
          </if>
          <if test="user_password != null">
            #{user_password,jdbcType=VARCHAR},
          </if>
          <if test="user_Identity != null">
            #{user_Identity,jdbcType=VARCHAR},
          </if>
          <if test="user_phonenum != null">
            #{user_phonenum,jdbcType=VARCHAR},
          </if>
        </trim>
      </insert>
      
      <update id="updateByPrimaryKeySelective" parameterType="com.javen.model.User">
        update "user_information_copy1"
        <set>
          <if test="user_name != null">
            user_name = #{user_name,jdbcType=VARCHAR},
          </if>
          <if test="user_password != null">
            user_password = #{user_password,jdbcType=VARCHAR},
          </if>
          <if test="user_Identity != null">
            user_Identity = #{user_Identity,jdbcType=VARCHAR},
          </if>
          <if test="user_phonenum != null">
            user_phonenum = #{user_phonenum,jdbcType=VARCHAR},
          </if>
        </set>
        where user_id = #{user_id,jdbcType=INTEGER}
      </update>
      
      <update id="updateByName" parameterType="com.javen.model.User">
        update "user_information_copy1"
        set user_name = #{user_name,jdbcType=VARCHAR},
          user_password = #{user_password,jdbcType=VARCHAR},
          user_phonenum = #{user_phonenum,jdbcType=VARCHAR}
        where user_name = #{user_name,jdbcType=VARCHAR}
      </update>
    <update id="updateByPrimaryKey" parameterType="com.javen.model.User">
        update user_information_copy1
        set user_name = #{user_name,jdbcType=VARCHAR},
            user_password = #{user_password,jdbcType=VARCHAR},
            user_Identity = #{user_Identity,jdbcType=VARCHAR},
            user_phonenum = #{user_phonenum,jdbcType=VARCHAR}
        where user_id = #{user_id,jdbcType=INTEGER}
      </update>
    </mapper>

### model层（实体层） ###

**10.User.java**

package com.javen.model;
    
    public class User {
        private Integer user_id;
    
        private String user_name;
    
        private String user_password;
    
        private String user_Identity;
    
        private String user_phonenum;
    
        public Integer getUser_id() {
            return user_id;
        }
    
        public void setUser_id(Integer user_id) {
            this.user_id = user_id;
        }
    
        public User(String user_name, String user_password, String user_Identity, String user_phonenum) {
    		super();
    		this.user_name = user_name;
    		this.user_password = user_password;
    		this.user_Identity = user_Identity;
    		this.user_phonenum = user_phonenum;
    	}
        
        public User() {
        	
        }
    
    	public String getUser_name() {
            return user_name;
        }
    
        public void setUser_name(String user_name) {
            this.user_name = user_name == null ? null : user_name;
        }
    
        public String getUser_password() {
            return user_password;
        }
    
        public void setUser_password(String user_password) {
            this.user_password = user_password == null ? null : user_password.trim();
        }
    
        public String getUser_Identity() {
            return user_Identity;
        }
    
        public void setUser_Identity(String user_Identity) {
            this.user_Identity = user_Identity == null ? null : user_Identity.trim();
        }
    
        public String getUser_phonenum() {
            return user_phonenum;
        }
    
        public void setUser_phonenum(String user_phonenum) {
            this.user_phonenum = user_phonenum == null ? null : user_phonenum.trim();
        }
    
    	@Override
    	public String toString() {
    		return "User [user_id=" + user_id + ", user_name=" + user_name + ", user_password=" + user_password
    				+ ", user_Identity=" + user_Identity + ", user_phonenum=" + user_phonenum + "]";
    	}
        
    }

### Service层 ###

**11.IuserInfoService.java**

package com.javen.service;
    
    import java.util.List;
    
    import com.javen.model.User;
    
    public interface IuserInfoService {
    	int insert(User useradd);
        int insertSelective(User useradd);
        User selectById(Integer userid);
      User selectByName(String user_name);
        int deleteById(Integer userid);
        int updateById(User useradd);
        int selectByAS(String account,String password);
        List<User> selectAll();
    }

### ServiceImpl层 ###

**12.IuserInfoServiceimpl**

package com.javen.service.impl;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import com.javen.dao.UserMapper;
    import com.javen.model.User;
    import com.javen.service.IuserInfoService;
    @Service()
    public class IuserInfoServiceimpl implements IuserInfoService {
    	@Autowired
        private UserMapper userdao;
    	public int insert(User useradd) {
    		// TODO Auto-generated method stub
    		return this.userdao.insert(useradd);
    	}
    	public List<User> selectAll() {
    		return this.userdao.selectAll();
    	}
        
    	public int selectByAS(String account, String password) {
    		if(userdao.selectByAS(account, password) == 1) {
    			return 1;
    		}
    		else {
    			return 0;
    		}
    	}
    	
    	public int insertSelective(User useradd) {
    		// TODO Auto-generated method stub
    		return this.userdao.insertSelective(useradd);
    	}
    
    	public User selectById(Integer userid) {
    		// TODO Auto-generated method stub
    		return this.userdao.selectByPrimaryKey(userid);
    	}
    
    	public int deleteById(Integer userid) {
    		// TODO Auto-generated method stub
    		return this.userdao.deleteByPrimaryKey(userid);
    	}
    
    	public int updateById(User user) {
    		// TODO Auto-generated method stub
    		System.err.println("222"+user);
    		return this.userdao.updateByPrimaryKey(user);
    	}
    	
    	public User selectByName(String user_name)
    	{
    		return this.userdao.selectByName(user_name);
    	}
    }

### VO层（用来接收前台数据的实体类） ###

**13.UserVO.java**

package com.javen.vo;
    
    import java.util.Date;
    
    public class UserVO {
        private String username;
    
        private String password;
        
        private String phonenum;
        
        private Integer userid;
    
    	public Integer getUserid() {
    		return userid;
    	}
    
    	public void setUserid(Integer userid) {
    		this.userid = userid;
    	}
    
    	public String getUsername() {
    		return username;
    	}
    
    	public String getPhonenum() {
    		return phonenum;
    	}
    
    	public void setPhonenum(String phonenum) {
    		this.phonenum = phonenum;
    	}
    
    	public void setUsername(String username) {
    		this.username = username;
    	}
    
    	public String getPassword() {
    		return password;
    	}
    
    	public void setPassword(String password) {
    		this.password = password;
    	}
    
    	@Override
    	public String toString() {
    		return "UserVO [username=" + username + ", password=" + password + ", phonenum=" + phonenum + ", userid="
    				+ userid + "]";
    	}
    
    
    
    
    }

### 配置文件 ###

**14.web.xml**

<?xml version="1.0" encoding="UTF-8"?>
    <web-app id="WebApp_ID" version="3.0" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
      <display-name>Archetype Created Web Application</display-name>
      <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:spring-mybatis.xml</param-value>
      </context-param>
      <filter>
        <filter-name>encodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <async-supported>true</async-supported>
        <init-param>
          <param-name>encoding</param-name>
          <param-value>UTF-8</param-value>
        </init-param>
      </filter>
      <filter-mapping>
        <filter-name>encodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
      </filter-mapping>
      <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
      <listener>
        <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
      </listener>
      <servlet>
        <servlet-name>SpringMVC</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
          <param-name>contextConfigLocation</param-name>
          <param-value>classpath:spring-mvc.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
        <async-supported>true</async-supported>
      </servlet>
      <servlet-mapping>
        <servlet-name>SpringMVC</servlet-name>
        <url-pattern>/</url-pattern>
      </servlet-mapping>
      <welcome-file-list>
        <welcome-file>/index.jsp</welcome-file>
      </welcome-file-list>
      <display-name>maven02</display-name>
      <welcome-file-list>
        <welcome-file>index.html</welcome-file>
        <welcome-file>index.htm</welcome-file>
        <welcome-file>index.jsp</welcome-file>
        <welcome-file>default.html</welcome-file>
        <welcome-file>default.htm</welcome-file>
        <welcome-file>default.jsp</welcome-file>
      </welcome-file-list>
    </web-app>

**15.pom.xml**

<project xmlns="http://maven.apache.org/POM/4.0.0"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    	<modelVersion>4.0.0</modelVersion>
    	<groupId>com.javen.maven02</groupId>
    	<artifactId>maven02</artifactId>
    	<packaging>war</packaging>
    	<version>0.0.1-SNAPSHOT</version>
    	<name>maven01 Maven Webapp</name>
    	<url>http://maven.apache.org</url>
    
    	<properties>
    		
    		<spring.version>4.0.2.RELEASE</spring.version>
    		
    		<mybatis.version>3.2.6</mybatis.version>
    		
    		<slf4j.version>1.7.7</slf4j.version>
    		<log4j.version>1.2.17</log4j.version>
    	</properties>
    
    	<dependencies>
    		<dependency>
    			<groupId>junit</groupId>
    			<artifactId>junit</artifactId>
    			<version>3.8.1</version>
    			
    			<scope>test</scope>
    		</dependency>
    		
    
    		
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-core</artifactId>
    			<version>${spring.version}</version>
    		</dependency>
    
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-web</artifactId>
    			<version>${spring.version}</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-oxm</artifactId>
    			<version>${spring.version}</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-tx</artifactId>
    			<version>${spring.version}</version>
    		</dependency>
    
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-jdbc</artifactId>
    			<version>${spring.version}</version>
    		</dependency>
    
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-webmvc</artifactId>
    			<version>${spring.version}</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-aop</artifactId>
    			<version>${spring.version}</version>
    		</dependency>
    
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-context-support</artifactId>
    			<version>${spring.version}</version>
    		</dependency>
    
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-test</artifactId>
    			<version>${spring.version}</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis</artifactId>
    			<version>${mybatis.version}</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis-spring</artifactId>
    			<version>1.2.2</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>javax</groupId>
    			<artifactId>javaee-api</artifactId>
    			<version>7.0</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<version>5.1.36</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>commons-dbcp</groupId>
    			<artifactId>commons-dbcp</artifactId>
    			<version>1.2.2</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>jstl</groupId>
    			<artifactId>jstl</artifactId>
    			<version>1.2</version>
    		</dependency>
    		
    		
    		<dependency>
    			<groupId>log4j</groupId>
    			<artifactId>log4j</artifactId>
    			<version>${log4j.version}</version>
    		</dependency>
    
    
    		
    		<dependency>
    			<groupId>com.alibaba</groupId>
    			<artifactId>fastjson</artifactId>
    			<version>1.1.41</version>
    		</dependency>
    
    
    		<dependency>
    			<groupId>org.slf4j</groupId>
    			<artifactId>slf4j-api</artifactId>
    			<version>${slf4j.version}</version>
    		</dependency>
    
    		<dependency>
    			<groupId>org.slf4j</groupId>
    			<artifactId>slf4j-log4j12</artifactId>
    			<version>${slf4j.version}</version>
    		</dependency>
    		
    		
    		<dependency>
    			<groupId>org.codehaus.jackson</groupId>
    			<artifactId>jackson-mapper-asl</artifactId>
    			<version>1.9.13</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>commons-fileupload</groupId>
    			<artifactId>commons-fileupload</artifactId>
    			<version>1.3.1</version>
    		</dependency>
    		<dependency>
    			<groupId>commons-io</groupId>
    			<artifactId>commons-io</artifactId>
    			<version>2.4</version>
    		</dependency>
    		<dependency>
    			<groupId>commons-codec</groupId>
    			<artifactId>commons-codec</artifactId>
    			<version>1.9</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.mybatis.generator</groupId>
    			<artifactId>mybatis-generator-core</artifactId>
    			<version>1.3.2</version>
    		</dependency>
    	</dependencies>
    
    	<build>
    		<finalName>maven02</finalName>
    		<plugins>
    			
    			
    
    
    		</plugins>
    	</build>
    
    </project>

**16.jdbc.properties**

driver=com.mysql.jdbc.Driver
    url=jdbc:mysql://Localhost:3306/car
    username=root
    password=123456
    #定义初始连接数  
    initialSize=0  
    #定义最大连接数  
    maxActive=20  
    #定义最大空闲  
    maxIdle=20  
    #定义最小空闲  
    minIdle=1  
    #定义最长等待时间  
    maxWait=60000

**17.log4j.properties**

log4j.rootLogger=INFO,Console,File  
    #定义日志输出目的地为控制台  
    log4j.appender.Console=org.apache.log4j.ConsoleAppender  
    log4j.appender.Console.Target=System.out  
    #可以灵活地指定日志输出格式，下面一行是指定具体的格式  
    log4j.appender.Console.layout = org.apache.log4j.PatternLayout  
    log4j.appender.Console.layout.ConversionPattern=[%c] - %m%n  
      
    #文件大小到达指定尺寸的时候产生一个新的文件  
    log4j.appender.File = org.apache.log4j.RollingFileAppender  
    #指定输出目录  
    log4j.appender.File.File = logs/ssm.log  
    #定义文件最大大小  
    log4j.appender.File.MaxFileSize = 10MB  
    # 输出所以日志，如果换成DEBUG表示输出DEBUG以上级别日志  
    log4j.appender.File.Threshold = ALL  
    log4j.appender.File.layout = org.apache.log4j.PatternLayout  
    log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH\:mm\:ss}][%c]%m%n

**18.spring-mvc.xml**

<?xml version="1.0" encoding="UTF-8"?>  
    <beans xmlns="http://www.springframework.org/schema/beans"  
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"  
        xmlns:context="http://www.springframework.org/schema/context"  
        xmlns:mvc="http://www.springframework.org/schema/mvc"  
        xsi:schemaLocation="http://www.springframework.org/schema/beans    
                            http://www.springframework.org/schema/beans/spring-beans-3.1.xsd    
                            http://www.springframework.org/schema/context    
                            http://www.springframework.org/schema/context/spring-context-3.1.xsd    
                            http://www.springframework.org/schema/mvc    
                            http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">  
          
        <context:component-scan base-package="com.javen.controller" />  
        
        <mvc:annotation-driven/>
        
        <mvc:resources location="/resources/" mapping="/resources/**"/>
        
          
        <bean id="mappingJacksonHttpMessageConverter"  
            class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">  
            <property name="supportedMediaTypes">  
                <list>  
                    <value>text/html;charset=UTF-8</value>  
                </list>  
            </property>  
        </bean>  
          
        <bean  
            class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">  
            <property name="messageConverters">  
                <list>  
                    <ref bean="mappingJacksonHttpMessageConverter" />   
                </list>  
            </property>  
        </bean>  
          
          
        <bean id="multipartResolver"    
            class="org.springframework.web.multipart.commons.CommonsMultipartResolver">    
              
            <property name="defaultEncoding" value="utf-8" />    
              
            <property name="maxUploadSize" value="10485760000" />    
              
            <property name="maxInMemorySize" value="40960" />    
            
            <property name="resolveLazily" value="true"/>
        </bean>   
        
        
        <bean class="org.springframework.web.servlet.view.ContentNegotiatingViewResolver">
        <property name="order" value="1"></property>
            <property name="mediaTypes">
                <map>
                    
                    <entry key="json" value="application/json" />
                    <entry key="xml" value="application/xml" />
                    <entry key="htm" value="text/htm" />
                </map>
            </property>
            <property name="defaultViews">
                <list>
                    
                    <bean class="org.springframework.web.servlet.view.json.MappingJacksonJsonView" />
                </list>
            </property>
            <property name="ignoreAcceptHeader" value="true"></property>
        </bean>
        
         
        <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">  
              
            <property name="prefix" value="/jsp/" />  
            <property name="suffix" value=".jsp" />  
        </bean>  
    </beans>

**19.spring-mybatis.xml**

<?xml version="1.0" encoding="UTF-8"?>  
    <beans xmlns="http://www.springframework.org/schema/beans"  
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"  
        xmlns:context="http://www.springframework.org/schema/context"  
        xmlns:mvc="http://www.springframework.org/schema/mvc"  
        xsi:schemaLocation="http://www.springframework.org/schema/beans    
                            http://www.springframework.org/schema/beans/spring-beans-3.1.xsd    
                            http://www.springframework.org/schema/context    
                            http://www.springframework.org/schema/context/spring-context-3.1.xsd    
                            http://www.springframework.org/schema/mvc    
                            http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">  
          
        <context:component-scan base-package="com.javen" />  
        
          
        <bean id="propertyConfigurer"  
            class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">  
            <property name="location" value="classpath:jdbc.properties" />  
        </bean>  
      
        <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"  
            destroy-method="close">  
            <property name="driverClassName" value="${driver}" />  
            <property name="url" value="${url}" />  
            <property name="username" value="${username}" />  
            <property name="password" value="${password}" />  
              
            <property name="initialSize" value="${initialSize}"></property>  
              
            <property name="maxActive" value="${maxActive}"></property>  
              
            <property name="maxIdle" value="${maxIdle}"></property>  
              
            <property name="minIdle" value="${minIdle}"></property>  
              
            <property name="maxWait" value="${maxWait}"></property>  
        </bean>  
      
          
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
            <property name="dataSource" ref="dataSource" />  
              
            <property name="mapperLocations" value="classpath:com/javen/mapping/*.xml"></property>  
        </bean>  
      
          
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
            <property name="basePackage" value="com.javen.dao" />  
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>  
        </bean>  
      
          
        <bean id="transactionManager"  
            class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
            <property name="dataSource" ref="dataSource" />  
        </bean>  
      
    </beans>

### Mysql数据库 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMzIwMDQ4_size_16_color_FFFFFF_t_70 3][]

[20190410083804412.gif]: /images/20220222/cd657a4a71fe4f7fbb904b225ff582c9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMzIwMDQ4_size_16_color_FFFFFF_t_70]: /images/20220222/cea04a9f45be4f19aacbb3d85f3368f2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMzIwMDQ4_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20190410133530821.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMzIwMDQ4,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMzIwMDQ4_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20190410133705674.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMzIwMDQ4,size_16,color_FFFFFF,t_70
[20190410133750899.png]: /images/20220222/bf8ca8153fac40938d18e18ed2180bee.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQyMzIwMDQ4_size_16_color_FFFFFF_t_70 3]: /images/20220222/8004cf3df6f247b1a2fd4962db7bf6e2.png