Oracle手动分页工具类记录

    public String getPageSql(String sqlsss,Integer page,Integer rows){
        String sql  = "select * from (select rownum as rn, t.* from ( "+sqlsss+" ) t ) where 1=1  ";

        String fy_sql = "";

        if (page == 0){
            page = 1;
        }

        if(page>0&&rows>0){
            int a = page;
            int size = rows;
            fy_sql=" and rn >"+(a-1)*size+" and rn <= "+a*size+" ";
        }

        sql = sql + fy_sql;

        return sql;
    }

    public String getCountSql(String sqlsss){
        String sql  = "select count(1) from ( "+sqlsss+"  )   ";
        return sql;
    }

记得还需要查总量返回给前台。