MybatisPlus 的分页

import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

/**
 * @Description: Service业务层处理
 * @Author: Ching Wanyi
 * @Date: 2025-09-17
 */
 
@Service
public class TServiceImpl extends ServiceImpl<TMapper, T> implements TService {
  
  @Override
  public Result<List<T>> page(Integer pageNum, Integer pageSize, T t){
    IPage<T> page = new Page<>();
    page.setCurrent(pageNum);
    page.setSize(pageSize);
    LambdaQueryWrapper<T> queryWrapper = new LambdaQueryWrapper<>();
    IPage<T> pageResult = page(iPage, queryWrapper);
    List<T> tList = page.getRecords();
    result tList;
  }
}

import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;

/**
 * @Description: Service业务层处理
 * @Author: Ching Wanyi
 * @Date: 2025-09-17
 */
 
@Service
public class TServiceImpl extends ServiceImpl<TMapper, T> implements TService {
  @Autowired
  private TMapper mapper;
  
  @Override
  public Result<List<T>> page(Integer pageNum, Integer pageSize, T t){
    IPage<T> page = new Page<>();
    page.setCurrent(pageNum);
    page.setSize(pageSize);
    LambdaQueryWrapper<T> queryWrapper = new LambdaQueryWrapper<>();
    IPage<T> pageResult = mapper.selectPage(iPage, queryWrapper);
    List<T> tList = page.getRecords();
    result tList;
  }
}

上面这两种方法哪种都可以没什么区别
一定要记得配置分页拦截器，不然会导致无法正常显示分页页数、总行数等

MybatisPlus的分页拦截器

MybatisPlus的分页拦截器它的原理是识别到有分页拦截器后会改写原本的sql语句。

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;

/**
 * @Description: MybatisPlus分页拦截器
 * @Author: Ching Wanyi
 * @Date: 2025-09-18
 */

@Configuration
public class MPConfig {

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