ARTICLE DETAIL

资讯详情

深耕网站建设、视觉设计与SEO优化的一线实战洞察。

Mybatis-Plus实现分页查询

Mybatis-Plus实现分页查询

分页插件配置

MybatisPlusConfig

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 {/*** 添加分页插件*/@Beanpublic MybatisPlusInterceptor mybatisPlusInterceptor() {MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));return interceptor;}
}

分页查询学生

测试

    @Autowiredprivate StudentMapper studentMapper;@Testpublic void test() {int current = 1;  //当前页数int size = 10;    //当前展示数量Page<StudentEntity> page = new Page<>(current, size);studentMapper.selectPage(page, null);System.out.println("当前页数:" + page.getCurrent());System.out.println("当前展示数量:" + page.getSize());System.out.println("总页数:" + page.getPages());System.out.println("总数量:" + page.getTotal());System.out.println("当前展示数据:" + page.getRecords());}
返回列表