int pagesize = 30;
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery(SQL);
if(rs.last()){
    int numberOfRecords = rs.getRow();
    int totalPages = numberOfRecords / pagesize + ( (numberOfRecords % pagesize)>0? 1 : 0);
    //to fetch the n-th page (n is 1-based)
    int start = pagesize * (( n > totalPages ? totalPages : n) -1 ) ;
    rs.absolute(start);
    do {
          //fetch the data one record a time
          //quit the loop if finished fetching one page of data
    } while (rs.next());
}

rs.close();
stmt.close();

floe wrote:
就像上面说的，这是一种很糟糕的办法
应该用jdbc2.0标准的resultset.relative()函数
在jdbc1中用循环next()

snowbug wrote:
I wonder if we can use the ScrollableResultSet if the underline DB supports it.

int pagesize = 30;
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery(SQL);
if(rs.last()){
    int numberOfRecords = rs.getRow();
    int totalPages = numberOfRecords / pagesize + ( (numberOfRecords % pagesize)>0? 1 : 0);
    //to fetch the n-th page (n is 1-based)
    int start = pagesize * (( n > totalPages ? totalPages : n) -1 ) ;
    rs.absolute(start);
    do {
          //fetch the data one record a time
          //quit the loop if finished fetching one page of data
    } while (rs.next());
}

rs.close();
stmt.close();