后端：mybatisPlus分页查询

合集 - OEP项目(8)

1.项目依赖2024-02-042.SpringSecurity2024-02-093.注册和登录的实现2024-02-144.回调函数是把函数当参数供函数体调用的函数2024-02-23

5.后端：mybatisPlus分页查询2024-03-01

6.前端：el-pagination分页2024-03-037.后端：数据流、数据聚合2024-03-068.正则表达式2024-03-13

收起

配置类：

package com.oep.backend.config;
 
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
 
@Configuration
public class MybatisConfig {
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return interceptor;
    }
}

实现分页功能：

        QueryWrapper<Testpaper> testpaperQueryWrapper = new QueryWrapper<>();
        testpaperQueryWrapper.orderByDesc("id");
        testpaperQueryWrapper.eq("enterprise_name", enterprise.getName());
 
        IPage<Testpaper> testpaperIPage = new Page<>(1,5);  //  查询哪一页以及每页大小
        testpaperIPage = testpaperMapper.selectPage(testpaperIPage,testpaperQueryWrapper);
        List<Testpaper> list = testpaperIPage.getRecords();
 
        for(Testpaper item: list){  System.out.println(item);   }  //  当前页数据
        System.out.println(testpaperIPage.getPages());  //  总共多少页
        System.out.println(testpaperIPage.getCurrent());    //  当前页码
        System.out.println(testpaperIPage.getTotal());  //  总记录数