db2----分页

public StringBuilder page(int pageNumber, int pageSize, String sql)
{
int start = (pageNumber - 1) * pageSize + 1;
int end = start + pageSize - 1;
StringBuilder sb = new StringBuilder();
sb.append("select * from (select rownumber() over() as rc,TABLE_ALIAS.* from (");
sb.append(sql);
sb.append(") TABLE_ALIAS) where rc between ").append(start).append(" and ").append(end);
return sb;
}