7.分页查询

分页查询

1.在Config中配置分页插件

//分页插件
@Bean
public PaginationInterceptor paginationInterceptor(){
    return new PaginationInterceptor();
}

2.分页测试

//分页测试
@Test
void pageTest(){
    //pageNum, pageSize
    Page<User> page = new Page<>(1,5);
    userMapper.selectPage(page,null);
    page.getRecords().forEach(System.out::println);
    //SELECT id,name,age,email,version,create_time,update_time FROM user LIMIT 0,5
}