mysql能不能用分页插件_spring-boot使用mysql分页插件PageInterceptor

首先声明:

PageHelper 这个类不在sqlsessionfactory的拦截器实现里;

我们使用下图的这个拦截实现

实际使用步骤如下:

1.添加jar包:

com.github.pagehelper

pagehelper

5.0.0

2.为sqlsessionfactory添加拦截器

@Bean(name = "PFSqlSessionFactory")

@Primary

public SqlSessionFactory PFSqlSessionFactory(@Qualifier("PFDataSource") DataSource PFDataSource)

throws Exception {

final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();

sessionFactory.setDataSource(PFDataSource);

Interceptor interceptor = new PageInterceptor();

Properties properties = new Properties();

properties.setProperty("helperDialect", "mysql");

properties.setProperty("offsetAsPageNum", "true");

properties.setProperty("rowBoundsWithCount", "true");

properties.setProperty("reasonable", "true");

properties.setProperty("supportMethodsArguments", "true");

interceptor.setProperties(properties);

sessionFactory.setPlugins(new Interceptor[]{interceptor});

sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver()

.getResources(MAPPER_LOCATION));

return sessionFactory.getObject();

}

3. 代码中使用如下:

先使用如下代码

PageHelper.startPage(1, 10);

查询完成之后使用如吓代码

PageInfo page = new PageInfo<>(clues);

page对象中有分页所需的齐全的参数

end.