public String oraclePagination(int startRow, int rowsNumber, String filter){
String sql = "";
if(rowsNumber != Constants.DEFAULT_LONG) {
sql = " SELECT * FROM "
+ " ( SELECT A.*, ROWNUM RN "
+ " FROM (" + filter + ") A "
+ " WHERE ROWNUM <= '" + (rowsNumber + startRow)+ "'"
+ " )WHERE RN >= '" + (startRow + 1) + "'" ;
}
return sql;
}
public void demo() {
String sql = " select * from users ";
int startRow = 0;//起始行号
int rowsNumber = 10;//每页记录数
sql = oraclePagination(startRow, rowsNumber, sql);
//接下来该怎么作 就怎么作吧
}