三层架构完成登录操作

1.创建数据库搭建项目

 

 2代码

1.数据访问层页面代码

public interface UserMapper {
   @Select("select * from tb_user where")
    List<User> SeletAll();
//    根据用户名密码查询
    @Select("select * from tb_user where username = #{username} and password = #{password}")
    User select(@Param("username") String username, @Param("password")  String password);
    @Insert("insert into tb_user values(null,#{username},#{password})")
    void add(User user);
    @Select("select * from tb_user where username = #{username}")
    User selectByUsername(String username);

}

2.业务层代码

public class UserService {
    //用户登录
    public User Selet(String username,String password) throws IOException {
        //        1.加载mybatis的核心配置文件，获取sqlsessiofactory
        String resource = "mybatis-config";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
//        2.获取sql对象，来执行sql
        SqlSession sqlSession = sqlSessionFactory.openSession();
//        3.1获取Usermapper接口的代理对象
        UserMapper userMapper=sqlSession.getMapper(UserMapper.class);
        User select = userMapper.select(username,password);
        return select;
    }
}

2.表现层

@WebServlet("/loginServlet")
public class loginServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        UserService userService=new UserService();
        String user = request.getParameter("user");
        String pwd = request.getParameter("pwd");
        User selet = userService.Selet(user, pwd);
        request.setCharacterEncoding("utf-8");
        response.setContentType("text/html;charset=UTF-8");
        if (selet!=null){
            response.getWriter().write("登录成功");
        }else {
            response.getWriter().write("登录失败");
        }


    }

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

3.展示效果

 

 正确输入账号密码点击登录后

不正确则