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语句。