mybatis-plus分页插件实现

        <!-- mybatis plus -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.2</version>
        </dependency>

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;

/**
 * User: ldj
 * Date: 2023/4/18
 * Time: 19:44
 * Description: 分页参数
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
@ApiModel(value = "PageParams", description = "分页查询-请求参数模型")
public class PageParams implements Serializable {

    public static final int DEFAULT_PAGE_CURRENT = 1;
    public static final int DEFAULT_PAGE_SIZE = 10;

    @ApiModelProperty(value = "当前页码", example = "1")
    private int pageNo = DEFAULT_PAGE_CURRENT;

    @ApiModelProperty(value = "每页显示的记录数", example = "10")
    private int pageSize = DEFAULT_PAGE_SIZE;

}

package com.itheima.education.base.model;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;

import java.util.List;

/**
 * User: ldj
 * Date: 2023/4/18
 * Time: 19:44
 * Description: 分页查询结果封装
 */
@Data
@AllArgsConstructor
@ApiModel(value = "PageResult", description = "分页查询-响应数据模型")
public class PageResult<T> {

    @ApiModelProperty("总记录数")
    private long counts;

    @ApiModelProperty("当前页码")
    private long pageNo;

    @ApiModelProperty("每页记录数")
    private long pageSize;

    @ApiModelProperty("数据列表")
    private List<T> items;

}

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.autoconfigure.condition.ConditionalOnMissingBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

/**
 * User: ldj
 * Date: 2023/4/20
 * Time: 4:02
 * Description: mybatis-plus配置
 */
@Configuration
@MapperScan("com.xxxx.oooo.mapper")
public class MybatisPlusConfig {

    //分页查询拦截器 原理是将分页参数放入ThreadLocal,拦截器捕获到要执行的sql脚本,然后从ThreadLocal取出分页参数拼接limit
    @Bean
    @ConditionalOnMissingBean(value = MybatisPlusInterceptor.class)
    public MybatisPlusInterceptor mybatisPlusInterceptor(){
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        PaginationInnerInterceptor pageInterceptor = new PaginationInnerInterceptor(DbType.MYSQL);
        pageInterceptor.setOverflow(true); //当设置请求的页码大于最大页码时，true:当前页码改成第一页
        pageInterceptor.setMaxLimit(100L); //单页记录数限制100条，默认无限制
        interceptor.addInnerInterceptor(pageInterceptor);
        return interceptor;
    }

}

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.itheima.education.base.model.PageParams;
import com.itheima.education.base.model.PageResult;
import com.itheima.education.content.model.dto.QueryCourseParamsDto;
import com.itheima.education.content.model.po.CourseBase;
import com.itheima.education.content.service.mapper.CourseBaseMapper;
import com.itheima.education.content.service.service.CourseBaseService;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * User: ldj
 * Date: 2023/4/20
 * Time: 5:34
 * Description: No Description
 */
@Slf4j
@Service
public class CourseBaseServiceImpl extends ServiceImpl<CourseBaseMapper, CourseBase> implements CourseBaseService {

    /**
     * @param courseParamsDto 查询条件
     * @param pageParams      分页参数
     */
    @Override
    public PageResult<CourseBase> PageQueryCourseBase(QueryCourseParamsDto courseParamsDto, PageParams pageParams) {

        //分页参数
        Page<CourseBase> page = new Page<>(pageParams.getPageNo(), pageParams.getPageSize());

        List<CourseBase> items = lambdaQuery()
                .like(StringUtils.isNotBlank(courseParamsDto.getCourseName()), CourseBase::getName, courseParamsDto.getCourseName())
                .eq(StringUtils.isNotBlank(courseParamsDto.getAuditStatus()), CourseBase::getAuditStatus, courseParamsDto.getAuditStatus())
                .eq(StringUtils.isNotBlank(courseParamsDto.getPublishStatus()), CourseBase::getStatus, courseParamsDto.getPublishStatus())
                .orderByDesc(CourseBase::getCreateDate)
                .page(page)
                .getRecords();

         return new PageResult<>(items.size(), pageParams.getPageNo(), pageParams.getPageSize(), items);
    }

}

import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.itheima.education.base.model.PageParams;
import com.itheima.education.base.model.PageResult;
import com.itheima.education.content.model.dto.QueryCourseParamsDto;
import com.itheima.education.content.model.po.CourseBase;
import com.itheima.education.content.service.service.CourseBaseService;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
class ContentServiceApplicationTests {

    @Autowired
    CourseBaseService courseBaseService;

    @Test
    void pageQueryCourseBase() throws JsonProcessingException {
        QueryCourseParamsDto queryCourseParamsDto = new QueryCourseParamsDto();
        queryCourseParamsDto.setCourseName("java");
        PageParams pageParams = new PageParams(10, 3);
        PageResult<CourseBase> pageResult = courseBaseService.PageQueryCourseBase(queryCourseParamsDto, pageParams);
        System.out.println(new ObjectMapper().writeValueAsString(pageResult));
    }

}