SSM框架的增删改查之用户注册

mapper层

  /**
     * 根据用户名查找数据Count
     */
    @Select("select count(id) " +
            "from user " +
            "where username=#{username}")
    public int verifyUserName(String username) throws Exception;


    /**
     * 新增用户
     */
    @Insert("INSERT INTO user (id,username,password,real_name,phone_one)  " +
            "values(#{id},#{username},#{password},#{real_name},#{phone_one})")
    public int register(User user) throws Exception;

sevice层

 @Autowired
    private UserMapper UserMapper;
  @Autowired
    private Sid sid;

@Override
    public int verifyUserName(String username) throws Exception {
   
        return UserMapper.verifyUserName(username);
    }

    @Override
    public int register(User user) throws Exception {
   
        user.setId(sid.nextShort());
        return UserMapper.register(user);
    }

controller层

    /*验证用户账号是否被占用*/
    @RequestMapping("/verifyUserName")
    @ResponseBody
    public int verifyUserName(String username) throws Exception {
   
        return loginService.verifyUserName(username);
    }

    /*注册页面*/
    @RequestMapping("/goRegister")
    public String goRegister() throws Exception {
   
        return "register";
    }

    /**
     * 注册
     *
     * @param user
     * @return
     * @throws Exception
     */
    @RequestMapping("/register")
    @ResponseBody
    public int register(User user) throws Exception {
   
        return loginService.register(user);
    }

前端页面

<script>

    layui.use(['jquery', 'element', 'layer', 'form'], function () {
   
        var layer = layui.layer;
        var element =