Mybatis-plus分页插件使用

1.注册分页插件拦截器

package net.xdclass.shopmanager.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 MybatisPlusConfig {

    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor(){
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        // 分页插件
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return interceptor;
    }
}

2.测试

/**
 * 测试分页
 */
@Test
public void testPage() {
    QueryWrapper<BannerDO> wrapper = new QueryWrapper<>();
    wrapper.eq("weight",2);
    // 第1页，每页2条记录
    Page<BannerDO> page = new Page<>(1, 2);
    IPage<BannerDO> bannerDOPage = bannerMapper.selectPage(page, wrapper);
    System.out.println("总条数"+bannerDOPage.getTotal());
    System.out.println("总页数"+bannerDOPage.getPages());
    System.out.println("当前页数据"+bannerDOPage.getRecords().toString());
}

Mybatis-plus分页插件使用

原文：https://www.cnblogs.com/xl4ng/p/14587830.html