前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >java中使用PageInfo分页的几种方式总结(案例)-工作总结仅供自己学习

java中使用PageInfo分页的几种方式总结(案例)-工作总结仅供自己学习

作者头像
botkenni
发布2020-05-18 16:38:24
2.8K0
发布2020-05-18 16:38:24
举报
文章被收录于专栏:IT码农IT码农

方式一:

代码语言:javascript
复制
@Override
    public PageInfo<SettlementRecordDetailModel> payeeQuery(PartnerModel partner, Long orgId, Query query) {
        PageInfo<SettlementRecordDetailModel> pageInfo = null;
        if (partner.getPartnerType().equals(PartnerTypeConstants.PASSIVE_CREATE)) {
            // 客户端
            pageInfo = PageHelper.startPage(query.getPageNum(),
                    query.getPageSize()).doSelectPageInfo(() -> mapper.selectAllByOrgId(orgId));
        } else if (partner.getType().equals((short) 4)) {
            // 运营端
            pageInfo = PageHelper.startPage(query.getPageNum(),
                    query.getPageSize()).doSelectPageInfo(() -> mapper.selectAllByOperatorOrgId(partner.getOrgId()));
        }
        return pageInfo;
}

方式二:

代码语言:javascript
复制
@Override
    public PageInfo<SettlementRecordDetailModel> payeeQuery(PartnerModel partner, Long orgId, Query query) {
        PageInfo<SettlementRecordDetailModel> settlementRecordDetails = new PageInfo<>();
        List<SettlementRecordDetailModel> list = new ArrayList<>();
        if (!StringUtils.isEmpty(query.getWhere().get("customerOrgId"))) {
            Long customerId = Long.valueOf(String.valueOf(query.getWhere().get("customerId")));
            PageInfo<Object> pageInfo = PageHelper.startPage(query.getPageNum(), query.getPageSize()).doSelectPageInfo(() -> mapper.selectAllByCustomerId(customerId));

            List<SettlementRecordDetailModel> settlementRecordDetailModels = mapper.selectAllByCustomerId(customerId);
            settlementRecordDetails.setList(settlementRecordDetailModels);
        } else {
            Query q = new Query();
            List<CustomerV2Model> customerV2Models = setServiceClientService.customerQueryAll(q);
            for (CustomerV2Model customerV2Model : customerV2Models) {
                List<SettlementRecordDetailModel> settlementRecordDetailModels = mapper.selectAllByCustomerId(customerV2Model.getId());
                list.addAll(settlementRecordDetailModels);
            }
            settlementRecordDetails.setList(list);
        }
        return settlementRecordDetails;
    }

方式三:

代码语言:javascript
复制
@Override
public PageInfo<SettlementRecordDetailModel> query(Query query) {
    PageInfo<SettlementRecordDetailModel> pageInfo = super.query(query);
    List<SettlementRecordDetailModel> models = pageInfo.getList();
    List<SettlementRecordDetailModel> countList = new ArrayList<>();
    for (SettlementRecordDetailModel model : models) {
        String number = model.getCertificateNumber();
        String name = model.getTalentPersonName();
        int flag = 0;
        for (SettlementRecordDetailModel settlementRecordDetailModel : countList) {
            String certificateNumber = settlementRecordDetailModel.getCertificateNumber();
            String talentPersonName = settlementRecordDetailModel.getTalentPersonName();
            if (number.equals(certificateNumber) && name.equals(talentPersonName)) {
                BigDecimal count = model.getSettlementAmount().add(settlementRecordDetailModel.getSettlementAmount());
                settlementRecordDetailModel.setSettlementAmount(count);
                flag = 1;
            }
        }
        //0为新增数据 1位计算金额
        if (flag == 0) {
            countList.add(model);
        }
    }
    pageInfo.setList(countList);
    return pageInfo;
}
本文参与 腾讯云自媒体分享计划,分享自作者个人站点/博客。
如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体分享计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档