修复oracle分页获取时无法获取除第一页以外的数据

SingleDogL · web-flow · commit 614cc0a1c279 · 2022-04-27T10:38:09.000+08:00
原来的getLimitString的方法所生成的语句oracle并无法正确获取，因为oracle的between并不支持获取除1开始以外的数据   也就是 无法获取到除了第一页以外的数据
diff --git a/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java b/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java
@@ -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
