package com.ycl.config;
|
|
import com.github.pagehelper.PageHelper;
|
import org.springframework.context.annotation.Bean;
|
import org.springframework.context.annotation.Configuration;
|
|
import java.util.Properties;
|
|
/***
|
* 分页配置
|
* @author:lcj
|
*/
|
@Configuration
|
public class PageHelperConfig {
|
|
/**
|
* 配置mybatis的分页插件pageHelper
|
*
|
* @return
|
*/
|
@Bean
|
public PageHelper pageHelper() {
|
PageHelper pageHelper = new PageHelper();
|
Properties properties = new Properties();
|
properties.setProperty("offsetAsPageNum", "true");
|
properties.setProperty("rowBoundsWithCount", "true");
|
properties.setProperty("reasonable", "true");
|
properties.setProperty("dialect", "postgresql");//配置postgresql数据库的方言支持Oracle,Mysql,MariaDB,SQLite,Hsqldb,PostgreSQL六种数据库
|
pageHelper.setProperties(properties);
|
return pageHelper;
|
}
|
}
|
