安装分页插件
定义一个分页插件的配置类
@Configuration
@MapperScan("dao或者Mapper的相对目录")
public class MybatisPlusConfig {
//旧版
@Bean
public PaginationInterceptor paginationInterceptor() {
return new PaginationInterceptor();
}
//新版3.5以后
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2));
return interceptor;
}
}
测试分页方法
Dao层接口
@Mapper
public interface RoleDao extends BaseMapper<Role> {}
service接口
public interface RoleService extends IService<Role> {}
service接口实现类
@Service
public class RoleServiceImpl extends ServiceImpl<RoleDao,Role> implements RoleService {}
测试方法
@Autowired
RoleService roleService;
@Test
void roleTest(){
Page<Role> rp = (Page<Role>) roleService.page(new Page<>(1,20),null);
System.out.println(rp.getSize());//当前页的记录数
System.out.println(rp.hasPrevious());//是否有上一页
System.out.println(rp.hasNext());//是否有下一页
System.out.println(rp.getRecords());//当前页的全部信息
System.out.println(rp.getTotal());//数据表中所有记录总数
System.out.println(rp.getPages());//分了几页(总页数)
System.out.println(rp.getCurrent());//当前第几页
}