MyBatis-plus一些总结感受

自动分页: PaginationInnerInterceptor

多租户: TenantLineInnerInterceptor

动态表名: DynamicTableNameInnerInterceptor

乐观锁: OptimisticLockerInnerInterceptor

sql 性能规范: IllegalSQLInnerInterceptor

防止全表更新与删除: BlockAttackInnerInterceptor

overflow 溢出总页数后是否进行处理(我们需要的东西),

maxLimit 	单页分页条数限制(默认无限制),

dbType 数据库类型(根据类型获取应使用的分页方言) ,

dialect 方言实现类

    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        //  插件
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        // 分页插件
        PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor();
        // 设置最大分页数
        paginationInnerInterceptor.setMaxLimit(100L);
        // 是否对超过最大分页时做溢出处理
        paginationInnerInterceptor.setOverflow(true);
        // 设置数据库类型
        paginationInnerInterceptor.setDbType(DbType.MARIADB);
        //paginationInnerInterceptor.setProperties();
       // paginationInnerInterceptor.setDialect();
        //paginationInnerInterceptor.setOptimizeJoin();
        // 添加分页插件
        interceptor.addInnerInterceptor(paginationInnerInterceptor);
        return interceptor;
    }

 import com.baomidou.mybatisplus.annotation.DbType;
    import com.baomidou.mybatisplus.core.metadata.IPage;
    import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
    import lombok.Data;
    import lombok.NoArgsConstructor;
    /**
     * @author Tony brings water
     * @date 2021/8/18 14:10
     * 分页删除某页唯一记录后，自动跳转至前一页(默认实现是跳转至首页)
     */
    @Data
    @NoArgsConstructor
    public class NewPaginationInnerInterceptor extends PaginationInnerInterceptor {
    private DbType dbType;
    public NewPaginationInnerInterceptor(DbType dbType) {
    this.dbType = dbType;
    }
    @Override
    protected void handlerOverflow(IPage<?> page) {
    //查询前一页
    page.setCurrent(page.getCurrent() - 1);
    }
    }

    @Configuration
    public class MybatisConfig {
     @Bean
     public MybatisPlusInterceptor mybatisPlusInterceptor() {
     MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
     //设置分页插件属性：请求页超出范围时，返回前一页
     NewPaginationInnerInterceptor paginationInnerInterceptor = new NewPaginationInnerInterceptor
     paginationInnerInterceptor.setOverflow(true);
     interceptor.addInnerInterceptor(paginationInnerInterceptor);
     return interceptor;
     }
    }