Servlet结合JDBC三层架构登录

Dao（持久层，与数据库交互将数据持久化）
AdminDaoImpl包

public Admin select(String username) {
   
        try {
   
            Admin admin=queryRunner.query(Dbutils.getConnection(),"select * from admin where username=?",new BeanHandler<Admin>(Admin.class),username);
            return admin;
        } catch (SQLException e) {
   
            e.printStackTrace();
        }
        return null;
    }

    public List<Admin> selectAll() {
   
        try {
   
            List<Admin> admins=queryRunner.query(Dbutils.getConnection(),"select * from admin",new BeanListHandler<Admin>(Admin.class));
            return admins;
        } catch (SQLException e) {
   
            e.printStackTrace();
        }
        return null;
    }

Service（业务层，不断调用Dao层完成功能）
ServiceImpl包

 public Admin login(String username, String password) {
   
        Admin result=null;
        try {
   
            Dbutils.begin();
            Admin admin = adminDao.select(username);
            if (admin!=null){
   
                if (admin.getPassword().equals(password)){
   
                    result=admin;
                }
            }
            Dbutils.commit();
        } catch (Exception e) {
   
            Dbutils.rollback();
            e.printStackTrace();
        }
        return result;
    }

    public List<Admin> showAllAdmin() {
   
        List<Admin> admins=null;
        try {
   
            Dbutils.begin();
            admins=adminDao.selectAll();
            Dbutils.commit();
        } catch (Exception e) {
   
            Dbutils.rollback();
            e.printStackTrace();
        }

        return admins;
    }

Servlet(视图层，实现功能)
Controller包（只负责调用业务逻辑功能）

@WebServlet(value =