Java：MultiDataSource 为 SQLAuto 完善 InfluxDB 执行耗时，解决结果集只有 1 条时返回空数组

TommyLemon · TommyLemon · commit 438406fe8cc1 · 2023-03-23T20:45:43.000+08:00
diff --git a/APIJSON-Java-Server/APIJSONBoot-MultiDataSource/src/main/java/apijson/boot/DemoController.java b/APIJSON-Java-Server/APIJSONBoot-MultiDataSource/src/main/java/apijson/boot/DemoController.java
@@ -1441,12 +1441,20 @@ public String execute(@RequestBody String request, HttpSession session) {
                 long executeStartTime = System.currentTimeMillis();
 
                 if (DemoSQLConfig.DATABASE_INFLUXDB.equals(database)) {
-                   JSONObject result = executor.execute(config, false);
-                   if (isWrite) {
-                       updateCount = result == null ? 0 : result.getIntValue(JSONResponse.KEY_COUNT);
-                   } else {
-                       arr = result == null ? null : result.getJSONArray(DemoSQLExecutor.KEY_RAW_LIST);
-                   }
+                    JSONObject result = executor.execute(config, false);
+                    executeDuration = System.currentTimeMillis() - executeStartTime;
+
+                    if (isWrite) {
+                        updateCount = result == null ? 0 : result.getIntValue(JSONResponse.KEY_COUNT);
+                    } else {
+                        arr = result == null ? null : result.getJSONArray(DemoSQLExecutor.KEY_RAW_LIST);
+                        if (arr == null) {
+                            arr = new JSONArray();
+                            if (result != null) {
+                                arr.add(result);
+                            }
+                        }
+                    }
                 } else {
                     Statement statement = executor.getStatement(config, trimmedSQL);
                     if (statement instanceof PreparedStatement) {
