SpringBoot整合Mybatis

1、添加Mybatis的起步依赖和数据库驱动坐标

<!--Mybatis的起步依赖-->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.0.1</version>
</dependency>
<!-- mysql连接驱动 -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

2、添加数据库连接信息
在application.yml中添加数据库的连接信息

spring:  
  #数据库配置#
  datasource:    
    url: jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC #数据库连接
    username: root 
    password: root
    driverClassName: com.mysql.cj.jdbc.Driver # MySQL6以后用的驱动是com.mysql.cj.jdbc.Driver, MySQL5的驱动是com.mysql.jdbc.Driver`在这里插入代码片`

3、创建实体Bean

public class User implements Serializable {
    private Integer id;
    private String name;
    private String password;
    private Integer rid;
    private Boolean sex;
    private Integer age;
    private String phone;
    private String address;
    
    // getter and setter
    // toString
}

4、编写Mapper

@Mapper
public interface UserMapper {
    public List<User> queryUserList();
}

注意：@Mapper标记该类是一个mybatis的mapper接口，可以被SpringBoot自动扫描到Spring上下文中
5、配置Mapper映射文件

<?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="com.gx.mapper.UserMapper">
    <select id="queryUserList" resultType="com.gx.po.User">
        select * from user
    </select>
</mapper>

6、在application.yml中添加mybatis的信息

#spring集成Mybatis环境
mybatis:
  type-aliases-package: com.gx.po #pojo别名扫描包
  mapper-locations: classpath:mapper/*Mapper.xml #加载Mybatis映射文件
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #配置打印sql语句

7、编写测试类

@RunWith(SpringRunner.class)
@SpringBootTest(classes = VueJSApplication.class)
public class MybatisTest {

    @Autowired
    private UserMapper userMapper;

    @Test
    public void testQueryUserList() throws Exception {
        List<User> users = userMapper.queryUserList();
        for (User user : users) {
            System.out.println("user = " + user);
        }
    }
}