Spring Boot 快速集成MyBatis-Plus框架

MyBatis-Plus官方文档

pom.xml

 <parent>
    <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-parent</artifactId>
     <version>2.5.8</version>
 </parent>

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.4.3.1</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

配置类

@Configuration
public class MyBatisPlusConfigure {

    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        // 分页配置
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        // 乐观锁
        interceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());
        return interceptor;
    }
}

application.yml 配置

# 数据库连接配置
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/grape_db_v1?useUnicode=true&useSSL=false&characterEncoding=utf8&serverTimezone=Asia/Shanghai
    username: root
    password: ******
# mybatis-plus配置
mybatis-plus:
  global-config:
    db-config:
      # logic-delete-field: isDeleted # 全局逻辑删除的实体字段名,配置后可以不用加@TableLogic注解
      logic-delete-value: 1 # 已删除值
      logic-not-delete-value: 0 # 未删除值
  configuration:
    # sql日志打印
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

基础增强类

// Service
public interface SysJobService extends IService<SysJob> {}

// ServiceImpl
public class SysJobServiceImpl extends ServiceImpl<SysJobMapper, SysJob> implements SysJobService {}

// Mapper
public interface SysJobMapper extends BaseMapper<SysJob> {}

// 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="">

</mapper>

分页功能

IPage<UserVo> selectPageVo(IPage<?> page, Integer state);
// or
List<UserVo> selectPageVo(IPage<UserVo> page, Integer state);

自动填充功能

// 自动填充配置类
@Component
public class DateMetaObjectHandler implements MetaObjectHandler {
    
    @Override
    public void insertFill(MetaObject metaObject) {
        this.strictInsertFill(metaObject,"createTime", LocalDateTime.class, LocalDateTime.now());
    }
    
    @Override
    public void updateFill(MetaObject metaObject) {
        this.strictUpdateFill(metaObject, "updateTime", LocalDateTime.class, LocalDateTime.now());
    }
}


// 实体类
/**
 * @TableField(fill = FieldFill.UPDATE) 在更新时候执行 DateMetaObjectHandler.updateFill 方法
 * @TableField(fill = FieldFill.INSERT) 在新增时候执行 DateMetaObjectHandler.insertFill 方法
 */
@TableField(fill = FieldFill.UPDATE)
private LocalDateTime gmtModified;

@TableField(fill = FieldFill.INSERT)
private LocalDateTime gmtCreate;