spring_boot整合Mybatis

## 四、spring_boot整合Mybatis

1. 创建maven工程

2. 更改工程jdk版本

```
<properties>
<!-- java版本 -->
<java.version>1.8</java.version>
<!-- 编译时的编码 -->
<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
</properties>
<build>
<plugins>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>${java.version}</source>
<target>${java.version}</target>
<encoding>${maven.compiler.encoding}</encoding>
</configuration>
</plugin>
</plugins>
</build>
```

3. 引入spring boot 父类

```
<!-- 引入父类更好的规范各个依赖的version -->
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.0.RELEASE</version>
</parent>
```

4. 引入依赖

```
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
</dependencies>

```

5. 添加数据源，新增application.yml

```
spring:
datasource:
url: jdbc:mysql://192.168.128.11:3306/j815?useUnicode=true&characterEncoding=utf-8
username: root
password: 123456
driver-class-name: com.mysql.jdbc.Driver
mybatis:
mapperLocations: classpath:mybatis/com/jk/springboot/mapper/xml/*.xml
```

6. 在启动类加上

@MapperScan("com.jk.springboot.mapper")

7. 加入pagehelp,在pom.xml增加

```
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>3.7.5</version>
</dependency>
```

 

8. 增加如下配置类

```
@Configuration
public class HelperConfig {
// 配置mybatis的分页插件pageHelper
@Bean
public PageHelper pageHelper() {
PageHelper pageHelper = new PageHelper();
Properties properties = new Properties();
properties.setProperty("offsetAsPageNum", "true");
properties.setProperty("rowBoundsWithCount", "true");
properties.setProperty("reasonable", "true");
properties.setProperty("dialect", "mysql"); // 配置mysql数据库的方言
pageHelper.setProperties(properties);
return pageHelper;
}
}
```