基于Spring5、MyBatis完成登录，注册，查询功能

步骤

1. 构建数据库，表
2. 编写实体类
3. 构建dao层(MyBatis的配置文件)
4. 配置Spring配置文件
5. 编写service层
6. 编写测试层(test)

1.构建数据库 表

2.编写实体类User

import org.springframework.stereotype.Component;
@Component
public class User {
    private String username;
    private int userid;
    private String userpassword;
    private String useremail;

    public User(String username, int userid, String userpassword, String useremail) {
        this.username = username;
        this.userid = userid;
        this.userpassword = userpassword;
        this.useremail = useremail;
    }

    public User() {
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public int getUserid() {
        return userid;
    }

    public void setUserid(int userid) {
        this.userid = userid;
    }

    public String getUserpassword() {
        return userpassword;
    }

    public void setUserpassword(String userpassword) {
        this.userpassword = userpassword;
    }

    public String getUseremail() {
        return useremail;
    }

    public void setUseremail(String useremail) {
        this.useremail = useremail;
    }

    @Override
    public String toString() {
        return "User{" +
                "username='" + username + '\'' +
                ", userid=" + userid +
                ", userpassword='" + userpassword + '\'' +
                ", useremail='" + useremail + '\'' +
                '}';
    }
}

3.配置MyBatis配置文件

连接到我们的数据库

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<!--核心配置文件-->
<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <!--<property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&amp;useUnicode=true"/>-->
                <property name="url" value="jdbc:mysql://localhost:3306/review?useSSL=false&amp;useUnicode=true&amp;characterEncoding=utf-8&amp;serverTimezone=UTC"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <!--每一个Mapper.xml文件都需要在mybatis核心配置文件中注册-->
    <mappers>
        <mapper resource="UserDaoMapper.xml"/>
    </mappers>
</configuration>

需要注意的点为在mybatis-config.xml文件中有一个标签，这个标签中放的是每个Mapper.xml(接口实现的xml文件)。
换句话说，每个mapper.xml文件都需要在mybatis-config.xml文件中配置才可以使用

4.编写Spring配置文件

因为是基于注解开发，所以我们在spring的配置文件下只需要放入需要扫描的包就可以，但是在类上一定要记得写好注解

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
    <!--扫描MyPackage下面的所有类-->
    <context:component-scan base-package="MyPackage"></context:component-scan>
</beans>

功能实现
1.注册

UserMapper

@Component
public interface UserMapper {
    //用户注册
    int addUser(User user);
    //查询用户
    User searchUser(int id);
    //展示所有用户
    List<User> listUsers();
}

UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="MyPackage.dao.UserMapper">
    <insert id="addUser" parameterType="MyPackage.pojo.User">
        insert into t_user values (#{username},#{userid},#{userpassword},#{useremail})
    </insert>
    <select id="searchUser" parameterType="int" resultType="MyPackage.pojo.User">
        select *from t_user where userid=#{userid}
    </select>
    <resultMap id="listUser" type="MyPackage.pojo.User">
        <result column="username" property="username"/>
        <result column="userid" property="userid"/>
        <result column="userpassword" property="userpassword"/>
        <result column="useremail" property="useremail"/>
    </resultMap>
    <select id="listUsers" resultMap="listUser">
        select *from t_user
    </select>
</mapper>

这里需要注意的点是:
在查询所有用户的信息时，用到了resultMap
其中里面的column指的是数据库中的字段
property指的是类的属性

5.编写service层

@Service("userService")
public class UserService {
//    @Autowired
//    public UserMapper userMapper;
    public void Register(User user){
        SqlSession sqlSession = Mybatisutils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
        int result = userMapper.addUser(user);
        if (result>0){
            System.out.println("注册成功");
            sqlSession.commit();
        }else {
            System.out.println("注册失败");
        }
        sqlSession.close();
    }
    public User searchUser(int id){
        SqlSession sqlSession = Mybatisutils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
        User searchUser = userMapper.searchUser(id);
        return searchUser;
    }
    @Test
    public List<User> listUsers(){
        SqlSession sqlSession = Mybatisutils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
        List<User> userList = (List<User>) userMapper.listUsers();
        return userList;
    }
}

6.编写测试层(test)

service的测试

 @Test
    public void test1(){
        ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
        UserService userService = (UserService) context.getBean("userService", UserService.class);
        userService.Register(new User("java", 9, "13579564", "1356579@qq.com"));
    }
    @Test
    public void test2(){
        ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
        UserService userService = context.getBean("userService", UserService.class);
        User searchUser = userService.searchUser(5);
        System.out.println(searchUser);
    }
    @Test
    public void test3(){
        ApplicationContext context = new ClassPathXmlApplicationContext("bean1.xml");
        UserService userService = context.getBean("userService", UserService.class);
        List<User> userList = userService.listUsers();
        for (User user : userList) {
            System.out.println(user);
        }
    }

UserMapper.xml的测试

 @Test
    public void test1(){
        SqlSession sqlSession = Mybatisutils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
        int result = userMapper.addUser(new User("hello", 6, "13579", "13579@qq.com"));
        if (result>0){
            System.out.println("注册成功");
        }else {
            System.out.println("注册失败");
        }
        sqlSession.commit();
        sqlSession.close();
    }
     @Test
    public void test2(){
        SqlSession sqlSession = Mybatisutils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
        User searchUser = userMapper.searchUser(1);
        System.out.println(searchUser);
    }
    @Test
    public void test3(){
        SqlSession sqlSession = Mybatisutils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
        List<User> userList = userMapper.listUsers();
        for (User user : userList) {
            System.out.println(user);
        }
    }

查询所有用户运行截图