- 创建分页的配置类
package com.sky.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 Config {
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2));
return interceptor;
}
}
- 简单使用分页配置
QueryWrapper<User> qw = new QueryWrapper<>();
IPage<User> page = new Page<>();
page.setCurrent(1);
page.setSize(3);
IPage<User> result = userMapper.selectPage(page, qw);
List<User> records = result.getRecords();
System.out.println(records.size());
System.out.println(result.getSize());
System.out.println(result.getPages());
System.out.println(result.getTotal());
System.out.println(result.getCurrent());