使用PageHelper不允许出错，晓得伐？

最新推荐文章于 2022-07-14 11:03:49 发布
最新推荐文章于 2022-07-14 11:03:49 发布
阅读量208 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Mabanana/article/details/119208667
版权

很久之前出的一个问题了-使用pagehelper分页已经开启分页了，但是没有生效，一直没总结，直到今天看到一个wechat作者总结的一篇文章-在一定场景下回导致OOM，那么就来总结一下。
下方为Error Code：

/** @author sunshaocong */
@RestController
@RequestMapping("/test")
public class TestController {
    private final GpsService gpsService;
    private final UserService userService;

    public TestController(GpsService gpsService, UserService userService) {
        this.gpsService = gpsService;
        this.userService = userService;
    }

    @GetMapping("/page")
    public ResponseEntity<?> pageGps() {
        PageHelper.startPage(1, 10);
        userService.lambdaQuery().eq(User::getId, "5f09beaa2bbde45f19a0546b");
        List<Gps> gpsList = gpsService.getList(new QueryWrapper<>());
        PageInfo<Gps> gpsPages = new PageInfo<>(gpsList);
        return CommonResponse.success(gpsPages);
    }
}

正常逻辑来说，看到了开启分页并且设置页码为1页大小为10，那么在最终的gpsPages应该是返回一页，十条数据，但事实并非如此，实际的执行效果如下：

