Detailed analysis of several ways to implement pagination in Java

@Service
@Transactional
public class ImplStudentService implements StudentService {
@Resource
private  StudentDao  studentDao;
    @Override
    public List<Student>  selectAllStudent(String province, Integer offset, Integer limit) {
        return (province,offset,limit);
    }
}

select * from student where province = #{province}  limit #{offset},#{limit}

  @Override
  public List getStudents(Integer  pageNo，Integer  pageSize) throws Exception {
  // Pagination data  int[] startIdAndCount = new int[2];
  startIdAndCount[0] = pageNo * pageSize;
  startIdAndCount[1] = pageSize;
  return (startIdAndCount);
 }

@Override
public List findByHqlPage(int[] startIdAndCount) throws Exception {
	String hql = "...";
	try {
		Query query = getSession().createQuery(hql);
		// Set up paging		if (startIdAndCount != null &&  > 0) {
			int rowStartIdx = (0, startIdAndCount[0]);
			if (rowStartIdx > 0) {
				(rowStartIdx);// Set the index of the start value			}
			if ( > 1) {
				int rowCount = (0, startIdAndCount[1]);
				if (rowCount > 0) {
				(rowCount);// Set the index of the end value				}
			}
		}
		return ();
	} catch (RuntimeException re) {
		("Page query failed!", re);
		throw re;
	}
}

List<StudentEnroll> students = ();
int count = 0;
if(studentEnrolls != null && () > 0) {
	count = ();
	int fromIndex = pageNo * pageSize;
	int toIndex = (pageNo + 1) * pageSize;
	if(toIndex > count) {
		toIndex = count;
	}
	List<StudentEnroll> pageList = (fromIndex, toIndex);

<!-- /artifact//pagehelper -->
 <dependency>
      <groupId></groupId>
      <artifactId>pagehelper</artifactId>
      <version>5.1.2</version>
 </dependency>

<bean  class="">
        <!-- Relying on data sources -->
        <property name="dataSource" ref="dataSource"/>
        <!-- Register to loadmyBatisMapping files -->
        <property name="mapperLocations">
            <array>
                <value>classpath*:com/yyz/mapper/*</value>
            </array>
        </property>
        <!-- PageHelperPagination configuration -->
        <property name="plugins">
            <array>
                <bean class="">
                    <property name="properties">
                        <!--Use the following method to configure parameters，Configure one line，There will be all the parameters introduced later -->
                        <value>
                    <!--helperDialectProperties to specify which dialect to use for paging plugins。-->
                            helperDialect=mysql
                    <!--Paging rationalization parameters，Set astruehour，pageNum<=0hour会查询第一页,pageNum>pages(超过总数hour),Will query the last page。-->
                            reasonable=true
                    <!--To supportstartPage(Object params)method，This parameter has been added to configure parameter mapping，Used to take values ​​from objects based on attribute names，
                        Can be configured pageNum,pageSize,count,pageSizeZero,reasonable-->
                            params=count=countSql
                    <!--SupportedMapperInterface parameters to pass paging parameters，default valuefalse，分页插件会从查询method的参数值中，Automatically according to above params match
                     Take the value in the field set，查找到合适的值hour就会自动分页。-->
                            supportMethodsArguments=true
                    <!--default value为 false。Set as true hour，允许在运行hour根据多数据源自动识别对应方言的分页-->
                            autoRuntimeDialect=true
                        </value>
                    </property>
                </bean>
            </array>
        </property>
        <!-- Alias ​​the database entity -->
        <property name="typeAliasesPackage" value=";"/>
 </bean>

<!--Pagination plugin-->
<dependency>
    <groupId></groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>Latest version</version>
</dependency>

#bybatis paging plugin configurationpagehelper:
  helper-dialect: mysql  #database  reasonable: true
  support-methods-arguments: true
  params: count=countSql

@Override
public ResponseResult selectAllStudent(Integer pageNum, Integer pageSize) {
    Map<String,Object> map = new HashMap<>();
    (pageNum,pageSize);
    List<Student>  students = ();
    PageInfo pageInfo = new PageInfo(students);
    long total = ();
    ("result",pageInfo);
    ("count",total);
    return (map);
}

 travelDate = new (, "travelDate");
 createdTime = new (, "createdTime");
Sort sort = new Sort(travelDate, createdTime);
Pageable pageable = new PageRequest(page, pageSize, sort);
List<TravelItem> items = null;
try {
    items = (theStartDate, theEndDate, openId, pageable);
} catch (Exception e) {
    throw new DatabaseRelatedException("TravelRepository Exception");
}