Mybatis-plus分页查询

如果对mybatis-plus基本使用不清楚的可以查看作者文章简单了解下mybatis-plus：https://blog.csdn.net/m0_37298602/article/details/117788047

分页配置

package com.kwin.test.config;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;

import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;

/**
 * @author : Kwin
 * @version V1.0
 * @Package com.kwin.test.config
 * @Description:
 * @date 2021年06月11日 10:33
 **/

@EnableTransactionManagement(proxyTargetClass = true)
@Configuration
public class MybatisPlusConfig {
    
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
        return mybatisPlusInterceptor;
    }
    @Bean
    public PaginationInnerInterceptor paginationInterceptor(MybatisPlusInterceptor mybatisPlusInterceptor) {
        // 分页拦截器
        PaginationInnerInterceptor paginationInnerInterceptor = new PaginationInnerInterceptor();
        
        // 请求页面大于最大页后操作，true调回首页，false继续请求 默认false
        paginationInnerInterceptor.setOverflow(false);
        // 单页最大数量限制，默认500， -1不限制
        paginationInnerInterceptor.setMaxLimit(500L);
        mybatisPlusInterceptor.addInnerInterceptor(paginationInnerInterceptor);
        
        return paginationInnerInterceptor;
    }
}

测试代码

package com.kwin.test;

import java.util.List;

import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.kwin.test.entity.User;
import com.kwin.test.mapper.UserMapper;

@SpringBootTest
class TestApplicationTests {
    @Autowired
    private UserMapper userMapper;

    @Test
    void test5() {
        IPage<User> userPage = new Page<>(2, 4);//参数一是当前页，参数二是每页个数

        userPage = userMapper.selectPage(userPage, null);
        System.out.println("total is " + userPage.getTotal());
        System.out.println("size is " + userPage.getSize());
        System.out.println("current is " + userPage.getCurrent());
        System.out.println("pages is " + userPage.getPages());
        List<User> list = userPage.getRecords();
        for(User user : list){
            System.out.println(user);
        }
    }
}

结果