Hql paging operation in hibernate

Mysql paging SQL statement: select * from table limit start index, Query Count; e.g. select * from table limit; queries the 10 statements starting from 0 in the table (mysql index starts from 0). hibernate has a very hql statement paging:

Query query = session. createQuery (hql); query. setParameter (0, userId); query. setMaxResults (maxCount); query. setFirstResult (firstResult); return query. list ();

 

Query. setMaxResults (maxCount); equivalent to the number of queries in an SQL statement query. setFirstResult (firstResult); equivalent to the start index in an SQL statement