springboot框架 pagehelper无效

[小白不怕黑]

分页无效 直接查出全部了

@RequestMapping(value = "/web/hweix_allproduct") //前端页面分类跳转地址查出全部商品显示列表页
public ModelAndView selectAllProduct(HttpServletRequest request, HttpServletResponse response,HttpSession session){
ModelAndView mv = new ModelAndView("vip_index/hproduct_list");
// int id = Integer.parseInt(request.getParameter("id"));
int userId=3;
int pageNum = 1;
int pageSize= 10;
int count = weixVipUserService.searchCount(userId);

Map<String,Integer> map = new HashMap<String, Integer>();

map.put("userId",userId);

PageHelper.startPage(pageNum , pageSize);
List<WeixVipProduct> products = weixVipUserService.selectProbuctList(map);
mv.addObject("products",products);

return mv;
}

[小白不怕黑]

来个大神帮帮忙啊

[小菜鸟菜菜]

我也是这个问题，楼主是怎么解决的？

[逗比小猫]

使用了 <dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
就不用加载Bean了，可以配置文件
#pagehelper分页插件
pagehelper:
helperDialect: mysql
reasonable: true
supportMethodsArguments: true
params: count=countSql
page-size-zero: true

我的虽然第一次可以，测试方法测也没问题，但实际时点下一页就没有数据了，店上一页也没有数据了。郁闷……

[yuu_l]

楼主的pom.xml文件，好了两个关键的东西：autoconfigure 和starter <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper</artifactId> <version>${github.pagehelper}</version> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-autoconfigure</artifactId> <version>1.2.3</version> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.2.3</version> </dependency>

[忧郁的双鱼座程序猿]

配置文件如下 /** * @author:manbu * @data 2019/1/29- 17:53 * @TODO: * @console: */ @Configuration public class PageMybatisConf { @Bean public PageHelper pageHelper() { System.out.println("MyBatisConfiguration.pageHelper()"); PageHelper pageHelper = new PageHelper(); Properties p = new Properties(); p.setProperty("offsetAsPageNum", "true"); p.setProperty("rowBoundsWithCount", "true"); p.setProperty("reasonable", "true"); p.setProperty("dialect","mysql"); pageHelper.setProperties(p); return pageHelper; } } 查询方法 在进入Dao之前 先执行如下代码 List<XX>list= xxxDao.select(); 再执行 PageInfo<Task> pageInfo = new PageInfo<>(tasks); 然后把 pageInfo 返回回去 完美解决 PageHelper.startPage(page, size);

[忧郁的双鱼座程序猿]

配置文件如下 @Configuration class MybatisConfigurer { /*设置 mybatis的xml 注入*/ @Bean public SqlSessionFactory sqlSessionFactoryBean(DataSource dataSource) throws Exception { SqlSessionFactoryBean factory = new SqlSessionFactoryBean(); factory.setDataSource(dataSource); factory.setTypeAliasesPackage("com.anole.common.entity"); // 添加XML目录 ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver(); /*设置mapper文件的存储位置*/ factory.setMapperLocations(resolver.getResources("classpath:mapper/*.xml")); return factory.getObject(); } /*设置 mybatis 的 dao 层注入*/ @Bean public MapperScannerConfigurer mapperScannerConfigurer() { MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer(); mapperScannerConfigurer.setSqlSessionFactoryBeanName("sqlSessionFactoryBean"); /*设置 dao层接口所在位置*/ mapperScannerConfigurer.setBasePackage("com.anole.db.dao"); return mapperScannerConfigurer; } }