Servlet+Mybatis小练习Demo——用户登录注册

阳光明媚UPUP

已于 2023-07-04 18:23:58 修改

阅读量123

点赞数

分类专栏：小demo 文章标签： mybatis servlet

于 2023-07-03 21:58:52 首次发布

本文链接：https://blog.csdn.net/csdnidofkdy2138/article/details/131524266

版权

小demo 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

项目结构

数据表结构

pom文件

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.example</groupId>
    <artifactId>MavenWeb3</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>

    <dependencies>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.0.1</version>
            <!--编译和测试有效，运行环境无效。因为打包发布到的tomcat中也有servlet的jar包，运行会jar包冲突-->
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>commons-io</groupId>
            <artifactId>commons-io</artifactId>
            <version>2.4</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.12</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.8</version>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.tomcat.maven</groupId>
                <artifactId>tomcat7-maven-plugin</artifactId>
                <version>2.2</version>
                <configuration>
                    <port>8080</port>
                    <!--path为虚拟路径，可以为模块名MavenWeb3
                    这时访问路径就为http://localhost:8080/MavenWeb3/html/a.html
                    也可以为/，这时访问路径就为http://localhost:8080/html/a.html
                    -->
                    <path>/MavenWeb3</path>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

pojo

@Data//包括get、set、equals、hashCode、canEqual、toString、无参构造，没有有参构造
@NoArgsConstructor
public class User {
    private Integer id;
    private String name;
    private String password;
    private String email;
    private Date birthday;
    private String infoId;
    private String englishTeacher;

    public User(Integer id, String name, String password, String email, Date birthday, String infoId, String englishTeacher) {
        this.id = id;
        this.name = name;
        this.password = password;
        this.email = email;
        this.birthday = birthday;
        this.infoId = infoId;
        this.englishTeacher = englishTeacher;
    }
}

mybatis核心配置mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <environments default="development">
        <environment id="development"><!--环境development、test，可以配置多个数据库连接的环境信息，将来通过default属性切换-->
            <transactionManager type="JDBC"/><!--事务管理器,spring可接管-->
            <dataSource type="POOLED"><!--数据源-->
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/jdbc?useSSL=false"/>
                <!--如果mysqlurl中有&符号需要进行转义为&amp;，如useSSL=false&amp;useServerPrepStmts=true
                127.0.0.1:3306本机默认端口可省略不写，直接为///-->
                <property name="username" value="root"/>
                <property name="password" value="root123"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <package name="com.kdy.mapper"/>
    </mappers>
</configuration>

mapper接口

public interface UserMapper {
    @Select("select * from users where name = #{name} and password = #{password}")
    User selectByNameAndPwd(@Param("name")String name,@Param("password")String password);

    @Select("select * from users where name = #{name}")
    User selectByName(@Param("name") String name);

    @Insert("insert into users(name,password,email,birthday,infoId,english_teacher)" +
            " values(#{name},#{password},#{email},#{birthday},#{infoId},#{englishTeacher});")
    int insert(User user);
}

sql映射文件UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.kdy.mapper.UserMapper">
</mapper>

登录界面html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>login</title>
</head>
<body>
<form action="/MavenWeb3/loginServlet" method="post" id="form">
    <h1>登录</h1>
    <p>用户名：</p><input name="name" type="text"><br>
    <p>密  码：</p><input name="password" type="password">
    <input type="submit" value="登录" >
    <input type="reset" value="重置" >
    <a href="register.html">点击注册</a>
</form>
</body>
</html>

注册界面html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>register</title>
</head>
<body>
<form action="/MavenWeb3/registerServlet" method="post">
    <table>
        <tr>
            <td>用户名：</td>
            <td><input name="name" type="text">
                <br>
                <span style="display: none">用户名不太受欢迎</span>
            </td>
        </tr>
        <tr>
            <td>密码：</td>
            <td><input name="password" type="text"></td>
        </tr>
        <tr>
            <td>邮箱：</td>
            <td><input name="email" type="text"></td>
        </tr>
        <tr>
            <td>生日：</td>
            <td><input name="birthday" type="date"></td>
        </tr>
        <tr>
            <td>infoId</td>
            <td><input name="infoId" type="text"></td>
        </tr>
        <tr>
            <td>英语老师：</td>
            <td><input name="englishTeacher" type="text"></td>
        </tr>
        <tr>
            <td><input type="submit" value="提交">
            <input type="reset" value="重置"></td>
        </tr>
    </table>
</form>
</body>
</html>

登录的servlet

@WebServlet("/loginServlet")
public class LoginServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        String name = req.getParameter("name");
        String password = req.getParameter("password");
        SqlSessionFactory sqlSessionFactory = SqlSessionFactoryUtils.getSqlSessionFactory();
        //2.获取SqlSession对象，用它来执行sql
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //3.执行sql
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User user = mapper.selectByNameAndPwd(name,password);
        resp.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");
        PrintWriter writer = resp.getWriter();
        if (user != null){
            writer.write("login success!");
        }else{
            writer.write("login fail!");
        }
        //4.释放资源
        sqlSession.close();
    }
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doGet(req, resp);
    }
}

注册的servlet

@WebServlet("/registerServlet")
public class RegisterServlet extends HttpServlet {
    @SneakyThrows
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        String name = req.getParameter("name");
        String password = req.getParameter("password");
        String email = req.getParameter("email");
        String birthday = req.getParameter("birthday");
        String infoId = req.getParameter("infoId");
        String englishTeacher = req.getParameter("englishTeacher");
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        Date birthdayDate = sdf.parse(birthday);
        User user = new User(null, name, password, email, birthdayDate, infoId, englishTeacher);
        //1.加载mybatis核心配置，获取SqlSessionFactory
        SqlSessionFactory sqlSessionFactory = SqlSessionFactoryUtils.getSqlSessionFactory();
        //2.获取SqlSession对象，用它来执行sql
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //3.执行sql
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User existUserName = mapper.selectByName(name);
        resp.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");
        PrintWriter writer = resp.getWriter();
        if (existUserName ==null){
            int count = mapper.insert(user);
            sqlSession.commit();
            //4.释放资源
            sqlSession.close();
            writer.write("注册成功");
        }else{
            writer.write("用户名太受欢迎了");
        }
    }
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doGet(req,resp);
    }
}

SqlSessionFactoryUtils

/**
 * 通过静态代码块使得该类再被JVM加载时仅执行唯一一次静态代码块中的内容，生成一个sqlSessionFactory对象保存在该类变量中
 * 后续直接通过public的getSqlSessionFactory方法拿到这个对象即可。避免重复频繁创建sqlSessionFactory对象的问题。
 */
public class SqlSessionFactoryUtils {
    private static SqlSessionFactory sqlSessionFactory;

    static {
        try {
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    public static SqlSessionFactory getSqlSessionFactory(){
        return sqlSessionFactory;
    }
}