educoder平台《博客系统 - 用户模块》

第1关：用户注册

SSM_proj_user/resource/mappers/UserMapper.xml

    

  insert into t_user (username, password, phone,avatar,last_login, user_register_time )  

  values (#{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR},   

  #{phone,jdbcType=INTEGER},   

  #{avatar,jdbcType=VARCHAR},   

  now(), now())  

  

SSM_proj_user/src/com/service/impl/UserServiceImpl.java

//注册

  public ServerResponse register(User user) {

    

    //校验用户名是否存在

    ServerResponse response = checkValid(user.getUsername(),USER_TYPE);

    if (response.getStatus() == ServerResponse.ERROR) {

      return response;

    }

    

    //校验手机号是否存在

    response = checkValid(user.getPhone(), PHONE_TYPE);

      if (response.getStatus() == ServerResponse.ERROR) {  

    return response;  

    }  



    //MD5加密

    user.setPassword(MD5Util.getMD5(user.getPassword()));

    //设置默认头像

    user.setAvatar("/img/image.jpg");

    //实现用户注册

    int result = userMapper.insert(user);  

    if (result == 0) {  

    return new ServerResponse("注册失败", ServerResponse.ERROR);  

    }  

    return new ServerResponse("注册成功", ServerResponse.SUCCESS);  

    

  }

SSM_proj_user/src/com/controller/UserController.java

@RequestMapping("register.do")
	@ResponseBody
	public ServerResponse register(User user) {
		//实现注册功能
    ServerResponse response = userService.register(user);  
    return response;  
	}

	
 select   
      
    from t_user  
    where (username = #{username} OR email = #{username} OR phone = #{password}) AND password = #{password}

  

SSM_proj_user/src/com/service/impl/UserServiceImpl.java

// 登陆
	public ServerResponse loginByUserNameAndPwd(String username, String password) {
		password = MD5Util.getMD5(password);  
        User user = userMapper.selectByUserInfo(username, password);  
        if (user != null) {  
            // 登录成功  
            return new ServerResponse("登录成功", ServerResponse.SUCCESS, user);  
        }  
        return new ServerResponse("登录失败，用户名或密码错误！", ServerResponse.ERROR);  
	}

SSM_proj_user/src/com/controller/UserController.java

	@RequestMapping("login.do")
	@ResponseBody
	public ServerResponse login(@RequestParam("username") String username,@RequestParam("password") String password, HttpSession session, HttpServletRequest request) {
		//实现登陆功能
		ServerResponse response = userService.loginByUserNameAndPwd(username, password);  
        if (response.getStatus() == ServerResponse.SUCCESS) {  
            session.setAttribute("userInfo", response.getData());  
        }  
        return response;  
	}