{
    "code": 200,
    "message": "ok",
    "data": {
        "total": 4743,
        "list": [
            {
                "id": "5f09beaa2bbde45f19a0546b",
                "date": "2020-12-05",
                "percentBetween85And92OfHRMaxDuration": "1:0:0",
                "percentOver85OfHRMaxDuration": "1:0:0",
                "percentBetween75And85OfHRMaxDuration": "1:0:0",
                "accelAndDecelPerMin": 1.0,
                "totalDistance": 1.0,
                "distanceOver25": 1.0,
                "playerId": "5f09beaa2bbde45f19a0546b",
                "percentOver92OfHRMaxDuration": "1:0:0",
                "totalDuration": "1:0:0",
                "distanceBetween20And25": 1.0,
                "profileMaxHR": 1,
                "accelerations": 1,
                "sessionMaxHR": 1,
                "decelerations": 1,
                "meanHeartRate": 1.0,
                "weekIndex": 49,
                "sprintCountOver20": 1,
                "sprintDistancePerMin": 1.0,
                "sprintMetersOver20": 1.0,
                "createdDate": "2020-12-05",
                "playerName": "胡嘉祺",
                "playerNameEn": "Hu Jiaqi"
            },
            {
                "id": "5f09beaa2bbde45f19a05473",
                "date": "2020-12-05",
                "percentBetween85And92OfHRMaxDuration": "0:0:2",
                "percentOver85OfHRMaxDuration": "0:0:2",
                "percentBetween75And85OfHRMaxDuration": "0:0:2",
                "accelAndDecelPerMin": 1.0,
                "totalDistance": 1.0,
                "distanceOver25": 1.0,
                "playerId": "5f09beaa2bbde45f19a05473",
                "percentOver92OfHRMaxDuration": "0:0:2",
                "totalDuration": "0:0:2",
                "distanceBetween20And25": 1.0,
                "profileMaxHR": 1,
                "accelerations": 1,
                "sessionMaxHR": 1,
                "decelerations": 1,
                "meanHeartRate": 1.0,
                "weekIndex": 49,
                "sprintCountOver20": 1,
                "sprintDistancePerMin": 11.0,
                "sprintMetersOver20": 1.0,
                "createdDate": "2020-12-05",
                "playerName": "孙胥卿",
                "playerNameEn": "Sun Yuqing"
            },
            {
                "id": "5f09beaa2bbde45f19a054cf",
                "date": "2020-12-05",
                "percentBetween85And92OfHRMaxDuration": "0:0:2",
                "percentOver85OfHRMaxDuration": "0:0:2",
                "percentBetween75And85OfHRMaxDuration": "0:0:2",
                "accelAndDecelPerMin": 1.0,
                "totalDistance": 1.0,
                "distanceOver25": 1.0,
                "playerId": "5f09beaa2bbde45f19a054cf",
                "percentOver92OfHRMaxDuration": "0:0:2",
                "totalDuration": "0:0:2",
                "distanceBetween20And25": 1.0,
                "profileMaxHR": 11,
                "accelerations": 1,
                "sessionMaxHR": 1,
                "decelerations": 1,
                "meanHeartRate": 1.0,
                "weekIndex": 49,
                "sprintCountOver20": 1,
                "sprintDistancePerMin": 1.0,
                "sprintMetersOver20": 1.0,
                "createdDate": "2020-12-05",
                "playerName": "马昆越",
                "playerNameEn": "Ma Kunyue"
            },
            {
                "id": "5f09beaa2bbde45f19a054d4",
                "date": "2020-12-01",
                "percentBetween85And92OfHRMaxDuration": "12:00:00",
                "percentOver85OfHRMaxDuration": "12:00:00",
                "percentBetween75And85OfHRMaxDuration": "12:00:00",
                "accelAndDecelPerMin": 1.0,
                "totalDistance": 1.0,
                "distanceOver25": 1.0,
                "playerId": "5f09beaa2bbde45f19a054d4",
                "percentOver92OfHRMaxDuration": "12:00:00",
                "totalDuration": "12:00:00",
                "distanceBetween20And25": 11.0,
                "profileMaxHR": 1,
                "accelerations": 1,
                "sessionMaxHR": 1,
                "decelerations": 1,
                "meanHeartRate": 1.0,
                "weekIndex": 49,
                "sprintCountOver20": 1,
                "sprintDistancePerMin": 1.0,
                "sprintMetersOver20": 1.0,
                "createdDate": "2020-12-01",
                "playerName": "王刚",
                "playerNameEn": "Wang Gang"
            },
            {
                "id": "5f09beaa2bbde45f19a054d8",
                "date": "2020-12-05",
                "percentBetween85And92OfHRMaxDuration": "0:0:6",
                "percentOver85OfHRMaxDuration": "0:0:6",
                "percentBetween75And85OfHRMaxDuration": "0:0:6",
                "accelAndDecelPerMin": 1.0,
                "totalDistance": 1.0,
                "distanceOver25": 1.0,
                "playerId": "5f09beaa2bbde45f19a054d8",
                "percentOver92OfHRMaxDuration": "0:0:6",
                "totalDuration": "0:0:6",
                "distanceBetween20And25": 1.0,
                "profileMaxHR": 1,
                "accelerations": 1,
                "sessionMaxHR": 1,
                "decelerations": 1,
                "meanHeartRate": 1.0,
                "weekIndex": 49,
                "sprintCountOver20": 1,
                "sprintDistancePerMin": 1.0,
                "sprintMetersOver20": 1.0,
                "createdDate": "2020-12-05",
                "playerName": "李磊",
                "playerNameEn": "Li Lei"
            },
            {
                "id": "5f09beaa2bbde45f19a054d9",
                "date": "2020-12-01",
                "percentBetween85And92OfHRMaxDuration": "Yu",
                "percentOver85OfHRMaxDuration": "Yyyuubbnn",
                "percentBetween75And85OfHRMaxDuration": "Yuy",
                "accelAndDecelPerMin": 22.0,
                "totalDistance": 12.0,
                "distanceOver25": 22.0,
                "playerId": "5f09beaa2bbde45f19a054d9",
                "percentOver92OfHRMaxDuration": "Yu",
                "totalDuration": "Yu",
                "distanceBetween20And25": 22.0,
                "profileMaxHR": 22222,
                "accelerations": 11,
                "sessionMaxHR": 222222222,
                "decelerations": 22,
                "meanHeartRate": 2222222222222.22,
                "weekIndex": 49,
                "sprintCountOver20": 11,
                "sprintDistancePerMin": 11.0,
                "sprintMetersOver20": 11.0,
                "createdDate": "2020-12-04",
                "playerName": "于洋",
                "playerNameEn": "Yu Yang"
            },
            {
                "id": "5f09beaa2bbde45f19a054ec",
                "date": "2020-12-02",
                "percentBetween85And92OfHRMaxDuration": "1:0:0",
                "percentOver85OfHRMaxDuration": "1:0:0",
                "percentBetween75And85OfHRMaxDuration": "1:0:0",
                "accelAndDecelPerMin": 100.0,
                "totalDistance": 100.0,
                "distanceOver25": 100.0,
                "playerId": "5f09beaa2bbde45f19a054ec",
                "percentOver92OfHRMaxDuration": "1:0:0",
                "totalDuration": "1:0:0",
                "distanceBetween20And25": 100.0,
                "profileMaxHR": 100,
                "accelerations": 100,
                "sessionMaxHR": 100,
                "decelerations": 100,
                "meanHeartRate": 100.0,
                "weekIndex": 49,
                "sprintCountOver20": 100,
                "sprintDistancePerMin": 100.0,
                "sprintMetersOver20": 100.0,
                "createdDate": "2020-12-02",
                "playerName": "雷腾龙",
                "playerNameEn": "Lei Tenglong"
            },
            {
                "id": "5f09bee42bbde45f19a05f3e",
                "date": "2020-04-22",
                "percentBetween85And92OfHRMaxDuration": "",
                "percentOver85OfHRMaxDuration": "",
                "percentBetween75And85OfHRMaxDuration": "",
                "accelAndDecelPerMin": 0.05899,
                "totalDistance": 5013.41748,
                "distanceOver25": 0.0,
                "playerId": "5f09beaa2bbde45f19a05482",
                "percentOver92OfHRMaxDuration": "",
                "totalDuration": "5:22:05",
                "distanceBetween20And25": 0.56,
                "profileMaxHR": 0,
                "accelerations": 11,
                "sessionMaxHR": 0,
                "decelerations": 8,
                "seasonId": "5f09beaf2bbde45f19a05805",
                "weekIndex": 17,
                "sprintCountOver20": 0,
                "sprintDistancePerMin": 0.00174,
                "sprintMetersOver20": 0.56,
                "createdDate": "2020-04-22",
                "playerName": "陈怀远",
                "playerNameEn": "Chen Huaiyuan"
            },
            {
                "id": "5f09bee42bbde45f19a05f3f",
                "date": "2020-04-22",
                "percentBetween85And92OfHRMaxDuration": "",
                "percentOver85OfHRMaxDuration": "",
                "percentBetween75And85OfHRMaxDuration": "",
                "accelAndDecelPerMin": 0.04968,
                "totalDistance": 4696.04004,
                "distanceOver25": 0.0,
                "playerId": "5f09beaa2bbde45f19a0547f",
                "percentOver92OfHRMaxDuration": "",
                "totalDuration": "5:22:05",
                "distanceBetween20And25": 2.71,
                "profileMaxHR": 0,
                "accelerations": 11,
                "sessionMaxHR": 0,
                "decelerations": 5,
                "seasonId": "5f09beaf2bbde45f19a05805",
                "weekIndex": 17,
                "sprintCountOver20": 0,
                "sprintDistancePerMin": 0.00841,
                "sprintMetersOver20": 2.71,
                "createdDate": "2020-04-22",
                "playerName": "和玺",
                "playerNameEn": "He Xi"
            },
            {
                "id": "5f09bee42bbde45f19a05f40",
                "date": "2020-04-22",
                "percentBetween85And92OfHRMaxDuration": "",
                "percentOver85OfHRMaxDuration": "",
                "percentBetween75And85OfHRMaxDuration": "",
                "accelAndDecelPerMin": 0.03838,
                "totalDistance": 4701.95801,
                "distanceOver25": 0.0,
                "playerId": "5f09beaa2bbde45f19a05485",
                "percentOver92OfHRMaxDuration": "",
                "totalDuration": "6:04:47",
                "distanceBetween20And25": 9.32,
                "profileMaxHR": 0,
                "accelerations": 10,
                "sessionMaxHR": 0,
                "decelerations": 4,
                "seasonId": "5f09beaf2bbde45f19a05805",
                "weekIndex": 17,
                "sprintCountOver20": 1,
                "sprintDistancePerMin": 0.02555,
                "sprintMetersOver20": 9.32,
                "createdDate": "2020-04-22",
                "playerName": "和晓强",
                "playerNameEn": "He Xiaoqiang"
            },
            ....
        ],
        "pageNum": 1,
        "pageSize": 10,
        "size": 10,
        "startRow": 1,
        "endRow": 10,
        "pages": 475,
        "prePage": 0,
        "nextPage": 2,
        "isFirstPage": true,
        "isLastPage": false,
        "hasPreviousPage": false,
        "hasNextPage": true,
        "navigatePages": 8,
        "navigatepageNums": [
            1,
            2,
            3,
            4,
            5,
            6,
            7,
            8
        ],
        "navigateFirstPage": 1,
        "navigateLastPage": 8
    }
}

