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

     }

}