原生MybatisPlus实现分页查询

这里引用上篇文章：MybatisPlus实现简单增删改查

分页查询

一、需配置分页插件

package com.sh.config;

import com.baomidou.mybatisplus.extension.plugins.OptimisticLockerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@MapperScan("com.sh.mapper") //扫描mapper
@Configuration //配置类
@EnableTransactionManagement //启用注解事务管理
public class MybatisPlusConfig {

    // 分页插件
    @Bean
    public PaginationInterceptor paginationInterceptor(){
        return new PaginationInterceptor();
    }
}

二、controller

 //分页查询
    @GetMapping("/selectUserByPage")
    public List<User> selectByPage(){
        //1：页数 5：条数
        Page<User> page = new Page<>(1,5);
        userMapper.selectPage(page,null);
        return page.getRecords();
    }

项目结构