mybatisPlus分页查询的配置类

SpringBoot中分页查询的配置类

@Configuration
public class MybatisPlusConfig {

    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor(){
        //1 创建MybatisPlusInterceptor拦截器对象
        MybatisPlusInterceptor mpInterceptor=new MybatisPlusInterceptor();
        //2 添加分页拦截器
        mpInterceptor.addInnerInterceptor(new PaginationInnerInterceptor());
        return mpInterceptor;
    }
}

测试·

 //  分页查询（需要去配置类）
    @Test
    void testSeleLim() {
        Page<User> page = new Page<>(1,2);// 第一页，一页显示2条数据
//        Page<User> userPage = userDao.selectPage(page, null);
// 引用数据类型指向是地址值，userPage和page指向一个地址值
        userDao.selectPage(page, null);
        System.out.println(page.getRecords()); //当前页数据

//        ==>  Preparing: SELECT COUNT(*) FROM user
//        ==> Parameters:
//        <==    Columns: COUNT(*)
//        <==        Row: 5
//        <==      Total: 1
//        ==>  Preparing: SELECT id,name,password,age,tel FROM user LIMIT ?
//        ==> Parameters: 2(Long)
//        <==    Columns: id, name, password, age, tel
//        <==        Row: 1, Tom, tom, 3, 18866668888
//        <==        Row: 2, Jerry, jerry, 4, 16688886666
//        <==      Total: 2
    }