github291406933
diff --git a/‎APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java‎
Lines changed: 10 additions & 3 deletions b/‎APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java‎
Lines changed: 10 additions & 3 deletions
@@ -3946,13 +3946,20 @@ public static String getSQL(AbstractSQLConfig config) throws Exception {
 						&& StringUtil.isNotEmpty(config.getGroup(),true)){
 					return explain + "SELECT count(*) FROM (SELECT " + (config.getCache() == JSONRequest.CACHE_RAM ? "SQL_NO_CACHE " : "") + column + " FROM " + getConditionString(column, tablePath, config) + ") " + config.getLimitString();
 				}
-				return explain + "SELECT * FROM (SELECT " + (config.getCache() == JSONRequest.CACHE_RAM ? "SQL_NO_CACHE " : "") + column + " FROM " + getConditionString(column, tablePath, config) + ") " + config.getLimitString();
+				String sql = "SELECT " + (config.getCache() == JSONRequest.CACHE_RAM ? "SQL_NO_CACHE " : "") + column + " FROM " + getConditionString(column, tablePath, config);
+                		return explain + config.getOraclePageSql(config, sql);
 			}
-
 			return explain + "SELECT " + (config.getCache() == JSONRequest.CACHE_RAM ? "SQL_NO_CACHE " : "") + column + " FROM " + getConditionString(column, tablePath, config) + config.getLimitString();
 		}
-	}
+	 }
 
+	 private String getOraclePageSql(AbstractSQLConfig config, String sql) {
+		int offset = getOffset(config.getPage(), config.getCount());
+		String pageSql;
+		pageSql = "SELECT * FROM (SELECT t.*,ROWNUM RN FROM (" + sql + ") t  WHERE ROWNUM <= " + (offset + count) + ") WHERE RN > " + offset;
+		return pageSql;
+	 }
+	
 	/**获取条件SQL字符串
 	 * @param column
 	 * @param table