试了一晚上,PageHelper一直不生效。最后发生是因为重新定义了SqlSessionFactory但是并没有配置对应的PageHelper插件,所以导致使用PageHelper.startPage(1,1);无效.
@Bean
public SqlSessionFactory sqlSessionFactory() throws Exception {
SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
sessionFactory.setDataSource(dataSource);
sessionFactory.setTypeAliasesPackage("com.lcheng.mango.**.entity");
PathMatchingResourcePatternResolver resolver=new PathMatchingResourcePatternResolver();
sessionFactory.setMapperLocations(resolver.getResources("classpath*:**/sqlmap/*.xml"));
Interceptor[] plugins = new Interceptor[]{pageHelper()};
sessionFactory.setPlugins(plugins);
return sessionFactory.getObject();
}
重点是这一段:
Interceptor[] plugins = new Interceptor[]{pageHelper()};
sessionFactory.setPlugins(plugins);