Integer start = (pageNum - 1) * pageSize;
    Integer end = pageSize;
    List<entity> entityList;
    
    //調用mapper查詢數據庫
    entityList = entityPOMapper.query(start, end);

    SimplePageInfo simplePageInfo = SimplePageInfo.of(entityList );
    simplePageInfo.setNumber(pageNum);
    simplePageInfo.setPageSize(pageSize);

// 查詢出來數據等于size,總數據量加一，頁數加一
    if (entityList .size() == pageSize) {
      Integer totalElements = (pageNum * pageSize) + 1;
      Integer pages = pageNum + 1;
      simplePageInfo.setTotalElements(totalElements);
      simplePageInfo.setPages(pages);
    } else {
    //數據不夠size
      Integer totalElements = ((pageNum - 1) * pageSize + entityList .size());
      Integer pages = pageNum;
      simplePageInfo.setTotalElements(totalElements);
      simplePageInfo.setPages(pages);
    }
    return simplePageInfo;
}

<select .............>
    select..
    from ...
    where ...
    LIMIT #{start}, #{end}
  </select>