ruoyi框架分页失效原因

最新推荐文章于 2024-07-25 10:34:04 发布

Mr Tang

最新推荐文章于 2024-07-25 10:34:04 发布

阅读量1.5k

点赞数 6

分类专栏： java 文章标签： java

本文链接：https://blog.csdn.net/qq_45443475/article/details/129360744

版权

java 专栏收录该内容

53 篇文章 7 订阅

订阅专栏

1.问题

controller中使用startPage();

    @Log(title = "用户访问次数明细查询", businessType = BusinessType.OTHER)
    @PostMapping("/logininforList")
    public TableDataInfo logininforList(@RequestBody CloudUser cloudUser) {
        startPage();
        List<SysLogininfor> relationAppList = cloudUserService.logininforList(cloudUser);
        return getDataTable(relationAppList);
    }

service中多个查询方法导致框架不知道后面查询也需要分页，所以分页失效。

    @Override
    public List<SysLogininfor> logininforList(CloudUser cloudUser) {
        CloudUserIdentify cloudUserIdentify = cloudUserIdentifyMapper.selectCloudUserIdentifyByIdentifyId(cloudUser.getUserId());
        List<String> phoneList = cloudUserIdentify == null ? cloudUserMapper.selectPhoneByUserId(cloudUser) : cloudUserMapper.selectPhoneList(cloudUser);
        List<SysLogininfor> sysLogininfors = cloudUserMapper.selectLogininforList(phoneList.toArray(new String[phoneList.size()]));
        return sysLogininfors;
    }

2.解决办法

controller注释startPage();

    @Log(title = "用户访问次数明细查询", businessType = BusinessType.OTHER)
    @PostMapping("/logininforList")
    public TableDataInfo logininforList(@RequestBody CloudUser cloudUser) {
//        startPage();
        List<SysLogininfor> relationAppList = cloudUserService.logininforList(cloudUser);
        return getDataTable(relationAppList);
    }

service加入分页开始的标识

    @Override
    public List<SysLogininfor> logininforList(CloudUser cloudUser) {
        CloudUserIdentify cloudUserIdentify = cloudUserIdentifyMapper.selectCloudUserIdentifyByIdentifyId(cloudUser.getUserId());
        List<String> phoneList = cloudUserIdentify == null ? cloudUserMapper.selectPhoneByUserId(cloudUser) : cloudUserMapper.selectPhoneList(cloudUser);
        PageDomain pageDomain = TableSupport.getPageDomain();
        PageHelper.startPage(pageDomain.getPageNum(), pageDomain.getPageSize(), pageDomain.getOrderBy());
        List<SysLogininfor> sysLogininfors = cloudUserMapper.selectLogininforList(phoneList.toArray(new String[phoneList.size()]));
        return sysLogininfors;
    }

3.核心步骤

在需要分页的方法前面加上分页代码如下

PageDomain pageDomain = TableSupport.getPageDomain();
PageHelper.startPage(pageDomain.getPageNum(), pageDomain.getPageSize(), pageDomain.getOrderBy());