devbox
从前慢现在也慢
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

JavaWeb——Requst&Response案例（用户登录、注册）_irestresponse 怎么使用

作者：从前慢现在也慢 | 2024-03-18 01:37:15

赞

踩

irestresponse 怎么使用

1.环境准备

1.1准备静态页面到项目的webapp目录下


1.2创建db1数据库，创建tb_ user表，创建User实体类

  1.  
  2. -- 创建数据库
  3. create database db1;
  4.  
  5. use db1 
  6.  
  7. -- 创建用户表
  8. CREATE TABLE tb_user(
  9. 	id int primary key auto_increment,
  10. 	username varchar(20) unique,
  11. 	password varchar(32)
  12. );
  13.  
  14. -- 添加数据
  15. INSERT INTO tb_user(username,password) values('zhangsan','123'),('lisi','234');
  16.  
  17. SELECT * FROM tb_user;

  1.  
  2. public class User {
  3.  
  4.     private Integer id;
  5.     private String username;
  6.     private String password;
  7.  
  8.     public Integer getId() {
  9.         return id;
  10.     }
  11.  
  12.     public void setId(Integer id) {
  13.         this.id = id;
  14.     }
  15.  
  16.     public String getUsername() {
  17.         return username;
  18.     }
  19.  
  20.     public void setUsername(String username) {
  21.         this.username = username;
  22.     }
  23.  
  24.     public String getPassword() {
  25.         return password;
  26.     }
  27.  
  28.     public void setPassword(String password) {
  29.         this.password = password;
  30.     }
  31.  
  32.     @Override
  33.     public String toString() {
  34.         return "User{" +
  35.                 "id=" + id +
  36.                 ", username='" + username + '\'' +
  37.                 ", password='" + password + '\'' +
  38.                 '}';
  39.     }
  40. }


1.3导坐标

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0"
  3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  5.     <modelVersion>4.0.0</modelVersion>
  6.  
  7.     <groupId>com.myproject</groupId>
  8.     <artifactId>request_response</artifactId>
  9.     <version>1.0-SNAPSHOT</version>
  10.     <packaging>war</packaging>
  11.  
  12.     <dependencies>
  13.         <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
  14.         <dependency>
  15.             <groupId>mysql</groupId>
  16.             <artifactId>mysql-connector-java</artifactId>
  17.             <version>8.0.21</version>
  18.         </dependency>
  19.  
  20.         <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
  21.         <dependency>
  22.             <groupId>org.mybatis</groupId>
  23.             <artifactId>mybatis</artifactId>
  24.             <version>3.4.6</version>
  25.         </dependency>
  26.  
  27.         <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
  28.         <dependency>
  29.             <groupId>javax.servlet</groupId>
  30.             <artifactId>javax.servlet-api</artifactId>
  31.             <version>3.1.0</version>
  32.             <scope>provided</scope>
  33.         </dependency>
  34.  
  35.         <!-- https://mvnrepository.com/artifact/org.apache.maven/maven-plugin-api -->
  36.         <dependency>
  37.             <groupId>org.apache.maven</groupId>
  38.             <artifactId>maven-plugin-api</artifactId>
  39.             <version>2.0</version>
  40.         </dependency>
  41.  
  42.         <!-- https://mvnrepository.com/artifact/commons-io/commons-io -->
  43.         <dependency>
  44.             <groupId>commons-io</groupId>
  45.             <artifactId>commons-io</artifactId>
  46.             <version>2.6</version>
  47.         </dependency>
  48.     </dependencies>
  49.  
  50.     <build>
  51.         <plugins>
  52.             <plugin>
  53.                 <groupId>org.apache.tomcat.maven</groupId>
  54.                 <artifactId>tomcat7-maven-plugin</artifactId>
  55.                 <version>2.2</version>
  56.             </plugin>
  57.         </plugins>
  58.     </build>
  59.  
  60. </project>


1.4创建mybatis-config.xml核心配置文件

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration
  3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <configuration>
  6.     <!--起别名-->
  7.     <typeAliases>
  8.         <package name="com.pojo"/>
  9.     </typeAliases>
  10.  
  11.     <environments default="development">
  12.         <environment id="development">
  13.             <transactionManager type="JDBC"/>
  14.             <dataSource type="POOLED">
  15.                 <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
  16.                 <property name="url" value="jdbc:mysql:///db1?serverTimezone=UTC"/>
  17.                 <property name="username" value="root"/>
  18.                 <property name="password" value="gyx.l123"/>
  19.             </dataSource>
  20.         </environment>
  21.     </environments>
  22.     <mappers>
  23.         <!--扫描mapper-->
  24.         <package name="com.mapper"/>
  25.     </mappers>
  26. </configuration>