哈哈哈，数据量太大，页面先撑不住了，直接OOM了。所以证实那位wechat作者的文章，真的会OOM。
在这里插入图片描述
既然出现了问题，就需要知道为什么会出现这样的问题，以及这样的问题应该如何解决。
Point 1：-Why
在 PageHelper 使用文档（https://pagehelper.github.io/faq/）中第一句就阐述了：
在这里插入图片描述
只有紧跟在 PageHelper.startPage 方法后的第一个 Mybatis 的查询（Select）方法会被分页。请注意关键词紧跟。为什么要紧跟呢？因为 PageHelper 的分页原理使用了 ThreadLocal，他的分页参数和线程是绑定在一起的，当我们执行PageHelper.startPage()语句时，他会将分页参数绑定到ThreadLocal中：

/**
 * 开始分页
 *
 * @param pageNum      页码
 * @param pageSize     每页显示数量
 * @param count        是否进行count查询
 * @param reasonable   分页合理化,null时用默认配置
 * @param pageSizeZero true且pageSize=0时返回全部结果，false时分页,null时用默认配置
 */
public static <E> Page<E> startPage(int pageNum, int pageSize, boolean count, Boolean reasonable, Boolean pageSizeZero) {
    Page<E> page = new Page<E>(pageNum, pageSize, count);
    page.setReasonable(reasonable);
    page.setPageSizeZero(pageSizeZero);
    //当已经执行过orderBy的时候
    Page<E> oldPage = getLocalPage();
    if (oldPage != null && oldPage.isOrderByOnly()) {
        page.setOrderBy(oldPage.getOrderBy());
    }
    setLocalPage(page);
    return page;
}
//--------------------------------------------------
protected static final ThreadLocal<Page> LOCAL_PAGE = new ThreadLocal<Page>();
protected static boolean DEFAULT_COUNT = true;

