一、Oracle 分页查询

    /**
     * 将查询sql转换为分页sql
     * @param sql {查询sql}
     * @param offset {开始行数}
     * @param limit {截至行数}
     * @return {查询中不可以有相同的字段名}
     */
    public static String limitSql(String sql,Integer offset,Integer limit) {
        if (isEmpty(sql)) return sql;
        String limitSql = "SELECT *  FROM ( SELECT row_.*, ROWNUM rownum_ FROM ( " +
                    sql +
                " ) row_ ) WHERE rownum_ > " + (offset!=null?offset:0) +
                " AND rownum_ <= " + (limit!=null?limit:10);
        return limitSql;
    }

    @Test
    public void test_029(){
        String sql = "SELECT * FROM tableName";
        System.out.println(CPUtil.limitSql(sql, 0, 10));//调用公用静态方法分页
    }