Java中PageHelper分頁(yè)后對(duì)list操作導(dǎo)致分頁(yè)無(wú)效

更新時(shí)間：2021年05月25日 09:56:53 作者：He Ain''''t Hero

在項(xiàng)目中使用分頁(yè)插件的時(shí)候發(fā)現(xiàn)PageHelper插件失效了，本文就來介紹一下Java中PageHelper分頁(yè)后對(duì)list操作導(dǎo)致分頁(yè)無(wú)效的解決方法，感興趣的可以了解一下

1.問題

阿里巴巴Java開發(fā)手冊(cè)

在這里插入圖片描述

1.1.PageHelper先開啟分頁(yè)，后對(duì)list數(shù)據(jù)操作

@Override
    public PageInfo<HdQueryVo> getRecordsByView(int pageNo, int pageSize) {
        PageHelper.startPage(pageNo,pageSize);
        List<HdQueryVo> hdQueryVosByView = actionMapper.getActionByView();

        List<HdQueryVo> hdQueryVos = new ArrayList<>();

        for (HdQueryVo hdQueryVo : hdQueryVosByView) {
            HdQueryVo hdQueryVoSingle = new HdQueryVo();
            hdQueryVoSingle.setHdId(hdQueryVo.getHdId());
            hdQueryVoSingle.setHdType(hdQueryVo.getHdType());
            hdQueryVoSingle.setHdTitle(hdQueryVo.getHdTitle());
            hdQueryVoSingle.setHdStartDate(hdQueryVo.getHdStartDate());
            hdQueryVoSingle.setHdEndDate(hdQueryVo.getHdEndDate());
            hdQueryVoSingle.setHdStatus(hdQueryVo.getHdStatus());
            hdQueryVoSingle.setHdImage(hdQueryVo.getHdImage());
            hdQueryVoSingle.setHdNumber(hdQueryVo.getHdNumber());
            hdQueryVoSingle.setGmtCreate(hdQueryVo.getGmtCreate());
            hdQueryVoSingle.setGmtModified(hdQueryVo.getGmtModified());
            hdQueryVoSingle.setUserId(hdQueryVo.getUserId());
            if (hdQueryVo.getHdType().equals(0)) {
                hdQueryVoSingle.setHdJoinUsers(onlineWorksMapper.getOnlineJoinUsers(hdQueryVo.getHdId()));
            } else {
                hdQueryVoSingle.setHdJoinUsers(offlineUsersMapper.getOfflineJoinUsers(hdQueryVo.getHdId()));
            }
            hdQueryVos.add(hdQueryVoSingle);
        }
        PageInfo<HdQueryVo> pageViewInfo = new PageInfo<>(hdQueryVos);

        return pageViewInfo;
    }

可以分頁(yè)，但是數(shù)據(jù)量錯(cuò)誤，total始終等于每頁(yè)數(shù)據(jù)量，即pageSize

在這里插入圖片描述

1.2.先對(duì)list數(shù)據(jù)進(jìn)行操作，后開啟分頁(yè)

@Override
    public PageInfo<HdQueryVo> getRecordsByView(int pageNo, int pageSize) {
        
        List<HdQueryVo> hdQueryVosByView = actionMapper.getActionByView();

        List<HdQueryVo> hdQueryVos = new ArrayList<>();

        for (HdQueryVo hdQueryVo : hdQueryVosByView) {
            HdQueryVo hdQueryVoSingle = new HdQueryVo();
            hdQueryVoSingle.setHdId(hdQueryVo.getHdId());
            hdQueryVoSingle.setHdType(hdQueryVo.getHdType());
            hdQueryVoSingle.setHdTitle(hdQueryVo.getHdTitle());
            hdQueryVoSingle.setHdStartDate(hdQueryVo.getHdStartDate());
            hdQueryVoSingle.setHdEndDate(hdQueryVo.getHdEndDate());
            hdQueryVoSingle.setHdStatus(hdQueryVo.getHdStatus());
            hdQueryVoSingle.setHdImage(hdQueryVo.getHdImage());
            hdQueryVoSingle.setHdNumber(hdQueryVo.getHdNumber());
            hdQueryVoSingle.setGmtCreate(hdQueryVo.getGmtCreate());
            hdQueryVoSingle.setGmtModified(hdQueryVo.getGmtModified());
            hdQueryVoSingle.setUserId(hdQueryVo.getUserId());
            if (hdQueryVo.getHdType().equals(0)) {
                hdQueryVoSingle.setHdJoinUsers(onlineWorksMapper.getOnlineJoinUsers(hdQueryVo.getHdId()));
            } else {
                hdQueryVoSingle.setHdJoinUsers(offlineUsersMapper.getOfflineJoinUsers(hdQueryVo.getHdId()));
            }
            hdQueryVos.add(hdQueryVoSingle);
        }
        PageHelper.startPage(pageNo,pageSize);
        PageInfo<HdQueryVo> pageViewInfo = new PageInfo<>(hdQueryVos);

        return pageViewInfo;
    }

數(shù)據(jù)可以查詢出來，總數(shù)total也正確，但是分頁(yè)功能失效

在這里插入圖片描述

**加粗樣式**

2.原因

PageHelper中startPage開啟分頁(yè)方法只對(duì)后面的sql查詢起作用

1.1 錯(cuò)誤原因是提前開啟分頁(yè)后，對(duì)list操作，即PageInfo pageViewInfo = new PageInfo<>(hdQueryVos);

在這里插入圖片描述

/**
* 包裝Page對(duì)象
*
* @param list
*/
public PageInfo(List list) {
this(list, 8);
}

只是把list轉(zhuǎn)為PageInfo對(duì)象，不影響前面分頁(yè)數(shù)據(jù)的操作

1.2 錯(cuò)誤原因是先對(duì)list操作后，開啟翻頁(yè)后沒有sql語(yǔ)句

在這里插入圖片描述

即sql語(yǔ)句沒有參與分頁(yè)查詢

3.解決方案

直接對(duì)分頁(yè)后的PageInfo對(duì)象中的數(shù)據(jù)進(jìn)行操作
①對(duì)list集合操作，先取出PageInfo里的list集合數(shù)據(jù)，再對(duì)數(shù)據(jù)進(jìn)行相關(guān)操作
②將操作完后的list集合再次存到PageInfo里，進(jìn)行return

在這里插入圖層

在這里插入圖片描述

@Override
    public PageInfo<HdQueryVo> getRecordsByView(int pageNo, int pageSize) {
        PageInfo<HdQueryVo> source = PageHelper.startPage(pageNo, pageSize).doSelectPageInfo(()->{
            actionMapper.getActionByView();
        });
        // 需要轉(zhuǎn)換的對(duì)象
        PageInfo<HdQueryVo> target = new PageInfo<>();
        // 復(fù)制分頁(yè)屬性
        BeanUtils.copyProperties(source, target);
        // 對(duì)查詢的list進(jìn)行下一步操作，比如類型轉(zhuǎn)換后
        List<HdQueryVo> collect = source.getList().stream().collect(Collectors.toList());
        List<HdQueryVo> hdQueryVos = new ArrayList<>();

        for (HdQueryVo hdQueryVo : collect) {
            HdQueryVo hdQueryVoSingle = new HdQueryVo();
            hdQueryVoSingle.setHdId(hdQueryVo.getHdId());
            hdQueryVoSingle.setHdType(hdQueryVo.getHdType());
            hdQueryVoSingle.setHdTitle(hdQueryVo.getHdTitle());
            hdQueryVoSingle.setHdStartDate(hdQueryVo.getHdStartDate());
            hdQueryVoSingle.setHdEndDate(hdQueryVo.getHdEndDate());
            hdQueryVoSingle.setHdStatus(hdQueryVo.getHdStatus());
            hdQueryVoSingle.setHdImage(hdQueryVo.getHdImage());
            hdQueryVoSingle.setHdNumber(hdQueryVo.getHdNumber());
            hdQueryVoSingle.setGmtCreate(hdQueryVo.getGmtCreate());
            hdQueryVoSingle.setGmtModified(hdQueryVo.getGmtModified());
            hdQueryVoSingle.setUserId(hdQueryVo.getUserId());
            if (hdQueryVo.getHdType().equals(0)) {
                hdQueryVoSingle.setHdJoinUsers(onlineWorksMapper.getOnlineJoinUsers(hdQueryVo.getHdId()));
            } else {
                hdQueryVoSingle.setHdJoinUsers(offlineUsersMapper.getOfflineJoinUsers(hdQueryVo.getHdId()));
            }
            hdQueryVos.add(hdQueryVoSingle);
        }
        // 加工后的數(shù)據(jù)放入新的pageinfo
        target.setList(hdQueryVos);

        return target;
    }

在這里插入圖片描述

參考資料：

PageHelper官方文檔
 PageHelper分頁(yè)查詢結(jié)果后再對(duì)數(shù)據(jù)List操作的方法

到此這篇關(guān)于Java中PageHelper分頁(yè)后對(duì)list操作導(dǎo)致分頁(yè)無(wú)效的文章就介紹到這了,更多相關(guān)Java PageHelper分頁(yè)無(wú)效內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！

您可能感興趣的文章: