• JavaWeb Servlet实现登录注册实例（Mybatis，maven，mysql数据库）

    目录

    1.项目文件格式与准备工作

    2.UserMpper 接口类

    3.User实体类

    4.loginServlet 登录Servlet测试类

    5.registerServlet注册Servlet测试类

    6.UserMpper.xml映射文件

    7.mybatis-config.xml   mtbatis连接数据库xml文件

    8.login.css文件

    9.register.css文件

    10.imgs图片

    11.web.xml web配置文件(这个在配置webapp项目的时候自动配置)

    12.login.html文件

    13.register.html文件

    12.pom.xml  maven配置文件

    13.MySQL数据库

    14.对Servlet SqlSessionFactory的代码优化

    1.项目文件格式与准备工作

    1.首先创建一个web的项目

    2.配置maven环境，mybatis配置文件

    3. 写好都相应的文件，就可以开始了

    2.UserMpper 接口类

    1. package com.itheima.mapper;
    2.  
    3. import com.itheima.pojo.User;
    4. import org.apache.ibatis.annotations.Insert;
    5. import org.apache.ibatis.annotations.Param;
    6. import org.apache.ibatis.annotations.Select;
    7.  
    8. public interface UserMapper {
    9. //    查询用户信息
    10.  
    11.     /**
    12.      * @Param("username")内的参数是与大括号里面的参数做一个映射
    13.      *
    14.      * @param username
    15.      * @param password
    16.      * @return
    17.      */
    18.     @Select("select * from tb_user where username = #{username} and password = #{password}")
    19.     User select(@Param("username") String username,@Param("password")String password);
    20.  
    21.     //获取数据库相同信息
    22.     @Select("select * from tb_user where username = #{username}")
    23.     User selectByUsername(String username);
    24.  
    25.     //向数据库插入用户信息
    26.     void insert(User user);
    27. }

    3.User实体类

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

    4.loginServlet 登录Servlet测试类

    1. package com.itheima.web;
    2.  
    3. import com.itheima.mapper.UserMapper;
    4. import com.itheima.pojo.User;
    5. import org.apache.ibatis.io.Resources;
    6. import org.apache.ibatis.session.SqlSession;
    7. import org.apache.ibatis.session.SqlSessionFactory;
    8. import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    9.  
    10. import javax.servlet.*;
    11. import javax.servlet.http.*;
    12. import javax.servlet.annotation.*;
    13. import java.io.IOException;
    14. import java.io.InputStream;
    15. import java.io.PrintWriter;
    16.  
    17. @WebServlet("/loginServlet")
    18. public class loginServlet extends HttpServlet {
    19.     @Override
    20.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    21.         //1.接受用户名和密码
    22.         String username = request.getParameter("username");
    23.         String password = request.getParameter("password");
    24.  
    25.         //2.调用mybatis方法进行调用
    26.         //2.1获取sqlSessionFactory对象
    27.         String resource = "mybatis-config.xml";//现在在resource根目录下
    28.         InputStream inputStream = Resources.getResourceAsStream(resource);
    29.         SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    30.         //2.2获取sqlSession对象
    31.         SqlSession sqlSession = sqlSessionFactory.openSession(true);//自动提交事务
    32.         //2.3获取mapper对象
    33.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    34.         //2.4调用mapper方法
    35.         User select = mapper.select(username, password);
    36.         //2.5释放资源
    37.         sqlSession.close();
    38.  
    39.         //获取response响应数据的字符输出流,并设置相应的格式
    40.         response.setContentType("text/html;charset=utf-8");
    41.         PrintWriter writer = response.getWriter();
    42.         //3.判断select是否为null
    43.         if (select!=null){
    44.             //登录成功
    45.             writer.write("");
    46.         }else{
    47.             //登录失败
    48.             writer.write("");
    49.         }
    50.     }
    51.  
    52.     @Override
    53.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    54.         this.doGet(request, response);
    55.     }
    56. }

    5.registerServlet注册Servlet测试类

    1. package com.itheima.web;
    2.  
    3. import com.itheima.mapper.UserMapper;
    4. import com.itheima.pojo.User;
    5. import org.apache.ibatis.io.Resources;
    6. import org.apache.ibatis.session.SqlSession;
    7. import org.apache.ibatis.session.SqlSessionFactory;
    8. import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    9.  
    10. import javax.servlet.*;
    11. import javax.servlet.http.*;
    12. import javax.servlet.annotation.*;
    13. import java.io.IOException;
    14. import java.io.InputStream;
    15.  
    16.  
    17. @WebServlet("/registerServlet")
    18. public class registerServlet extends HttpServlet {
    19.     @Override
    20.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    21.         //1.接受用户名和密码
    22.         String username = request.getParameter("username");
    23.         String password = request.getParameter("password");
    24.         //1.2封装参数  --利用实体类对参数进行封装，就简单快捷了许多
    25.         User user = new User();
    26.         user.setUsername(username);
    27.         user.setPassword(password);
    28.  
    29.         //2.调用mybatis方法进行调用
    30.         //2.1获取sqlSessionFactory对象
    31.         String resource = "mybatis-config.xml";//现在在resource根目录下
    32.         InputStream inputStream = Resources.getResourceAsStream(resource);
    33.         SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    34.         //2.2获取sqlSession对象
    35.         SqlSession sqlSession = sqlSessionFactory.openSession(true);//自动提交事务
    36.         //2.3获取mapper对象
    37.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    38.         //3.检测数据库内有么有相同的值
    39.         //获取response响应数据的字符输出流,并设置相应的格式
    40.         response.setContentType("text/html;charset=utf-8");
    41.         User selectByUsername = mapper.selectByUsername(username);
    42.         if (selectByUsername == null){
    43.             //判断字符串是否为空，抢了前端的活
    44.             if (username.length()!=0 && password .length()!=0){
    45.                 mapper.insert(user);
    46.                 //释放资源
    47.                 sqlSession.close();
    48.                 response.getWriter().write("");
    49.             }else{
    50.                 response.getWriter().write("");
    51.             }
    52.         }else {
    53.             response.getWriter().write("");
    54.         }
    55.  
    56.  
    57.     }
    58.  
    59.     @Override
    60.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    61.         this.doGet(request, response);
    62.     }
    63. }

    6.UserMpper.xml映射文件

    2. mapper
    3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    5. <mapper namespace="com.itheima.mapper.UserMapper">
    6.  
    7.  
    8.     
    9.     <insert id="insert" useGeneratedKeys="true" keyProperty="id">
    10.         insert into tb_user(username,password)values (#{username},#{password});
    11.     insert>
    12. mapper>

    7.mybatis-config.xml   mtbatis连接数据库xml文件

    2. 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.itheima.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.jdbc.Driver"/>
    16.                 <property name="url" value="jdbc:mysql:///db1?useSSL=false&useServerPrepStmts=true"/>
    17.                 <property name="username" value="root"/>
    18.                 <property name="password" value="root"/>
    19.             dataSource>
    20.         environment>
    21.     environments>
    22.     <mappers>
    23.         
    24.         <package name="com.itheima.mapper"/>
    25.     mappers>
    26. configuration>

    8.login.css文件

    1. * {
    2.     margin: 0;
    3.     padding: 0;
    4. }
    5.  
    6. html {
    7.     height: 100%;
    8.     width: 100%;
    9.     overflow: hidden;
    10.     margin: 0;
    11.     padding: 0;
    12.     background: url(../imgs/Desert.jpg) no-repeat 0px 0px;
    13.     background-repeat: no-repeat;
    14.     background-size: 100% 100%;
    15.     -moz-background-size: 100% 100%;
    16. }
    17.  
    18. body {
    19.     display: flex;
    20.     align-items: center;
    21.     justify-content: center;
    22.     height: 100%;
    23. }
    24.  
    25. #loginDiv {
    26.     width: 37%;
    27.     display: flex;
    28.     justify-content: center;
    29.     align-items: center;
    30.     height: 300px;
    31.     background-color: rgba(75, 81, 95, 0.3);
    32.     box-shadow: 7px 7px 17px rgba(52, 56, 66, 0.5);
    33.     border-radius: 5px;
    34. }
    35.  
    36. #name_trip {
    37.     margin-left: 50px;
    38.     color: red;
    39. }
    40.  
    41. p {
    42.     margin-top: 30px;
    43.     margin-left: 20px;
    44.     color: azure;
    45. }
    46.  
    47. input {
    48.     margin-left: 15px;
    49.     border-radius: 5px;
    50.     border-style: hidden;
    51.     height: 30px;
    52.     width: 140px;
    53.     background-color: rgba(216, 191, 216, 0.5);
    54.     outline: none;
    55.     color: #f0edf3;
    56.     padding-left: 10px;
    57. }
    58. #username{
    59.     width: 200px;
    60. }
    61. #password{
    62.     width: 202px;
    63. }
    64. .button {
    65.     border-color: cornsilk;
    66.     background-color: rgba(100, 149, 237, .7);
    67.     color: aliceblue;
    68.     border-style: hidden;
    69.     border-radius: 5px;
    70.     width: 100px;
    71.     height: 31px;
    72.     font-size: 16px;
    73. }
    74.  
    75. #subDiv {
    76.     text-align: center;
    77.     margin-top: 30px;
    78. }
    79. #loginMsg{
    80.     text-align: center;color: aliceblue;
    81. }

    9.register.css文件

    1. * {
    2.     margin: 0;
    3.     padding: 0;
    4.     list-style-type: none;
    5. }
    6. .reg-content{
    7.     padding: 30px;
    8.     margin: 3px;
    9. }
    10. a, img {
    11.     border: 0;
    12. }
    13.  
    14. body {
    15.     background-image: url("../imgs/reg_bg_min.jpg") ;
    16.     text-align: center;
    17. }
    18.  
    19. table {
    20.     border-collapse: collapse;
    21.     border-spacing: 0;
    22. }
    23.  
    24. td, th {
    25.     padding: 0;
    26.     height: 90px;
    27.  
    28. }
    29. .inputs{
    30.     vertical-align: top;
    31. }
    32.  
    33. .clear {
    34.     clear: both;
    35. }
    36.  
    37. .clear:before, .clear:after {
    38.     content: "";
    39.     display: table;
    40. }
    41.  
    42. .clear:after {
    43.     clear: both;
    44. }
    45.  
    46. .form-div {
    47.     background-color: rgba(255, 255, 255, 0.27);
    48.     border-radius: 10px;
    49.     border: 1px solid #aaa;
    50.     width: 424px;
    51.     margin-top: 150px;
    52.     margin-left:1050px;
    53.     padding: 30px 0 20px 0px;
    54.     font-size: 16px;
    55.     box-shadow: inset 0px 0px 10px rgba(255, 255, 255, 0.5), 0px 0px 15px rgba(75, 75, 75, 0.3);
    56.     text-align: left;
    57. }
    58.  
    59. .form-div input[type="text"], .form-div input[type="password"], .form-div input[type="email"] {
    60.     width: 268px;
    61.     margin: 10px;
    62.     line-height: 20px;
    63.     font-size: 16px;
    64. }
    65.  
    66. .form-div input[type="checkbox"] {
    67.     margin: 20px 0 20px 10px;
    68. }
    69.  
    70. .form-div input[type="button"], .form-div input[type="submit"] {
    71.     margin: 10px 20px 0 0;
    72. }
    73.  
    74. .form-div table {
    75.     margin: 0 auto;
    76.     text-align: right;
    77.     color: rgba(64, 64, 64, 1.00);
    78. }
    79.  
    80. .form-div table img {
    81.     vertical-align: middle;
    82.     margin: 0 0 5px 0;
    83. }
    84.  
    85. .footer {
    86.     color: rgba(64, 64, 64, 1.00);
    87.     font-size: 12px;
    88.     margin-top: 30px;
    89. }
    90.  
    91. .form-div .buttons {
    92.     float: right;
    93. }
    94.  
    95. input[type="text"], input[type="password"], input[type="email"] {
    96.     border-radius: 8px;
    97.     box-shadow: inset 0 2px 5px #eee;
    98.     padding: 10px;
    99.     border: 1px solid #D4D4D4;
    100.     color: #333333;
    101.     margin-top: 5px;
    102. }
    103.  
    104. input[type="text"]:focus, input[type="password"]:focus, input[type="email"]:focus {
    105.     border: 1px solid #50afeb;
    106.     outline: none;
    107. }
    108.  
    109. input[type="button"], input[type="submit"] {
    110.     padding: 7px 15px;
    111.     background-color: #3c6db0;
    112.     text-align: center;
    113.     border-radius: 5px;
    114.     overflow: hidden;
    115.     min-width: 80px;
    116.     border: none;
    117.     color: #FFF;
    118.     box-shadow: 1px 1px 1px rgba(75, 75, 75, 0.3);
    119. }
    120.  
    121. input[type="button"]:hover, input[type="submit"]:hover {
    122.     background-color: #5a88c8;
    123. }
    124.  
    125. input[type="button"]:active, input[type="submit"]:active {
    126.     background-color: #5a88c8;
    127. }
    128. .err_msg{
    129.     color: red;
    130.     padding-right: 170px;
    131. }
    132. #password_err,#tel_err{
    133.     padding-right: 195px;
    134. }
    135.  
    136. #reg_btn{
    137.     margin-right:50px; width: 285px; height: 45px; margin-top:20px;
    138. }

    10.imgs图片

    （desert.jpg）

     (reg_bg_min.jpg)

    11.web.xml web配置文件(这个在配置webapp项目的时候自动配置)

    2. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
    3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
    5.          version="4.0">
    6. web-app>

    12.login.html文件

    1. html>
    2. <html lang="en">
    3.  
    4. <head>
    5.     <meta charset="UTF-8">
    6.     <title>logintitle>
    7.     <link href="css/login.css" rel="stylesheet">
    8. head>
    9.  
    10. <body>
    11. <div id="loginDiv">
    12.     <form action="/maven-mubatis-servlet-final/loginServlet" id="form" method="post">
    13.         <h1 id="loginMsg">登录案例h1>
    14.         <p>Username:<input id="username" name="username" type="text">p>
    15.  
    16.         <p>Password:<input id="password" name="password" type="password">p>
    17.  
    18.         <div id="subDiv">
    19.             <input type="submit" class="button" value="login up">
    20.             <input type="reset" class="button" value="reset">   
    21.             <a href="register.html">没有账号？点击注册a>
    22.         div>
    23.     form>
    24. div>
    25.  
    26. body>
    27. html>

    13.register.html文件

    1. html>
    2. <html lang="en">
    3. <head>
    4.     <meta charset="UTF-8">
    5.     <title>欢迎注册title>
    6.     <link href="css/register.css" rel="stylesheet">
    7. head>
    8. <body>
    9.  
    10. <div class="form-div">
    11.     <div class="reg-content">
    12.         <h1>欢迎注册h1>
    13.         <span>已有帐号？span> <a href="login.html">登录a>
    14.     div>
    15.     <form id="reg-form" action="/maven-mubatis-servlet-final/registerServlet" method="post">
    16.  
    17.         <table>
    18.  
    19.             <tr>
    20.                 <td>用户名td>
    21.                 <td class="inputs">
    22.                     <input name="username" type="text" id="username">
    23.                     <br>
    24.                     <span id="username_err" class="err_msg" style="display: none">用户名不太受欢迎span>
    25.                 td>
    26.  
    27.             tr>
    28.  
    29.             <tr>
    30.                 <td>密码td>
    31.                 <td class="inputs">
    32.                     <input name="password" type="password" id="password">
    33.                     <br>
    34.                     <span id="password_err" class="err_msg" style="display: none">密码格式有误span>
    35.                 td>
    36.             tr>
    37.  
    38.  
    39.         table>
    40.  
    41.         <div class="buttons">
    42.             <input value="注 册" type="submit" id="reg_btn">
    43.         div>
    44.         <br class="clear">
    45.     form>
    46.  
    47. div>
    48. body>
    49. html>

    12.pom.xml  maven配置文件

    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.0modelVersion>
    6.  
    7.     <groupId>org.examplegroupId>
    8.     <artifactId>maven-mubatis-servlet-finalartifactId>
    9.     <version>1.0-SNAPSHOTversion>
    10.     <packaging>warpackaging>
    11.     
    12.  
    13.  
    14.  
    15.     <properties>
    16.         <maven.compiler.source>18maven.compiler.source>
    17.         <maven.compiler.target>18maven.compiler.target>
    18.     properties>
    19.     <build>
    20.         <plugins>
    21.             
    22.             <plugin>
    23.                 <groupId>org.apache.tomcat.mavengroupId>
    24.                 <artifactId>tomcat7-maven-pluginartifactId>
    25.                 <version>2.2version>
    26.             plugin>
    27.             <plugin>
    28.                 <groupId>org.apache.maven.pluginsgroupId>
    29.                 <artifactId>maven-compiler-pluginartifactId>
    30.                 <configuration>
    31.                     <source>17source>
    32.                     <target>17target>
    33.                 configuration>
    34.             plugin>
    35.         plugins>
    36.     build>
    37.  
    38.     <dependencies>
    39.         <dependency>
    40.             <groupId>javax.servletgroupId>
    41.             <artifactId>javax.servlet-apiartifactId>
    42.             <version>3.1.0version>
    43.             <scope>providedscope>
    44.         dependency>
    45.         
    46.         <dependency>
    47.             <groupId>commons-iogroupId>
    48.             <artifactId>commons-ioartifactId>
    49.             <version>2.6version>
    50.         dependency>
    51.         
    52.         <dependency>
    53.             <groupId>org.mybatisgroupId>
    54.             <artifactId>mybatisartifactId>
    55.             <version>3.5.5version>
    56.         dependency>
    57.         
    58.         <dependency>
    59.             <groupId>mysqlgroupId>
    60.             <artifactId>mysql-connector-javaartifactId>
    61.             <version>8.0.29version>
    62.         dependency>
    63.         
    64.         <dependency>
    65.             <groupId>junitgroupId>
    66.             <artifactId>junitartifactId>
    67.             <version>4.13.2version>
    68.             <scope>Testscope>
    69.         dependency>
    70.         
    71.         <dependency>
    72.             <groupId>org.slf4jgroupId>
    73.             <artifactId>slf4j-apiartifactId>
    74.             <version>1.7.36version>
    75.         dependency>
    76.         
    77.         <dependency>
    78.             <groupId>ch.qos.logbackgroupId>
    79.             <artifactId>logback-classicartifactId>
    80.             <version>1.2.3version>
    81.         dependency>
    82.         
    83.         <dependency>
    84.             <groupId>ch.qos.logbackgroupId>
    85.             <artifactId>logback-coreartifactId>
    86.             <version>1.2.3version>
    87.         dependency>
    88.     dependencies>
    89. project>

    13.MySQL数据库

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

     14.对Servlet SqlSessionFactory的代码优化

    请看文章：对Servlet SqlSessionFactory的代码优化_我的猴子的博客-CSDN博客

  • 相关阅读:
    力扣刷题记录141.1-----34. 在排序数组中查找元素的第一个和最后一个位置
    计算机毕业设计ssm基于SSM的社区疫情防控管理信息系统的设计与实现khjit系统+程序+源码+lw+远程部署
    SPI通信
    关于调参技巧的问题
    OData WebAPI实践-与ABP vNext集成
    【产品经理修炼之道】- 从需求到功能的转化过程
    Springboot配置Swagger2
    快鲸智慧社区系统是如何助力物业公司降本增收的？
    FFmpeg源代码简单分析-其他-libavdevice的gdigrab
    dockerfile避坑笔记（VMWare下使用Ubuntu在Ubuntu20.04基础镜像下docker打包多个go项目）
  • 原文地址：https://blog.csdn.net/qq_51272114/article/details/126087602