Hibernate中的Oracle分页算法

 private static String getLimitString(String sql, boolean hasOffset) {
  sql = sql.trim();
  boolean isForUpdate = false;
  if (sql.toLowerCase().endsWith(" for update")) {
   sql = sql.substring(0, sql.length() - 11);
   isForUpdate = true;
  }

  StringBuffer pagingSelect = new StringBuffer(sql.length() + 100);
  if (hasOffset) {
   pagingSelect.append("select * from ( select row_.*, rownum rownum_ from ( ");
  } else {
   pagingSelect.append("select * from ( ");
  }
  pagingSelect.append(sql);
  if (hasOffset) {
   pagingSelect.append(" ) row_ where rownum <= ?) where rownum_ > ?");
  } else {
   pagingSelect.append(" ) where rownum <= ?");
  }

  if (isForUpdate)
   pagingSelect.append(" for update");

  return pagingSelect.toString();
 }