oracle 分页

public String oraclePagination(int startRow, int rowsNumber, String filter){
		String sql = "";
		
		if(rowsNumber != Constants.DEFAULT_LONG) {
				
			sql = " SELECT * FROM  "
				+ " ( SELECT A.*, ROWNUM RN " 
				+ " FROM (" + filter + ") A " 
				+ " WHERE ROWNUM <=  '" + (rowsNumber + startRow)+ "'"
				+ " )WHERE RN >=  '" + (startRow + 1) + "'" ;
		}
		return sql;
	}

    public void demo() {
        String sql = " select * from users ";
        int startRow = 0;//起始行号
        int rowsNumber = 10;//每页记录数
        sql = oraclePagination(startRow, rowsNumber, sql);
        //接下来该怎么作 就怎么作吧
    }