今天蠢了一上午才弄出這玩意，話不多說上代碼！
1、建一個(gè)配置類
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
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();// 數(shù)據(jù)庫(kù)的配置DbType.ORACLE 根據(jù)自己的數(shù)據(jù)庫(kù)選擇 interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.ORACLE)); return interceptor; }} |
2、service層的代碼
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
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@Slf4jpublic class UserServiceImpl extends ServiceImpl<UserMapper, Users> implements UserService { @Resource UserMapper userMapper; /** * 分頁(yè)查詢用戶 * @param currentPage * @param pageSize * @return */ @Override public PageUserVo selectAll(long currentPage, long pageSize) { IPage<Users> userPage = new Page<>(currentPage, pageSize);//參數(shù)一是當(dāng)前頁(yè)，參數(shù)二是每頁(yè)個(gè)數(shù) IPage<Users> iPage = userMapper.selectPage(userPage, null); List<Users> list = iPage.getRecords(); Long total = iPage.getTotal(); PageUserVo pageUserVo = new PageUserVo(list, total); return pageUserVo; }} |
3、controller層 RetResult是我自己定義的一個(gè)統(tǒng)一返回的泛型對(duì)象
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
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")@Slf4jpublic 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); }} |
到此這篇關(guān)于oracle+mybatis-plus+springboot實(shí)現(xiàn)分頁(yè)查詢的實(shí)例的文章就介紹到這了,更多相關(guān) mybatis-plus springboot分頁(yè)查詢內(nèi)容請(qǐng)搜索服務(wù)器之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持服務(wù)器之家！
原文鏈接：https://blog.csdn.net/weixin_46108919/article/details/119274278
