SpringBoot整合Mybatis

目录

（1）引入依赖

（2）编写Mapper接口

（3）编写Mapper映射文件

（4）编写yml配置文件

（5）编写测试类

---

（1）引入依赖

<dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>2.2.1</version>
</dependency>
<dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><scope>runtime</scope>
</dependency>
<dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope>
</dependency>

（2）编写Mapper接口

@Mapper
public interface UserMapper {List<Users> findall();
}

（3）编写Mapper映射文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.gq.springnootdemo.mapper.UserMapper"><select id="findall" resultType="com.gq.springnootdemo.pojo.Users">select *from user;</select></mapper>

（4）编写yml配置文件

# 数据源
spring:datasource:driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql:///mybatis?serverTimezone=UTCusername: rootpassword: root# mybatis配置
mybatis:# 映射文件位置mapper-locations: com/gq/springnootdemo/mapper/*Mapper.xml# 别名type-aliases-package: com.gq.springnootdemo.pojo#日志格式
logging:pattern:console: '%d{HH:mm:ss.SSS} %clr(%-5level) ---  [%-15thread] %cyan(%-50logger{50}):%msg%n'

（5）编写测试类

@SpringBootTest
class SpringnootdemoApplicationTests {@Autowiredprivate UserMapper userMapper;@Testvoid contextLoads() {List<Users> users=userMapper.findall();users.forEach(System.out::println);}}

总体架构图：