接上一篇注册页面邮件发送激活码
介绍:
- 给用户注册时提供的邮箱发送邮件
- (发送的一个a标签 href=”/项目路径/user?method=active&c=37521573843“)
- 用户点击这个a标签,调用active方法,该方法获取上面传来的c值37521573843,如果c值(也就是创建用户时设置的ucode值,以下都称为code)与数据库里面该用户的u_code一样,就把用户的u_status属性设置为1(已激活状态),不一样就返回错误信息
这里实现的Servlet页面:UserController(value="/user")的active方法(method=active)
1. UserController->active方法
public static String active(HttpServletRequest req,HttpServletResponse resp){
String code = req.getParameter("c");
UserService userService = new UserServiceImpl();
userService.activeUser(code);
}
- 这里是调用service层业务逻辑activeUser
- 实现通过这个激活码code查找用户,并把u_status设置成1
2. dao层代码
public interface UserDao{
//通过code查找user
public User selectUserByCode(String code);
//通过id改status
public int updateStatusByid(int id);
}
public class UserDaoImpl implements UserDao{
private QueryRunner queryRunner = new QueryRunner(C3P0Utils.getDataSource);
@Override
public User selectUserByCode(String code){
User user = null;
String sql = "select u_id as uid,u_name as uname,u_password as upassword,u_email as uemail,u_sex as usex,u_status as status,u_code as ucode,u_role as urole from user where u_code = ?"
try {
user = queryRunner.query(sql, new BeanHandler<User>(User.class), ucode);
} catch (SQLException e) {
e.printStackTrace();
}
return user;
}
@Override
public int updateStatusByid(int id){
int result = 0;
String sql = "update user set u_status = ? where id = ?";
try {
result = queryRunner.update(sql, Constants.USER_ACTIVE, id);
} catch (SQLException e) {
e.printStackTrace();
}
return result;
}
}
3. UserService层代码
public interface UserService {
public int activeUser(String code);
}
public class UserServiceImpl implements UserService{
@Override
public int activeUser(String code){
UserDao userDao = new UserDaoImpl();
User user = null;
user = userDao.selectUserByCode(code);
if(user==null){
return 0;
}else if(user.getStatus==Constants.USER_ACTIVE){
return 2;
}
int i = userDao.updateStatusByid(user.getUid());
if(i>0){
return 1;
}
return 0;
}
}
4. 完善Servlet页面:UserController 代码
- 调用业务逻辑,激活成功就跳转到message.jsp页面
- 该页面<body>${meg}</body>
public String active(HttpServletRequest req, HttpServletResponse resp) {
//1.获取激活码
String code = req.getParameter("c");
//2.调用激活的业务逻辑
UserService userService = new UserServiceImpl();
int i = userService.activeUser(code);
//3.响应(激活失败(code没有找到)、已经激活、激活成功)
if (i == 0) {
req.setAttribute("msg", "未激活成功");
} else if (i == 1) {
req.setAttribute("msg", "激活成功,请登录");
} else {
req.setAttribute("msg", "已经激活过了");
}
return Constants.FORWARD + Constants.FLAG + "/message.jsp";
}
实现了用户名验证、用户注册、激活用户的UserController页面完整代码
package com.itqf.controller;
import cn.dsna.util.images.ValidateCode;
import com.itqf.entity.User;
import com.itqf.service.UserService;
import com.itqf.service.impl.UserServiceImpl;
import com.itqf.utils.Constants;
import com.itqf.utils.MD5Utils;
import com.itqf.utils.RandomUtils;
import org.apache.commons.beanutils.BeanUtils;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.*;
import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import java.util.Map;
/*
* 用户模块的controller*/
@WebServlet(name = "UserController", value = "/user")
public class UserController extends BaseServlet {
public String check(HttpServletRequest req, HttpServletResponse resp) {
//1.获取用户名
//2.调用业务逻辑判断用户名是否存在
//3.响应字符串 1 存在 0 不存在
String username = req.getParameter("username");
if (username == null) {
return Constants.HAS_USER;
}
UserService userService = new UserServiceImpl();
boolean b = userService.checkUser(username);
if (b) {
return Constants.HAS_USER;
}
return Constants.NOT_HAS_USER;
}
public String register(HttpServletRequest req, HttpServletResponse resp) {
Map<String, String[]> parameterMap = req.getParameterMap();
User user = new User();
try {
BeanUtils.populate(user, parameterMap);
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (InvocationTargetException e) {
e.printStackTrace();
}
user.setStatus(Constants.USER_NOT_ACTIVE);//未激活0激活1
user.setUcode(RandomUtils.createActive());//账号类型
user.setUrole(Constants.ROLE_CUSTOMER);//用户0管理员1
// //对密码加密处理
// user.setUpassword(MD5Utils.md5(user.getUpassword()));
UserService userService = new UserServiceImpl();
try {
userService.register(user);
} catch (Exception e) {
e.printStackTrace();
req.setAttribute("registerMsg", "注册失败!");
return Constants.FORWARD + Constants.FLAG + "/Register.jsp";
}
return Constants.FORWARD + Constants.FLAG + "/registerSuccess.jsp";
}
public String active(HttpServletRequest req, HttpServletResponse resp) {
//1.获取激活码
String code = req.getParameter("c");
//2.调用激活的业务逻辑
UserService userService = new UserServiceImpl();
int i = userService.activeUser(code);
//3.响应(激活失败(code没有找到)、已经激活、激活成功)
if (i == 0) {
req.setAttribute("msg", "未激活成功");
} else if (i == 1) {
req.setAttribute("msg", "激活成功,请登录");
} else {
req.setAttribute("msg", "已经激活过了");
}
return Constants.FORWARD + Constants.FLAG + "/message.jsp";
}
}