SpringBoot+MyBatis PageHelperでページング

5905 ワード

POMファイルインポート依存
<!-- PageHelper   -->
        <!--  -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.10</version>
        </dependency>

ymlでの構成:
pagehelper:
  reasonable: true
  support-methods-arguments: true
  params: count=countSql

Param:
@Data
public class AuctionParam {
    int auctionId;
    /**    */
    int page;         
    /**    */
    int size;         
}

Controller:
 /**
     *     id        
     *    
     * @return
     */
    @PostMapping(value = "getCommodityAuction")
    public Result getCommodityAuction(@RequestBody AuctionParam param){

        PageHelper.startPage(param.getPage(),param.getSize());
        List<CommodityAuction> list = commodityAuctionService.getCommodityAuction(param.getAuctionId());

        //PageInfo      Bean
        PageInfo<CommodityAuction> pageInfo =new PageInfo<>(list);

        return Result.ok("list",pageInfo);
    }