Mybatis-Plus使用分页查询插件

1，加入依赖

    com.baomidou
    mybatis-plus-boot-starter
    3.4.2

2，配置插件

@Configuration
public class MPConfig {

    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor(){
        MybatisPlusInterceptor  mybatisPlusInterceptor=new MybatisPlusInterceptor();
        mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor());
        return mybatisPlusInterceptor;
    }

}

3，测试

@Test
public void testSelectPage() {
    Page page = new Page<>(1,2); //根据条件查询数据

    QueryWrapper wrapper = new QueryWrapper();

    wrapper.gt("age", 20); //年龄大于20岁

    IPage iPage = this.userMapper.selectPage(page, wrapper);
    System.out.println("数据总条数：" + iPage.getTotal());
    System.out.println("总页数：" + iPage.getPages());
    List users = iPage.getRecords();
    for (User user : users) {
        System.out.println("user = " + user);
    }
}