SpringBoot+MyBatis PageHelperでページング
5905 ワード
POMファイルインポート依存
ymlでの構成:
Param:
Controller:
<!-- 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);
}