Spring Boot整合Mybatis

在Spring Boot中，Mybatis官方提供了一套自动化配置方案，可以做到Mybatis开箱即用。

1. 创一个一个Spring Boot项目，添加pom依赖

<dependencies> 
	<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.1.2</version>
	</dependency> 
	<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
		<scope>runtime</scope>
	</dependency>
	<dependency>
		<groupId>com.alibaba</groupId>
		<artifactId>druid-spring-boot-starter</artifactId>
		<version>1.1.21</version>
	</dependency>
	<dependency>
		<groupId>org.projectlombok</groupId>
		<artifactId>lombok</artifactId>
		<optional>true</optional>
	</dependency>
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-test</artifactId>
		<scope>test</scope>
		<exclusions>
			<exclusion>
				<groupId>org.junit.vintage</groupId>
				<artifactId>junit-vintage-engine</artifactId>
			</exclusion>
		</exclusions>
	</dependency>
</dependencies>

数据库表：

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT NULL,
  `locked` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

实体类：

@Data
public class User {
    private Long id;
    private String username;
    private String address;
} 

application.properties文件配置数据库基本参数

server.port=8081
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.url=jdbc:mysql://localhost:3306/test?characterEncoding=utf-8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root

UserMapper：

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

有两种方法指明该类是一个Mapper接口：

//第一中，使用Mapper接口
@Mapper
//第二种，在配置类中添加注解
@MapperScan(basePackages = "org.javaboy.mybatis.mapper")

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="org.javaboy.mybatis.mapper.UserMapper">

    <select id="getAllUser" resultType="org.javaboy.mybatis.bean.User">
        select * from user;
    </select>

</mapper>

关于mapper.xml的位置：

如何想要放在mapper包下面的需要在pom.xml当中重新指明资源文件的位置，因为maven工程默认资源文件都在resources目录下。

<resources>
	<resource>
		<directory>src/main/java</directory>
		<includes>
			<include>**/*.xml</include>
		</includes>
	</resource>
	<resource>
		<directory>src/main/resources</directory>
	 </resource>
</resources>

如果放在resources当中，只需创建一个与mapper相同路径的文件夹即可。

测试结果：

@SpringBootTest
class MybatisApplicationTests { 

	@Autowired
	private UserMapper userMapper; 
	
	@Test
	void contextLoads() {
		List<User> allUser = userMapper.getAllUser();
		for (User user : allUser) {
			System.out.println(user);
		}
	} 
}