/**
 * 设置 Page 参数
 *
 * @param page
 */
protected static void setLocalPage(Page page) {
    LOCAL_PAGE.set(page);
}
//--------------------------------------------------
// 查询语句结束之后执行
@Override
public void afterAll() {
    //这个方法即使不分页也会被执行，所以要判断 null
    AbstractHelperDialect delegate = autoDialect.getDelegate();
    if (delegate != null) {
        delegate.afterAll();
        autoDialect.clearDelegate();
    }
    clearPage(); // 注意这个方法，是个重点
}
//--------------------------------------------------
/**
 * 移除本地变量
 */
public static void clearPage() {
    LOCAL_PAGE.remove(); // 分页被移除，也就是之后的查询操作便使用不了本地变量
}

Point 2：-Deal it

治标不治本：移动PageHelper.startPage() 方法位置，让真正的查询语句紧挨着它。这种方案不治本的原因在于，如果又有小伙伴不知道这个坑，有可能又会踩。
治标治本：使用 Function Lamdba 表达式。

Method 1

@GetMapping("/page")
public ResponseEntity<?> pageGps() {
    userService.lambdaQuery().eq(User::getId, "5f09beaa2bbde45f19a0546b").one();
    PageHelper.startPage(1, 10);
    List<Gps> gpsList = gpsService.getList(new QueryWrapper<>());
    PageInfo<Gps> gpsPages = new PageInfo<>(gpsList);
    return CommonResponse.success(gpsPages);
}

Method 2

@Builder
public class PageHelperTool<P, R> {
    private final Function<P, PageInfo<R>> pageFunction;
    public PageInfo<R> getPageInfo(P request) {
        PageHelper.startPage(((QueryDTO)request).getPageNumber(),((QueryDTO)request).getPageSize());
        return pageFunction.apply(request);
    }
}

/**
 * @author sunshaocong
 */
@Data
public class QueryDTO {
    private Integer pageNumber;
    private Integer pageSize;
    private QueryWrapper<Gps> query;
}

public PageInfo getList(QueryDTO queryDTO) {
    PageHelper.startPage(queryDTO.getPageNumber(), queryDTO.getPageSize());
    List<Gps> gpsList = gpsMapper.selectList(queryDTO.getQuery());
    return new PageInfo<>(gpsList);
}

@GetMapping("/page")
public ResponseEntity<?> pageGps(QueryDTO queryDTO) {
    PageHelperTool<QueryDTO, Gps> pageHelperTool =
            PageHelperTool.<QueryDTO, Gps>builder().pageFunction(gpsService::getList).build();
    userService.lambdaQuery().eq(User::getId, "5f09beaa2bbde45f19a0546b").one();
    queryDTO.setQuery(new QueryWrapper<>());
    PageInfo<Gps> gpsPages = pageHelperTool.getPageInfo(queryDTO);
    return CommonResponse.success(gpsPages);
}

注意，上边的QueryDTO实体可以进行复用，里边设置多个属性即可。
Result：

