SpringBoot+PageHelper实现分页功能

1.在pom.xml中添加PageHelper的依赖包

	<!--添加pageHelper插件-->
	<dependency>
		<groupId>com.github.pagehelper</groupId>
		<artifactId>pagehelper-spring-boot-starter</artifactId>
		<version>1.2.3</version>
	</dependency>

2.在application.yml中添加配置

pagehelper:
	  #helper-dialect: mysql
	  reasonable: true
	  support-methods-arguments: true
	  params: count=countSql

3.在Controller中使用PageHelper将查询结果分页

    /**
     * 产品信息查询
     * @param Product
     * @return
     */
    @RequestMapping(value="/productQuery",method = RequestMethod.GET)
    @ResponseBody
    public PageInfo<Product> vehicleQuery(Product product){
        LOG.info("传入实体查询,实体:{}",product);
        PageInfo<Product> pageInfo = null;
        try{
            PageHelper.startPage(0,3);
            List<Product> products = productService.productQuery(product);
            LOG.info("传入实体查询，结果为:",product);
            pageInfo = new PageInfo<Product>(products);
        }catch(Exception e){
            e.printStackTrace();
        }
        return pageInfo;
    }

其实只是对结果List进行了一个分页操作