1.在com 得pom文件里集成
<mybatis-plus.version>3.5.6</mybatis-plus.version>
<!-- mybatis-plus --> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>${mybatis-plus.version}</version> </dependency> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-extension</artifactId> <version>${mybatis-plus.version}</version> </dependency>
2.common目录下 BaseMapper 继承
extends BaseMapper<T>
3.resource下 application-common.yml
# MyBatis-Plus配置 | |||
# https://baomidou.com/config/ | |||
mybatis-plus: | |||
# 对应的 XML 文件位置 | |||
mapperLocations: classpath*:mapper/**/*Mapper.xml | |||
# 实体扫描,多个package用逗号或者分号分隔 | |||
typeAliasesPackage: com.hmxc.**.domain | |||
# 加载全局的配置文件 | |||
configLocation: classpath:mybatis/mybatis-config.xml | |||
global-config: | |||
banner: false # 启动不显示banner信息 | |||
# db-config: | |||
# id-type: AUTO |
4.framework下得config添加 MyBatisPlusConfig.java 的配置
/** |
* Mybatis Plus 配置 |
* |
* @author ruoyi |
*/ |
@EnableTransactionManagement(proxyTargetClass = true) |
@Configuration |
public class MyBatisPlusConfig { |
@Bean |
public MybatisPlusInterceptor mybatisPlusInterceptor() { |
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor(); |
// 分页插件 |
interceptor.addInnerInterceptor(paginationInnerInterceptor()); |
// 乐观锁插件 |
interceptor.addInnerInterceptor(optimisticLockerInnerInterceptor()); |
// 阻断插件 |
interceptor.addInnerInterceptor(blockAttackInnerInterceptor()); |
return interceptor; |
} |
/** |
* 分页插件,自动识别数据库类型 https://baomidou.com/guide/interceptor-pagination.html |
*/ |
public PaginationInnerInterceptor paginationInnerInterceptor() { |
PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor(); |
// 设置数据库类型为mysql |
paginationInnerInterceptor.setDbType(DbType.POSTGRE_SQL); |
// 设置最大单页限制数量,默认 500 条,-1 不受限制 |
paginationInnerInterceptor.setMaxLimit(-1L); |
return paginationInnerInterceptor; |
} |
/** |
* 乐观锁插件 https://baomidou.com/guide/interceptor-optimistic-locker.html |
*/ |
public OptimisticLockerInnerInterceptor optimisticLockerInnerInterceptor() { |
return new OptimisticLockerInnerInterceptor(); |
} |
/** |
* 如果是对全表的删除或更新操作,就会终止该操作 https://baomidou.com/guide/interceptor-block-attack.html |
*/ |
public BlockAttackInnerInterceptor blockAttackInnerInterceptor() { |
return new BlockAttackInnerInterceptor(); |
} |
} |