SpringBoot整合Mybatis

新建 SpringBoot 项目

注意在新建项目时勾选 Spring Web

导入mybatis和mysql依赖

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>3.0.3</version>
</dependency>

<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <scope>runtime</scope>
</dependency>

yml 配置数据源

spring:
  datasource:
    url: jdbc:mysql:///springboot?serverTimezone=UTC
    username: root
    password: 
    driver-class-name: com.mysql.jdbc.Driver

创建javaBean实体类

public class User {
    private Integer id;
    private String username;
    private String password;
    //省略 getter、setter

创建mapper接口类

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

创建对应的 mapper.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="cn.hxy.springbootmybatis.mapper.UserMapper">
    <select id="finAll" resultType="user">
        select * from t_user
    </select>
</mapper>

在application.yml 中配置 mybatis

mybatis:
  #配置mapper.xml映射文件路径
  mapper-locations: classpath:mapper/*Mapper.xml
  #配置别名
  type-aliases-package: cn.hxy.springbootmybatis.domain

在测试类中进行测试

@SpringBootTest
class UserMapperTest {
    @Autowired
    private UserMapper userMapper;

    @Test
    public  void findAll() {
        List<User> all = userMapper.findAll();
        System.out.println(all);
    }
}