package com.gkhy.assess.common.config;
|
|
import com.baomidou.mybatisplus.annotation.DbType;
|
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
|
import com.baomidou.mybatisplus.extension.plugins.inner.OptimisticLockerInnerInterceptor;
|
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
|
import com.github.pagehelper.PageHelper;
|
import org.springframework.context.annotation.Bean;
|
import org.springframework.context.annotation.Configuration;
|
|
import java.util.Properties;
|
|
@Configuration
|
public class MybatisPlusConfig {
|
/**
|
* 新的分页插件,一缓和二缓遵循mybatis的规则,
|
*/
|
@Bean
|
public MybatisPlusInterceptor mybatisPlusInterceptor() {
|
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
|
PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor(DbType.MYSQL);
|
paginationInnerInterceptor.setOverflow(false);//溢出总页数 总是跳到第一页
|
interceptor.addInnerInterceptor(paginationInnerInterceptor);
|
//添加乐观锁插件
|
interceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());
|
return interceptor;
|
}
|
|
@Bean
|
public PageHelper pageHelper() {
|
PageHelper pageHelper = new PageHelper();
|
//添加配置，也可以指定文件路径
|
Properties p = new Properties();
|
p.setProperty("offsetAsPageNum", "true");
|
p.setProperty("rowBoundsWithCount", "true");
|
p.setProperty("reasonable", "true");
|
pageHelper.setProperties(p);
|
return pageHelper;
|
}
|
|
}
|
