1. 在config文件里面新增分頁插件

//分頁插件
@Bean
public PaginationInterceptor paginationInterceptor() {
    PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
    // 設(shè)置請(qǐng)求的頁面大于最大頁后操作， true調(diào)回到首頁，false 繼續(xù)請(qǐng)求  默認(rèn)false
    // paginationInterceptor.setOverflow(false);
    // 設(shè)置最大單頁限制數(shù)量，默認(rèn) 500 條，-1 不受限制
    // paginationInterceptor.setLimit(500);
    // 開啟 count 的 join 優(yōu)化,只針對(duì)部分 left join
//        paginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(true));
    return paginationInterceptor;
}

2. 在代碼里使用分頁插件

@Test
void testPageQuery(){
    Page<User> page = new Page<>(3,5);
    //wrapper 條件構(gòu)造器，模糊查詢，排序，多表查詢，子查詢等
    userMapper.selectPage(page,null);
    List<User> users = page.getRecords();
    users.forEach(System.out::println);
    System.out.println(page.getCurrent());
    System.out.println(page.getOrders());
    System.out.println(page.getRecords());
    System.out.println(page.getSize());
    System.out.println(page.getTotal());
    System.out.println(page.hasNext());
    System.out.println(page.hasPrevious());

}


@Test
void testPageQuery2(){
    Page<Map<String,Object>> page = new Page<>(3,5);
    //wrapper 條件構(gòu)造器，模糊查詢，排序，多表查詢，子查詢等
    IPage<Map<String,Object>> mapIPage = userMapper.selectMapsPage(page,null);
    mapIPage.getRecords().forEach(System.out::println);
    System.out.println(page.getCurrent());
    System.out.println(page.getOrders());
    System.out.println(page.getRecords());
    System.out.println(page.getSize());
    System.out.println(page.getTotal());
    System.out.println(page.hasNext());
    System.out.println(page.hasPrevious());