[Java] oracle+mybatis-plus+springboot实现分页查询的实例

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);
  }
}