{
    "code": 200,
    "message": "ok",
    "data": {
        "total": 4743,
        "list": [
            {
                "id": "5f09beaa2bbde45f19a0546b",
                "date": "2020-12-05",
                "percentBetween85And92OfHRMaxDuration": "1:0:0",
                "percentOver85OfHRMaxDuration": "1:0:0",
                "percentBetween75And85OfHRMaxDuration": "1:0:0",
                "accelAndDecelPerMin": 1.0,
                "totalDistance": 1.0,
                "distanceOver25": 1.0,
                "playerId": "5f09beaa2bbde45f19a0546b",
                "percentOver92OfHRMaxDuration": "1:0:0",
                "totalDuration": "1:0:0",
                "distanceBetween20And25": 1.0,
                "profileMaxHR": 1,
                "accelerations": 1,
                "sessionMaxHR": 1,
                "decelerations": 1,
                "meanHeartRate": 1.0,
                "weekIndex": 49,
                "sprintCountOver20": 1,
                "sprintDistancePerMin": 1.0,
                "sprintMetersOver20": 1.0,
                "createdDate": "2020-12-05",
                "playerName": "胡嘉祺",
                "playerNameEn": "Hu Jiaqi"
            },
            {
                "id": "5f09beaa2bbde45f19a05473",
                "date": "2020-12-05",
                "percentBetween85And92OfHRMaxDuration": "0:0:2",
                "percentOver85OfHRMaxDuration": "0:0:2",
                "percentBetween75And85OfHRMaxDuration": "0:0:2",
                "accelAndDecelPerMin": 1.0,
                "totalDistance": 1.0,
                "distanceOver25": 1.0,
                "playerId": "5f09beaa2bbde45f19a05473",
                "percentOver92OfHRMaxDuration": "0:0:2",
                "totalDuration": "0:0:2",
                "distanceBetween20And25": 1.0,
                "profileMaxHR": 1,
                "accelerations": 1,
                "sessionMaxHR": 1,
                "decelerations": 1,
                "meanHeartRate": 1.0,
                "weekIndex": 49,
                "sprintCountOver20": 1,
                "sprintDistancePerMin": 11.0,
                "sprintMetersOver20": 1.0,
                "createdDate": "2020-12-05",
                "playerName": "孙胥卿",
                "playerNameEn": "Sun Yuqing"
            },
            {
                "id": "5f09beaa2bbde45f19a054cf",
                "date": "2020-12-05",
                "percentBetween85And92OfHRMaxDuration": "0:0:2",
                "percentOver85OfHRMaxDuration": "0:0:2",
                "percentBetween75And85OfHRMaxDuration": "0:0:2",
                "accelAndDecelPerMin": 1.0,
                "totalDistance": 1.0,
                "distanceOver25": 1.0,
                "playerId": "5f09beaa2bbde45f19a054cf",
                "percentOver92OfHRMaxDuration": "0:0:2",
                "totalDuration": "0:0:2",
                "distanceBetween20And25": 1.0,
                "profileMaxHR": 11,
                "accelerations": 1,
                "sessionMaxHR": 1,
                "decelerations": 1,
                "meanHeartRate": 1.0,
                "weekIndex": 49,
                "sprintCountOver20": 1,
                "sprintDistancePerMin": 1.0,
                "sprintMetersOver20": 1.0,
                "createdDate": "2020-12-05",
                "playerName": "马昆越",
                "playerNameEn": "Ma Kunyue"
            },
            {
                "id": "5f09beaa2bbde45f19a054d4",
                "date": "2020-12-01",
                "percentBetween85And92OfHRMaxDuration": "12:00:00",
                "percentOver85OfHRMaxDuration": "12:00:00",
                "percentBetween75And85OfHRMaxDuration": "12:00:00",
                "accelAndDecelPerMin": 1.0,
                "totalDistance": 1.0,
                "distanceOver25": 1.0,
                "playerId": "5f09beaa2bbde45f19a054d4",
                "percentOver92OfHRMaxDuration": "12:00:00",
                "totalDuration": "12:00:00",
                "distanceBetween20And25": 11.0,
                "profileMaxHR": 1,
                "accelerations": 1,
                "sessionMaxHR": 1,
                "decelerations": 1,
                "meanHeartRate": 1.0,
                "weekIndex": 49,
                "sprintCountOver20": 1,
                "sprintDistancePerMin": 1.0,
                "sprintMetersOver20": 1.0,
                "createdDate": "2020-12-01",
                "playerName": "王刚",
                "playerNameEn": "Wang Gang"
            },
            {
                "id": "5f09beaa2bbde45f19a054d8",
                "date": "2020-12-05",
                "percentBetween85And92OfHRMaxDuration": "0:0:6",
                "percentOver85OfHRMaxDuration": "0:0:6",
                "percentBetween75And85OfHRMaxDuration": "0:0:6",
                "accelAndDecelPerMin": 1.0,
                "totalDistance": 1.0,
                "distanceOver25": 1.0,
                "playerId": "5f09beaa2bbde45f19a054d8",
                "percentOver92OfHRMaxDuration": "0:0:6",
                "totalDuration": "0:0:6",
                "distanceBetween20And25": 1.0,
                "profileMaxHR": 1,
                "accelerations": 1,
                "sessionMaxHR": 1,
                "decelerations": 1,
                "meanHeartRate": 1.0,
                "weekIndex": 49,
                "sprintCountOver20": 1,
                "sprintDistancePerMin": 1.0,
                "sprintMetersOver20": 1.0,
                "createdDate": "2020-12-05",
                "playerName": "李磊",
                "playerNameEn": "Li Lei"
            },
            {
                "id": "5f09beaa2bbde45f19a054d9",
                "date": "2020-12-01",
                "percentBetween85And92OfHRMaxDuration": "Yu",
                "percentOver85OfHRMaxDuration": "Yyyuubbnn",
                "percentBetween75And85OfHRMaxDuration": "Yuy",
                "accelAndDecelPerMin": 22.0,
                "totalDistance": 12.0,
                "distanceOver25": 22.0,
                "playerId": "5f09beaa2bbde45f19a054d9",
                "percentOver92OfHRMaxDuration": "Yu",
                "totalDuration": "Yu",
                "distanceBetween20And25": 22.0,
                "profileMaxHR": 22222,
                "accelerations": 11,
                "sessionMaxHR": 222222222,
                "decelerations": 22,
                "meanHeartRate": 2222222222222.22,
                "weekIndex": 49,
                "sprintCountOver20": 11,
                "sprintDistancePerMin": 11.0,
                "sprintMetersOver20": 11.0,
                "createdDate": "2020-12-04",
                "playerName": "于洋",
                "playerNameEn": "Yu Yang"
            },
            {
                "id": "5f09beaa2bbde45f19a054ec",
                "date": "2020-12-02",
                "percentBetween85And92OfHRMaxDuration": "1:0:0",
                "percentOver85OfHRMaxDuration": "1:0:0",
                "percentBetween75And85OfHRMaxDuration": "1:0:0",
                "accelAndDecelPerMin": 100.0,
                "totalDistance": 100.0,
                "distanceOver25": 100.0,
                "playerId": "5f09beaa2bbde45f19a054ec",
                "percentOver92OfHRMaxDuration": "1:0:0",
                "totalDuration": "1:0:0",
                "distanceBetween20And25": 100.0,
                "profileMaxHR": 100,
                "accelerations": 100,
                "sessionMaxHR": 100,
                "decelerations": 100,
                "meanHeartRate": 100.0,
                "weekIndex": 49,
                "sprintCountOver20": 100,
                "sprintDistancePerMin": 100.0,
                "sprintMetersOver20": 100.0,
                "createdDate": "2020-12-02",
                "playerName": "雷腾龙",
                "playerNameEn": "Lei Tenglong"
            },
            {
                "id": "5f09bee42bbde45f19a05f3e",
                "date": "2020-04-22",
                "percentBetween85And92OfHRMaxDuration": "",
                "percentOver85OfHRMaxDuration": "",
                "percentBetween75And85OfHRMaxDuration": "",
                "accelAndDecelPerMin": 0.05899,
                "totalDistance": 5013.41748,
                "distanceOver25": 0.0,
                "playerId": "5f09beaa2bbde45f19a05482",
                "percentOver92OfHRMaxDuration": "",
                "totalDuration": "5:22:05",
                "distanceBetween20And25": 0.56,
                "profileMaxHR": 0,
                "accelerations": 11,
                "sessionMaxHR": 0,
                "decelerations": 8,
                "seasonId": "5f09beaf2bbde45f19a05805",
                "weekIndex": 17,
                "sprintCountOver20": 0,
                "sprintDistancePerMin": 0.00174,
                "sprintMetersOver20": 0.56,
                "createdDate": "2020-04-22",
                "playerName": "陈怀远",
                "playerNameEn": "Chen Huaiyuan"
            },
            {
                "id": "5f09bee42bbde45f19a05f3f",
                "date": "2020-04-22",
                "percentBetween85And92OfHRMaxDuration": "",
                "percentOver85OfHRMaxDuration": "",
                "percentBetween75And85OfHRMaxDuration": "",
                "accelAndDecelPerMin": 0.04968,
                "totalDistance": 4696.04004,
                "distanceOver25": 0.0,
                "playerId": "5f09beaa2bbde45f19a0547f",
                "percentOver92OfHRMaxDuration": "",
                "totalDuration": "5:22:05",
                "distanceBetween20And25": 2.71,
                "profileMaxHR": 0,
                "accelerations": 11,
                "sessionMaxHR": 0,
                "decelerations": 5,
                "seasonId": "5f09beaf2bbde45f19a05805",
                "weekIndex": 17,
                "sprintCountOver20": 0,
                "sprintDistancePerMin": 0.00841,
                "sprintMetersOver20": 2.71,
                "createdDate": "2020-04-22",
                "playerName": "和玺",
                "playerNameEn": "He Xi"
            },
            {
                "id": "5f09bee42bbde45f19a05f40",
                "date": "2020-04-22",
                "percentBetween85And92OfHRMaxDuration": "",
                "percentOver85OfHRMaxDuration": "",
                "percentBetween75And85OfHRMaxDuration": "",
                "accelAndDecelPerMin": 0.03838,
                "totalDistance": 4701.95801,
                "distanceOver25": 0.0,
                "playerId": "5f09beaa2bbde45f19a05485",
                "percentOver92OfHRMaxDuration": "",
                "totalDuration": "6:04:47",
                "distanceBetween20And25": 9.32,
                "profileMaxHR": 0,
                "accelerations": 10,
                "sessionMaxHR": 0,
                "decelerations": 4,
                "seasonId": "5f09beaf2bbde45f19a05805",
                "weekIndex": 17,
                "sprintCountOver20": 1,
                "sprintDistancePerMin": 0.02555,
                "sprintMetersOver20": 9.32,
                "createdDate": "2020-04-22",
                "playerName": "和晓强",
                "playerNameEn": "He Xiaoqiang"
            }
        ],
        "pageNum": 1,
        "pageSize": 10,
        "size": 10,
        "startRow": 1,
        "endRow": 10,
        "pages": 475,
        "prePage": 0,
        "nextPage": 2,
        "isFirstPage": true,
        "isLastPage": false,
        "hasPreviousPage": false,
        "hasNextPage": true,
        "navigatePages": 8,
        "navigatepageNums": [
            1,
            2,
            3,
            4,
            5,
            6,
            7,
            8
        ],
        "navigateFirstPage": 1,
        "navigateLastPage": 8
    }
}

