<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>${mybatis-plus.version}</version>
</dependency>

mybatis-plus:
  # 數(shù)據(jù)庫類型
  db-type: mysql
  # 實體掃描，多個package用逗號或者分號分隔
  typeAliasesPackage: com.example.entity
  # 加載自定義的Mybatis XML映射文件
  mapperLocations: classpath:/mapper/**/*.xml
  # 是否開啟SQL打印
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    map-underscore-to-camel-case: true

@Component
public class DataChangeInterceptor implements ISqlParser {

    @Override
    public void parser(MetaObject metaObject) {
        MappedStatement mappedStatement = (MappedStatement) metaObject.getValue("delegate.mappedStatement");
        String sql = mappedStatement.getSqlSource().getBoundSql(metaObject).getSql();
        // 處理SQL語句，檢測是否為對指定表進行的增刪改操作
        // 如果是，則發(fā)送通知給應(yīng)用程序
    }
}

@Configuration
public class MybatisPlusConfig {

    @Autowired
    private DataChangeInterceptor dataChangeInterceptor;

    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(dataChangeInterceptor);
        return interceptor;
    }
}

@Data
@TableName("user")
public class User {

    @TableId(type = IdType.AUTO)
    private Long id;

    private String name;
    
    @TableLogic
    private Integer deleted;
}