1.5 UserMapper.xml映射文件, UserMapper接口

  1. package com.mapper;
  2.  
  3. import com.pojo.User;
  4. import org.apache.ibatis.annotations.Param;
  5.  
  6. public interface UserMapper {
  7.     User select(@Param("username")String username,@Param("password") String password);
  8. }
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper
  3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  5. <mapper namespace="com.mapper.UserMapper">
  6.  
  7.     <select id="select" resultType="com.pojo.User">
  8.         select * from tb_user WHERE username=#{username} and password=#{password}
  9.     </select>
  10. </mapper>

 

2.代码实现

  1.  
  2. public interface UserMapper {
  3.     User select(@Param("username")String username,@Param("password") String password);
  4.  
  5.     User selectByUsername(String username);
  6.  
  7.     void add(User user);
  8.  
  9. }
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper
  3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  5. <mapper namespace="com.mapper.UserMapper">
  6.  
  7.  
  8.     <select id="select" resultType="com.pojo.User">
  9.         select * from tb_user WHERE username=#{username} and password=#{password}
  10.     </select>
  11.     <select id="selectByUsername" resultType="com.pojo.User">
  12.         SELECT * from tb_user WHERE username=#{username}
  13.     </select>
  14.     <insert id="add">
  15.         INSERT INTO tb_user VALUES (null,#{username},#{password})
  16.  
  17.     </insert>
  18. </mapper>

2.1用户登录

  1.  
  2. @WebServlet("/loginServlet")
  3. public class LoginServlet extends HttpServlet {
  4.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  5.         doGet(request, response);
  6.     }
  7.  
  8.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  9.         //1.接受用户名和密码
  10.         String username1 = request.getParameter("username");
  11.         String password1 = request.getParameter("password");
  12.  
  13.         //2.调用Mybatis完成查询
  14.         //2.1获取SqlSessionFactory对象：从官网复制
  15.         String resource = "mybatis-config.xml";
  16.         InputStream inputStream = Resources.getResourceAsStream(resource);
  17.         SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
  18.         //2.2获取SqlSession对象
  19.         SqlSession sqlSession = sqlSessionFactory.openSession();
  20.         //2.3获取mapper对象
  21.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
  22.         //2.4调用方法
  23.         User select = mapper.select(username1, password1);
  24.         //2.5释放资源
  25.         sqlSession.close();
  26.  
  27.         //解析html，并解决中文乱码
  28.         response.setContentType("text/html;charset=utf-8");
  29.         //获取字符流
  30.         PrintWriter writer = response.getWriter();
  31.  
  32.         //3.判断
  33.         if (select != null) {
  34.             writer.write("登录成功");
  35.         } else {
  36.             writer.write("登录失败");
  37.         }
  38.     }
  39. }

2.2用户注册

 

  1.  
  2. @WebServlet("/registerServlet")
  3. public class RegisterServlet extends HttpServlet {
  4.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  5.         doGet(request, response);
  6.  
  7.     }
  8.  
  9.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  10.         //1.接受用户名和密码
  11.         String username = request.getParameter("username");
  12.         String password = request.getParameter("password");
  13.  
  14.         //2.封装用户对象
  15.         User user = new User();
  16.         user.setUsername(username);
  17.         user.setPassword(password);
  18.  
  19.         //3..调用Mybatis完成查询
  20.         //3.1获取SqlSessionFactory对象：从官网复制
  21.         String resource = "mybatis-config.xml";
  22.         InputStream inputStream = Resources.getResourceAsStream(resource);
  23.         SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
  24.         //3.2获取SqlSession对象
  25.         SqlSession sqlSession = sqlSessionFactory.openSession();
  26.         //3.3获取mapper对象
  27.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
  28.         //3.4调用方法
  29.         User select = mapper.selectByUsername(username);
  30.  
  31.         //解析html，并解决中文乱码
  32.         response.setContentType("text/html;charset=utf-8");
  33.         //获取字符流
  34.         PrintWriter writer = response.getWriter();
  35.  
  36.         //4.判断
  37.         if (select == null) {
  38.             //添加数据
  39.             mapper.add(user);
  40.             //提交事务
  41.             sqlSession.commit();
  42.             //释放资源
  43.             sqlSession.close();
  44.             //提示信息
  45.             writer.write("注册成功");
  46.         } else {
  47.             //提示信息
  48.             writer.write("用户名已存在");
  49.         }
  50.     }
  51. }

