PageHelper 为什么我的PageSize传的数字是几 然后for循环就循环即便 在线等

Question

    @Override
    public PageInfo<FleetData> selectMarkAndSelfIdOne(CommonQo commonQo) {
       //我这里PageSize要是传5
        PageHelper.startPage(commonQo.getPageNum(),commonQo.getPageSize());

        List<FleetData> fleetData = fleetDataMapper.selectMarkAndSelfIdOne();
        //debug断点
        PageInfo<FleetData> pageInfo = new PageInfo<>(fleetData);

        List<FleetData> fleetDataList = new ArrayList<>();
        System.out.println(fleetData.size());
        //for循环就循环5
        for (FleetData fleetData2: fleetData) {
            Long userId= fleetData2.getId();//获得用户id
            //System.out.println("用户id======="+ userId );
            List<FleetBill> fleetBills = fleetBillMapper.selectBySelfId(userId);
            if (fleetBills.size()>0){
                for (FleetBill fleet:fleetBills) {
                    Long userId1= fleet.getFleetId();//获得用户id
                    //System.out.println("客户id======="+ userId1 );
                }
            }
            else {
                fleetDataList.add(fleetData2);
            }
        }
//        PageInfo<FleetData> page= new PageInfo<>(fleetDataList);
//        BeanUtils.copyProperties(pageInfo,page);
        pageInfo.setList(fleetDataList);
        return pageInfo;
    }

Answer 1

你可以这里不分页，把全部查询出来，得到最后list再分页

//PageHelper.startPage(commonQo.getPageNum(),commonQo.getPageSize());
List<FleetData> fleetData = fleetDataMapper.selectMarkAndSelfIdOne();