MyBatis分页

MyBatis分页

PageHelper

// 依赖：com.github.pagehelper : pagehelper-spring-boot-starter

PageHelper.startPage(pageNum, pageSize);
List<MarketGoodsOrderEntity> marketGoodsOrderEntityList =
         marketGoodsOrderMapper.selectList(wrapper);

IPage

// 配置类

@Configuration
public class MybatisPlusConfig {

    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {

        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));

        return interceptor;
    }
}
// QueryWrapper分页

Page<MarketGoodsOrderEntity> page = new Page<>(pageNum, pageSize);
// IPage<MarketGoodsOrderEntity> iPage = marketGoodsOrderService.page(page, wrapper);
IPage<MarketGoodsOrderEntity> iPage = marketGoodsOrderMapper.selectPage(page, wrapper);
List<MarketGoodsOrderEntity> marketGoodsOrderEntityList = iPage.getRecords();

页参数

@NotNull(message = "pageNum不能为空")
@Min(value = 1, message = "页数从1开始")
Integer pageNum = PageConfig.pageNum;

@NotNull(message = "pageSize不能为空")
@Min(value = 1, message = "每页最少包含1项")
@Max(value = 100, message = "超出每页最大限制")
Integer pageSize = PageConfig.pageSize;