分页算法

 int position=(currentPage-1)*pageSize+1; rs.absolute(position);

上面是用rs.absolute()方法将游标移到所需的位置。还需要判断是否后面还有数据。

int startPos = (currentPage-1)*pageSize;

String sql = "select * from login order by id asc limit " + startPos + "," + pageSize ;

直接用sql语句。