最新+最简单Oracle分页查询法

/**
	 * Oracle 分页sql语句生成方法
	 * @param sql sql语句
	 * @param pageIndex 页下标
	 * @param pageSize 页面大小
	 * @return
	 */
   public  static String createOraclePagingSql(String sql, int pageIndex, int pageSize){
	   int m = (pageIndex-1) * pageSize; 
       int n = m + pageSize; 
	   StringBuffer pagingSelect = new StringBuffer(100); 
	   pagingSelect.append("select * from ( select row_.*, rownum rownum_ from ( ")
	   .append(sql) 
	   .append(" ) row_ where rownum <=")
	   .append(n)
	   .append(") where rownum_ >")
	   .append(n); 	   
	   return pagingSelect.toString(); 	
   }