激活代码实现

激活代码实现：

ActiveUserServlet
//1.获取激活码
String code = request.getParameter(“code”);
if(code != null){
//2.调用service完成激活
UserService service = new UserServiceImpl();
boolean flag = service.active(code);

//3.判断标记
String msg = null;
if(flag){
    //激活成功
    msg = "激活成功，请<a href='login.html'>登录</a>";
}else{
    //激活失败
    msg = "激活失败，请联系管理员!";
}
response.setContentType("text/html;charset=utf-8");
response.getWriter().write(msg);

UserService：active
@Override
public boolean active(String code) {
//1.根据激活码查询用户对象
User user = userDao.findByCode(code);
if(user != null){
//2.调用dao的修改激活状态的方法
userDao.updateStatus(user);
return true;
}else{
return false;
}

}

UserDao：findByCode updateStatus

/**

• 根据激活码查询用户对象

• @param code

• @return
  */
  @Override
  public User findByCode(String code) {
  User user = null;
  try {
  String sql = “select * from tab_user where code = ?”;

   user = template.queryForObject(sql,new BeanPropertyRowMapper<User>(User.class),code);
  

  } catch (DataAccessException e) {
  e.printStackTrace();
  }

  return user;
  }

/**

• 修改指定用户激活状态
• @param user
  */
  @Override
  public void updateStatus(User user) {
  String sql = " update tab_user set status = ‘Y’ where uid=?";
  template.update(sql,user.getUid());
  }