本篇内容主要讲解“oracle+mybatis-plus+springboot怎么实现分页查询”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“oracle+mybatis-plus+springboot怎么实现分页查询”吧!
1、建一个配置类
计算
安全
数据库
网络和加速
企业服务
package com.sie.demo.config;
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.springframework.boot.autoconfigure.condition.ConditionalOnClass;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
/**
* @author liaozhifeng
* @date 2021/7/31 11:14
* @Version 1.0
*/
@Configuration
@ConditionalOnClass(value = {PaginationInterceptor.class})
public class MybatisPlusConfig {
// 最新版
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
// 数据库的配置DbType.ORACLE 根据自己的数据库选择
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.ORACLE));
return interceptor;
}
}package com.sie.demo.service.impl;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.sie.demo.entity.Users;
import com.sie.demo.entity.vo.PageUserVo;
import com.sie.demo.mapper.UserMapper;
import com.sie.demo.service.UserService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
import org.springframework.util.DigestUtils;
import javax.annotation.Resource;
import javax.servlet.http.HttpSession;
import java.util.List;
/**
* @author liaozhifeng
* @date 2021/7/27 14:03
* @Version 1.0
*/
@Service
@Slf4j
public class UserServiceImpl extends ServiceImpl<UserMapper, Users> implements UserService {
@Resource
UserMapper userMapper;
/**
* 分页查询用户
* @param currentPage
* @param pageSize
* @return
*/
@Override
public PageUserVo selectAll(long currentPage, long pageSize) {
IPage<Users> userPage = new Page<>(currentPage, pageSize);//参数一是当前页，参数二是每页个数
IPage<Users> iPage = userMapper.selectPage(userPage, null);
List<Users> list = iPage.getRecords();
Long total = iPage.getTotal();
PageUserVo pageUserVo = new PageUserVo(list, total);
return pageUserVo;
}
}package com.sie.demo.controller;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.conditions.query.QueryChainWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.sie.demo.entity.RetCode;
import com.sie.demo.entity.RetResponse;
import com.sie.demo.entity.RetResult;
import com.sie.demo.entity.Users;
import com.sie.demo.entity.vo.PageUserVo;
import com.sie.demo.service.impl.UserServiceImpl;
import com.sie.demo.util.TokenUtil;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
import javax.servlet.http.HttpSession;
import java.util.List;
@Controller
@RestController
@RequestMapping("user")
@Slf4j
public class UserController {
@Autowired
UserServiceImpl userService;
/**
*
*
* @param currentPage
* @param pageSize
* @return
*/
@GetMapping("selectAll")
public RetResult<PageUserVo> selectAll(long currentPage, long pageSize) {
log.info(currentPage+pageSize+"=========================");
PageUserVo pageUserVo = userService.selectAll(currentPage,pageSize);
return RetResponse.makeOKRsp(pageUserVo);
}
}到此，相信大家对“oracle+mybatis-plus+springboot怎么实现分页查询”有了更深的了解，不妨来实际操作一番吧！这里是亿速云网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！
亿速云「云服务器」，即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘，价格低至29元/月。点击查看>>
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
