mybatis-PageHelper分页

分页查询与数据组装

最新推荐文章于 2025-07-24 18:01:54 发布

原创最新推荐文章于 2025-07-24 18:01:54 发布 · 108 阅读

0 ·

CC 4.0 BY-SA版权

java 专栏收录该内容

10 篇文章

订阅专栏

该段代码主要实现了根据传入的分页参数查询订单列表，并进行数据的组装。首先，从OrderListVO中获取分页信息，然后使用PageHelper进行分页查询，获取到OrderListResp对象列表。接着，遍历查询结果，通过oderPayMapper查询支付详情，并将相关信息填充到OrderListResp对象中。同时，调用orderMapper查询订单详情，将结果转化为DetailListDto并添加到OrderListResp的订单明细中。最后，组装分页响应数据并返回。

@Override
public OrderPageResp queryList(OrderListVO orderListVO) {

    int pageNum = 1;
    int pageSize = 10;
    if (StringUtil.isNotEmpty(orderListVO.getPageNum())) {
        pageNum = Integer.parseInt(orderListVO.getPageNum());
    }
    if (StringUtil.isNotEmpty(orderListVO.getPageSize())) {
        pageSize = Integer.parseInt(orderListVO.getPageSize());
    }

    
    //分页
    //默认每页展示条数
    PageHelper.startPage(pageNum, pageSize, true);
    List<OrderListResp> orderListResps = orderMapper.queryList(orderListVO);

    PageInfo<OrderListResp> pageInfo = new PageInfo<>(orderListResps);
    List<OrderListResp> resultList = new ArrayList<>(pageInfo.getList());

    log.info("分页查询全部订单 | queryList | orderListResps:{} ", resultList.size());

    for (OrderListResp orderListResp : resultList) {

        List<PayDetailDto> payDetailDtos = oderPayMapper.queryTransNO(orderListResp.getOrderNo());
        if (!StringUtils.isEmpty(payDetailDtos)) {
            PayDetailDto payDetailDto = payDetailDtos.get(0);
            //拼装数据
            orderListResp.setTransNo(payDetailDto.getTransId());
            orderListResp.setPayWay(payDetailDto.getPayWay());
            orderListResp.setThirdTransNo(payDetailDto.getThirdTransNo());
        }

        Map<String, String> map = new HashMap<String, String>();
        map.put("orderId", orderListResp.getOrderNo());
        List<DetailListDto> detailList = new ArrayList<DetailListDto>();

        List<OrderDetailDto> orderDetailDtos = orderMapper.queryOrderDetail(map);
        for (OrderDetailDto orderDetailDto : orderDetailDtos) {
            DetailListDto detailListDto = new DetailListDto();
            detailListDto.setMerchName(orderDetailDto.getMerchName());
            detailListDto.setBusinessType(orderDetailDto.getBusinessType());
            detailListDto.setSalePrice(orderDetailDto.getSalePrice());
            detailListDto.setMerchSn(orderDetailDto.getMerchSn());
            detailListDto.setBeginTime(orderDetailDto.getBeginTime());
            detailListDto.setEndTime(orderDetailDto.getEndTime());
            detailListDto.setCardNo(orderDetailDto.getCardNo());
            detailListDto.setName(orderDetailDto.getName());

            detailList.add(detailListDto);

            log.info("分页查询全部订单 | queryList | detailListDto:{} 订单明细 |", detailListDto.toString());
        }
        orderListResp.setOrderDetail(detailList);
        log.info("分页查询全部订单 | queryList | orderListResp:{} 分页数据  |", orderListResp.toString());
    }

    //返回数据
    OrderPageResp orderPageResp = new OrderPageResp();
    orderPageResp.setTotal(String.valueOf(pageInfo.getTotal()));
    log.info("分页查询全部订单 | queryList | total:{} 分页数据  |", orderPageResp.getTotal());
    orderPageResp.setData(resultList);
    log.info("分页查询全部订单 | queryList | data:{} 分页数据  |", orderPageResp.getData());
    return orderPageResp;
}