Spring boot框架整合（Mybatis-Plus）

技术栈：

• Spring Boot

• Mybatis-Plus

• Lombok

1. 新建Spring Boot项目

dependencies 勾选Spring Web 、Spring Boot DevTools和 Lombok.

devtools:项目的热加载重启插件

lombok:简化代码的工具

2. 整合Mybatis-Plus框架

2.1导入所需依赖

<!-- 整合mybatis-plus-->

<dependency>

<groupId>com.baomidou</groupId>

<artifactId>mybatis-plus-boot-starter</artifactId>

<version>3.4.1</version>

</dependency>

<!-- mp代码生成器-->

<dependency>

<groupId>com.baomidou</groupId>

<artifactId>mybatis-plus-generator</artifactId>

<version>3.4.1</version>

</dependency>

<!-- 引入freemarker-->

<dependency>

<groupId>org.freemarker</groupId>

<artifactId>freemarker</artifactId>

<version>2.3.30</version>

</dependency>

<!-- 数据库连接-->

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<scope>runtime</scope>

</dependency>

</dependencies>

freemarker和mp代码生成器可以不添加，手动写实体，mapper以及xml文件

2.2配置文件

配置数据库以及mybatis-plus的mapper的xml文件的扫描路径

server.port=8080

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

spring.datasource.url=jdbc:mysql://localhost:3306/ ?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai

spring.datasource.username=

spring.datasource.password=

mybatis-plus.mapper-locations=classpath*:/mapper/**Mapper.xml

2.3开启接口扫描，添加分页插件

@Configuration

@MapperScan("your mapper package")

public class MybatisPlusConfig {

@Bean

public MybatisPlusInterceptor mybatisPlusInterceptor(){

MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();

//分页插件

interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2));

//防止全表更新和删除

interceptor.addInnerInterceptor(new BlockAttackInnerInterceptor());

return interceptor;

}

@Bean

public ConfigurationCustomizer configurationCustomizer(){

return configuration -> configuration.setUseDeprecatedExecutor(false);

}

}

2.4

2.4.1mp代码生成器

（或）2.4.2手动添加

mapper包下的接口

public interface CategoryMapper extends BaseMapper<Category> {

}

mappers报下的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="com.imooc.reader.mapper.CategoryMapper">

</mapper>