JavaWeb 实现增改查删

资料来源黑马JAVA2019

登入和验证码板块，已经在上几篇文章中写到了，这里只需要按照三层架构模式，改写一些代码即可。开发文件结构如图所示：

按照DAO,SERVICE负责页面展示的Servlet等分门别类摆放。

主要看注释和图！
具体代码由于跳转和调用太多，要看整体代码https://github.com/miraclekowk/HeiMaJavaPractice_Day17

代码逻辑：

DAO层–实现：

public class UserDaoImpl implements UserDao {
   
    private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());

	//查询模块
    @Override
    public List<User> findAll() {
   
        //使用JDBC操作数据库   查询
        String sql = "select * from user";
        List<User> users = template.query(sql, new BeanPropertyRowMapper<User>(User.class));

        return users;
    }
	
	//登入模块
    @Override
    public User findUserByUsernameAndPassword(String username, String password) {
   
        try {
   
            String sql = "select * from user where username = ? and password = ?";
            User user = template.queryForObject(sql, new BeanPropertyRowMapper<User>(User.class), username, password);
            return user;
        } catch (Exception e) {
   
            e.printStackTrace();
            return null;
        }
    }

UserService层实现：

public class UserServiceImpl implements UserService {
   
    private UserDao dao = new UserDaoImpl();

    @Override
    public List<User> findAll() {
   
        //调用dao完成查询
        return dao.findAll();
    }

    @Override
    public User login(User user) {
   
        String userName = user.getUsername();
        String passWord = user.getPassword();

        System.out.println(userName + "   " + passWord);

        User userByUsernameAndPassword = dao.findUserByUsernameAndPassword(userName, passWord);

        return userByUsernameAndPassword;
    }
}

UserList层实现：

@WebServlet("/userListServlet")
public class UserListServlet extends HttpServlet {
   
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   
        //1.调用UserService完成查询
        UserService service = new UserServiceImpl();
        List<User> users = service.findAll();

        System.out.println("现有的信息条数" + users.size());

        //2.将list放入域
        request.setAttribute("users",users);
        //转发到list.jsp
        request.getRequestDispatcher("/list.jsp").forward(request,response);

    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   
        this.doPost(request, response);
    }
}

LoginServlet：

这里有两个做练习的过程中的错误点：
1.由于前端的list.jsp中的标签的name的规定，所以定义domin中User类的私有变量，必须和标签同名（大小写敏感）。不然咋找输入参数嘛？
2.如果发现登入问题，则优先去查看sql查询代码有没有写对，可以在sqlyog中手动输入来查询

@WebServlet("/loginServlet")
public class LoginServlet extends HttpServlet {
   
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   
        //1.设置编码
        request.setCharacterEncoding("utf-8");
        //2.获取验证码数据
        String verifycode = request.getParameter("verifycode");

        //3.验证码效验
        HttpSession session = request.getSession();
        String checkCode_server = (String) session.getAttribute("CHECKCODE_SERVER");

        //确保验证码的一次性
        session.removeAttribute("CHECKCODE_SERVER");

        if(!checkCode_server.equalsIgnoreCase(verifycode))
        {
   
            //验证码不正确  给提示信息跳转登入页面
            request.setAttribute("verify_fail","验证码错误!");
            request.getRequestDispatcher("/login.jsp").forward(request,response);
            return;
        }


        Map<String, String[]> parameterMap = request.getParameterMap();
        //4.封装user对象
        User user = new User();
        try {
   
            //BeanUtils.populate( Object bean, Map properties )
            //这个方法会遍历map<key, value>中的key，如果bean中有这个属性，就把这个key对应的value值赋给bean的属性。
            //!!!注意这里面的username(jsp中的标签name)一定要和User类中的成员变量一样 大小写敏感
            BeanUtils.populate(user,parameterMap);
        } catch (IllegalAccessException e) {
   
            e.printStackTrace();
        } catch (InvocationTargetException e) {
   
            e.printStackTrace();
        }
        System.out.println("现在我在封装对象" + user.getUsername()+"   " + user.getPassword());


        //5.调用Service查询
        UserService Service = new UserServiceImpl();
        User loginUser = Service.login(user);
        //6.判断是否登入成功
        if(loginUser != null)
        {
   
            //登入成功  信息进入session域
            session.setAttribute("user",loginUser);
            response.sendRedirect(request.getContextPath()+"/index.jsp");
        }
        else
        {
   
            request.setAttribute("login_fail","用户名或密码错误");
            request.getRequestDispatcher("/login.jsp").forward(request,response);
        }
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   
        this.doPost(request, response);
    }
}

前端 index.jsp (主要用来跳转到 userListServlet处理再转发到list.jsp)

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
  <meta charset="utf-8"/>
  <meta http-equiv="X-UA-Compatible" content="IE=edge"/>
  <meta name="viewport" content="width=device-width, initial-scale=1"/>
  <title>首页</title>

  <!-- 1. 导入CSS的全局样式 -->
  <link href="css/bootstrap.min.css" rel="stylesheet">
  <!-- 2. jQuery导入，建议使用1.9以上的版本 -->
  <script src="js/jquery-2.1.0.min.js"></script>
  <!-- 3. 导入bootstrap的js文件 -->
  <script src="js/bootstrap.min.js"></script>
  <script type="text/javascript">
  </script>
</head>
<body>
<div align="center">
  <a
          href="${pageContext.request.contextPath}/userListServlet" style="text-decoration:none;font-size:33px">查询所有用户信息
  </a>
</div>
</body>
</html>