java oralce jdbcTemplate 分页

public  Page  queryForPage(Class type, String sql, int pageNo, int pageSize, Object... args) {
    if(pageNo < 1) {
        throw new IllegalArgumentException("指定页数必须大于0");
    }
    if(pageSize < 1) {
        throw new IllegalArgumentException("每页大小必须大于0");
    }
    log.info("sql="+sql);
    String countsql = "select count(1) from ("+sql+") tmp_count";
    log.info("countsql="+countsql);
    int totalSize = jdbcTemplate.queryForObject(countsql, args, Integer.class);
    int totalPage = (totalSize + pageSize - 1) / pageSize;
    int rownum = (pageNo - 1 ) * pageSize + 1;
    int rownumend = rownum + pageSize - 1;
    String pagesql = "SELECt * FROM (SELECt A.*, ROWNUM RN FROM (" + sql + ") A WHERe ROWNUM <= " + rownumend + ") WHERe RN >= " + rownum;
    log.info("pagesql="+pagesql);
    RowMapper rm = getTableInfoData(type).getRowMapper();
    List list = jdbcTemplate.query(pagesql, args, rm);
    Page p = new Page();
    p.setPageNo(pageNo);
    p.setPageSize(pageSize);
    p.setTotalPage(totalPage);
    p.setTotalSize(totalSize);
    p.setList(list);
    return p;
}