Idea+mybatis+Servlet+mysql实现页面登录和注册

• 登录html
• 登录servlet
• 注册html
• 注册servlet
• pojo类
• mapper和mapperxml
• pom.xml
• mybatis.xml

@WebServlet("/loginDemo")
public class LoginDemo extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        String name=new String(request.getParameter("name").getBytes(StandardCharsets.ISO_8859_1),StandardCharsets.UTF_8);
        String password=new String(request.getParameter("password").getBytes(StandardCharsets.ISO_8859_1),StandardCharsets.UTF_8);
        response.setContentType("text/html;charset=utf-8");
        //1、加载mybatis核心组件
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //2、获取sqlSession对象
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //3、获取UserMapper对象
        UserMapper usermapper = sqlSession.getMapper(UserMapper.class);
        //4、传参
        User user=usermapper.select(name,password);
        //5、关闭资源
        sqlSession.close();
        //6、对比
        PrintWriter writer = response.getWriter();
        if(user==null){
            writer.write("登录失败~");
            System.out.println("falure");

        }else {
            writer.write("登录成功~");
            System.out.println("ok");
        }



    }

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

    }
}

@WebServlet("/registerDemo")
public class registerDemo extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String name = new String(request.getParameter("name").getBytes(StandardCharsets.ISO_8859_1),StandardCharsets.UTF_8);
        String password = new String(request.getParameter("password").getBytes(StandardCharsets.ISO_8859_1),StandardCharsets.UTF_8);
        response.setContentType("text/html;charset=utf-8");
        User user=new User();
        user.setName(name);
        user.setPassword(password);
        //1、加载mybatis核心组件
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //2、获取sqlsession对象
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //3、获取Mapper
        UserMapper usermapper = sqlSession.getMapper(UserMapper.class);
        //4、判断输入姓名是否重复
        User user1=usermapper.selectByName(name);
        if(user1==null){
            usermapper.add(user);
            sqlSession.commit();
            sqlSession.close();
        }else {
            response.getWriter().write("用户名已存在");
        }
    }

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

    }
}

public class User {
    private int id;
    private String name;
    private String password;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

public interface UserMapper {
    @Select("select * from stu_info where name=#{name} and password=#{password}")
    User select(@Param("name") String name, @Param("password") String password);
    @Select("select * from stu_info where name=#{name}")
    User selectByName(@Param("name") String name);
    @Insert("insert into stu_info values(null, #{name},#{password})")
    void add(User user);
}

  4.0.0

  org.example
  tomcat-demo2
  1.0-SNAPSHOT
  war

  tomcat-demo2 Maven Webapp
  
  http://www.example.com

  
    UTF-8
    1.7
    1.7
  

  
    
      javax.servlet
      javax.servlet-api
      3.1.0
      provided
    
    
      javax.servlet
      jstl
      1.2
      provided
    
    
      commons-io
      commons-io
      2.6

    
    
      org.mybatis
      mybatis
      3.5.5
    
    
      mysql
      mysql-connector-java
      5.1.37
    
    
    
      junit
      junit
      4.13
    
    
    
      ch.qos.logback
      logback-core
      1.3.0-alpha10
    
  

  
    
      
        org.apache.tomcat.maven
        tomcat7-maven-plugin
        2.2