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;
}