3.创建SqlSessionFactory代码优化

  1. public class SqlSessionFactoryUtils {
  2.     private static SqlSessionFactory sqlSessionFactory;
  3.  
  4.     static {
  5.         try {
  6.             String resource = "mybatis-config.xml";
  7.             InputStream inputStream = Resources.getResourceAsStream(resource);
  8.             sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
  9.         } catch (Exception e) {
  10.             e.printStackTrace();
  11.         }
  12.     }
  13.  
  14.     public static SqlSessionFactory getSqlSessionFactory() {
  15.         return sqlSessionFactory;
  16.     }
  17. }

 

  1. @WebServlet("/loginServlet")
  2. public class LoginServlet extends HttpServlet {
  3.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  4.         doGet(request, response);
  5.     }
  6.  
  7.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  8.         //1.接受用户名和密码
  9.         String username1 = request.getParameter("username");
  10.         String password1 = request.getParameter("password");
  11.  
  12.         //2.调用Mybatis完成查询
  13.         //2.1获取SqlSessionFactory对象：从官网复制
  14. //        String resource = "mybatis-config.xml";
  15. //        InputStream inputStream = Resources.getResourceAsStream(resource);
  16. //        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
  17.         SqlSessionFactory sqlSessionFactory = SqlSessionFactoryUtils.getSqlSessionFactory();
  18.         //2.2获取SqlSession对象
  19.         SqlSession sqlSession = sqlSessionFactory.openSession();
  20.         //2.3获取mapper对象
  21.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
  22.         //2.4调用方法
  23.         User select = mapper.select(username1, password1);
  24.         //2.5释放资源
  25.         sqlSession.close();
  26.  
  27.         //解析html，并解决中文乱码
  28.         response.setContentType("text/html;charset=utf-8");
  29.         //获取字符流
  30.         PrintWriter writer = response.getWriter();
  31.  
  32.         //3.判断
  33.         if (select != null) {
  34.             writer.write("登录成功");
  35.         } else {
  36.             writer.write("登录失败");
  37.         }
  38.     }
  39. }

  1. @WebServlet("/registerServlet")
  2. public class RegisterServlet extends HttpServlet {
  3.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  4.         doGet(request, response);
  5.  
  6.     }
  7.  
  8.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  9.         //1.接受用户名和密码
  10.         String username = request.getParameter("username");
  11.         String password = request.getParameter("password");
  12.  
  13.         //2.封装用户对象
  14.         User user = new User();
  15.         user.setUsername(username);
  16.         user.setPassword(password);
  17.  
  18.         //3..调用Mybatis完成查询
  19.         //3.1获取SqlSessionFactory对象：从官网复制
  20. //        String resource = "mybatis-config.xml";
  21. //        InputStream inputStream = Resources.getResourceAsStream(resource);
  22. //        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
  23.         SqlSessionFactory sqlSessionFactory = SqlSessionFactoryUtils.getSqlSessionFactory();
  24.         //3.2获取SqlSession对象
  25.         SqlSession sqlSession = sqlSessionFactory.openSession();
  26.         //3.3获取mapper对象
  27.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
  28.         //3.4调用方法
  29.         User select = mapper.selectByUsername(username);
  30.  
  31.         //解析html，并解决中文乱码
  32.         response.setContentType("text/html;charset=utf-8");
  33.         //获取字符流
  34.         PrintWriter writer = response.getWriter();
  35.  
  36.         //4.判断
  37.         if (select == null) {
  38.             //添加数据
  39.             mapper.add(user);
  40.             //提交事务
  41.             sqlSession.commit();
  42.             //释放资源
  43.             sqlSession.close();
  44.             //提示信息
  45.             writer.write("注册成功");
  46.         } else {
  47.             //提示信息
  48.             writer.write("用户名已存在");
  49.         }
  50.     }
  51. }

声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：【wpsshop博客】
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号