oracle帮助类,分页帮助类-oracle-java

/**

* 分页帮助类

*

* @author vernon.chen

*

*/

public class PaginationHepler {

/**

* 构建分页查询语句

*

* @param querySQL

*            原始查询语句

* @param startIndex

*            开始行索引号

* @param lastIndex

*            结束行索引号

* @return 分页查询语句

*/

public static StringBuffer buildPaginationSQL(String querySQL, int startIndex, int lastIndex) {

StringBuffer paginationSQL = new StringBuffer(" SELECT * FROM ( ");

paginationSQL.append(" SELECT temp.* ,ROWNUM oracle_row_num FROM ( ");

paginationSQL.append(querySQL);

paginationSQL.append(" ) temp where ROWNUM <= " + lastIndex);

paginationSQL.append(" ) WHERE　oracle_row_num > " + startIndex);

return paginationSQL;

}

/**

* 构建统计个数的查询语句

*

* @param querySQL

*            原始查询语句(不带排序)

* @return 统计个数的查询语句

*/

public static StringBuffer buildCountSQL(String querySQL) {

return new StringBuffer(" SELECT COUNT(1) FROM (" + querySQL + ")");

}

}