不多不少，刚刚好10条。
这样就可以彻底解决因误用 PageHelper 导致分页失效的问题了。在使用别人封装好的框架时注意认真看文档！！！

new_repo
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 1
    评论
PageHelper中要获取的数据过多，进行封装做成一个工具类
weixin_50965314的博客
05-10 306
/** * 分页工具类 */ @Data public class PageResult<T> implements Serializable { /** * 总记录数 */ private Long totalRows; /** * 总页数 */ private Integer totalPages; /** * 当前第几页 */ private Integer pageNum;
易卖网需求分析
11-20
此外，系统还涉及到了Servlet的使用，Servlet负责处理用户请求并进行页面跳转。例如，在用户登录后，根据`user.getType()`的值判断用户类型并跳转至相应页面。同时，系统提供了多种接口方法，如添加和删除用户、商品...
Caused by: java.lang.ClassCastException: class com.github.pagehelper.PageHelper cannot be cast to cl
sm923的博客
07-13 978
笔者在初学Mybatis使用pageHelp遇到了坑，为了避免其他初学者踩坑，第一时间将解决办法呈现给大家。 报错前的sqlMapConfig.xml文件配置如下，此配置适用于mysql 5.0以及5.0以下版本的配置： <plugins> <plugin interceptor="com.github.pagehelper.PageHelper"> <!--设置数据局库的类型，用的是mysql就设置为mysql-->
一个关于使用pagehelper的bug ClassCastException
vv新世纪的博客
01-24 469
一个关于使用pagehelper的bug 报错: 严重: Servlet.service() for servlet [springmvc] in context with path [] threw exception [Request processing failed; nested exception is java.lang.ClassCastException: java.util.A...
com.github.pagehelper.PageHelper cannot be cast to org.apache.ibatis.plugin.Interceptor
weixin_45699786的博客
07-14 924
PageHelper cannot be cast to org.apache.ibatis.plugin.Interceptor
Mybatis3.4.x技术内幕（二十）：PageHelper分页插件源码及原理剖析
weixin_33940102的博客
09-10 1896
2019独角兽企业重金招聘Python工程师标准>>> ...
为什么哈希存取比较快？使用它需要付出什么代价
12-31
我们在享受高性能的同时，需要付出什么代价(这几天看红顶商人胡雪岩，经典台词：在你享受这之前，必须受别人吃不了的苦，忍受别人受不了的屈辱)，那么使用Hashtable是否就是一桩无本万利的买卖呢？就此疑问，做以下...
不晓得怎么上传不上来，易语言仿qq
06-07
关于仿腾讯qq的易语言源码，涉及到正则表达式等多方面内容
2021年事业单位工资标准出炉，不晓得要亏大了！.docx
03-11
2021年事业单位工资标准出炉，不晓得要亏大了！.docx
消防学问我晓得.docx
11-25
如果条件允许，可以自制救生绳索，但不到万不得已不要跳楼。在窗口呼救，以增加获救机会。 消防不仅是理论知识，更需要实践操作和应对紧急情况的能力。通过这次班会，同学们不仅学习了消防知识，还通过消防小品等...
浅析pagehelper分页原理
热门推荐
王大锤的博客
04-02 10万+
写的第一篇文章，不足之处，请多提宝贵意见，谢谢。之前项目一直使用的是普元框架，最近公司项目搭建了新框架，主要是由公司的大佬搭建的，以springboot为基础。为了多学习点东西，我也模仿他搭了一套自己的框架，但是在完成分页功能的时候，确遇到了问题。框架的分页组件使用的是pagehelper，对其我也是早有耳闻，但是也是第一次接触（ps:工作1年，一直使用的是普元封装好的前端框架）。要是用pageh...
大数据量下 PageHelper 分页查询性能问题的解决办法
公众号-老炮说Java
02-09 1102
点击上方蓝色字体，选择“标星公众号”优质文章，第一时间送达关注公众号后台回复pay或mall获取实战项目资料+视频作者：岁月安然blog.csdn.net/baidu_38083619/a...
pagehelper之百万级数据查询优化
weixin_42330218的博客
08-27 3184
pagehelper之百万级数据查询优化 用过pagehelper的人都知道，那是真香呀，但是当数据量级别越来越大的时候呢？几万，几十万，都没啥感觉，但是当上了百万，千万之后呢？它似乎就不香了呀。 pagehelper相关的解析，浅谈什么的这儿就不说了，网上一搜一大把。这儿主要来解决一下百万级别以上的pagehelper的慢查询问题。 pagehelper用过的都知道，每次有总页数，总条数，做分页真的是舒服呀。但是了解他原理的时候就知道，这些数据是怎么来的。然后数据库级别达到了百万级以上后，count
PageHelper分页插件在数据量较大的时候的问题
ZCR的博客
01-03 2046
项目中遇到一个问题，在做查询时明明查询返回的条数不多但是查询速度慢的出奇的可怕！！！ 数据库中数据量总数为 之前在数据库为mysql时遇到同样的问题，是我mysql数据库数据引擎是 InnoDB （插入删除快） 应该使用MyIsam ：查询快（ 不支持事务，不支持外键约束，不支持行级锁，操作时需要锁定整张表，不过会保存表的行数，所以当执行select count(*) from table...
PageHelper分页插件的一些坑
demon_2018的博客
05-04 1万+
分页插件的一些坑： 1)、PageHelper.startPage(pageNum, pageSize）的位置： PageHelper.startPage(pageNum, pageSize) 只对该语句以后的第一个查询语句得到的数据进行分页！！！ 譬如：下面这段代码本来想根据 userName 以及 userCompany 进行条件查询的，但是 startPage() 后面紧跟的不是 userM...
PageHelper 导致 SQL莫名分页的问题处理
ACoder_Forever
05-21 2515
PageHelper 导致 SQL莫名分页的问题处理 项目上使用PageHelper插件做分页功能，但是最近系统偶尔报服务器异常。 经过排查原因是存在一条SQL执行出错 SELECT * FROM ( SELECT TMP_PAGE.*, ROWNUM ROW_ID FROM ( select TEST_SEQ.nextval from dual ) TMP_PAGE) WHERE ROW_ID <= ? AND ROW_ID > ? 经过排查，该SQL的方法不可能存在分页的逻辑。
工具类PageHelperTool，PageInfo，实现对现有List数组手动分页；解决PageHelper不能对已有List数组分页
少年一贯快马扬帆，道阻且长不转弯。要盛大，要绚烂，要哗然，要用理想的泰坦尼克，去撞现实冰川。要当烧赤壁的风，而非借箭草船，要为了一片海，就肯翻万山。
03-02 1146
方法调用 //需要处理的数据 List list = new ArrayList(); //当前页 int currentPage = 2; //当前条目数 int pageSize = 10; PageInfo pageInfo = PageHelperTool.resultPageInfo(currentPage,pageSize,list); 工具类 import com.github.pagehelper.PageInfo; import java.util.List; /** * @Cl
你晓得咋个往.ts里面添加字体样式不
最新发布
06-06
如果你想在 TypeScript 文件中添加字体样式，可以通过在 HTML 或 CSS 文件中定义样式，然后在 TypeScript 中...如果你是在 Node.js 环境中使用 TypeScript，则需要使用 Node.js 的内置模块或第三方库来添加字体样式。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

new_repo

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值