java分页计算公式_java将list分页

firstIndex = (currPage-1) * pageSize +1

lastIndex = currPage * pageSize

pages = total%pageSize == 0 ? total/pageSize: total/pageSize + 1 

select * from ( SELECT A.*, ROWNUM AS RN FROM (select * from table) A ) WHERE 1=1  AND RN BETWEEN start AND end order by rownum

int start = (pageNo - 1) * pageSize;
int end = pageNo  * pageSize;

SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM (select * from table) TMP WHERE ROWNUM <= end) WHERE ROW_ID > start