注册功能_邮件激活_代码实现_Service&Dao与登录功能_分析

注册功能_邮件激活_代码实现_Service&Dao

    boolean active(String code);

    /**
     * 激活用户
     * @param code
     * @return
     */
    @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;
            }
    }

    User findByCode(String code);

    void updateStatus(User user);
}

  /**
     * 根据激活码查询对象
     * @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.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());
    }


}