From 2303ba3d0bcc38607dd01329a12e4f4b74b444c0 Mon Sep 17 00:00:00 2001
From: xingjinshuang <xingjs@qq.com>
Date: 星期五, 27 十二月 2024 17:49:53 +0800
Subject: [PATCH] @xingjs@20241227@优化解决获取建筑物图层方法

---
 src/main/java/com/se/simu/utils/CsvToSQLiteUtils.java |   46 ++++++++++++++++++++++++++++++++--------------
 1 files changed, 32 insertions(+), 14 deletions(-)

diff --git a/src/main/java/com/se/simu/utils/CsvToSQLiteUtils.java b/src/main/java/com/se/simu/utils/CsvToSQLiteUtils.java
index 7dcf5fa..165bb0d 100644
--- a/src/main/java/com/se/simu/utils/CsvToSQLiteUtils.java
+++ b/src/main/java/com/se/simu/utils/CsvToSQLiteUtils.java
@@ -230,24 +230,18 @@
         }
     }
 
+    /**
+     * 鑾峰彇鎬昏
+     *
+     * @param tableName 琛ㄥ悕绉�
+     * @return {@link Double}
+     */
     public static Double getTotal(String tableName) {
         // 1. 鍒涘缓SQLite鏁版嵁搴撹繛鎺�
         try (Connection conn = DriverManager.getConnection("jdbc:sqlite:rainfall.db")) {
             if (conn != null) {
                 // 2. 鎵цSQL鏌ヨ
-                String queryDataSql = "SELECT sum(rainfall_difference) AS total" +
-                        "FROM " +
-                        "    (SELECT ABS( " +
-                        "        (SELECT rainfall" +
-                        "        FROM " + tableName +
-                        "        WHERE station_name = s.station_name" +
-                        "        ORDER BY  datetime ASC LIMIT 1) - " +
-                        "            (SELECT rainfall" +
-                        "            FROM " + tableName +
-                        "            WHERE station_name = s.station_name" +
-                        "            ORDER BY  datetime DESC LIMIT 1) ) AS rainfall_difference" +
-                        "            FROM " + tableName + "s" +
-                        "            GROUP BY  station_name)";
+                String queryDataSql = "select sum(rainfall_difference) as total from(SELECT ABS( (SELECT rainfall FROM " + tableName + " WHERE station_name = s.station_name ORDER BY datetime ASC LIMIT 1) - (SELECT rainfall FROM " + tableName + " WHERE station_name = s.station_name ORDER BY datetime DESC LIMIT 1)) AS rainfall_difference FROM " + tableName + " s GROUP BY station_name)";
                 // 3. 澶勭悊鏌ヨ缁撴灉
                 try (PreparedStatement pstmt = conn.prepareStatement(queryDataSql)) {
                     ResultSet rs = pstmt.executeQuery();
@@ -266,7 +260,31 @@
         return null;
     }
 
-    public static Integer getDuration(String tableName) {
+    /**
+     * @param tableName 琛ㄥ悕绉�
+     * @return {@link Integer}
+     */
+    public static Integer getDuration(String tableName) throws SQLException {
+        // // 1. 杩炴帴鏁版嵁搴�
+        // try (Connection conn = DriverManager.getConnection("jdbc:sqlite:rainfall.db")) {
+        //     // 2. 鎵ц鏌ヨ璇彞
+        //     String queryDataSql = "SELECT duration FROM " + tableName;
+        //     try (PreparedStatement pstmt = conn.prepareStatement(queryDataSql)) {
+        //         ResultSet rs = pstmt.executeQuery();
+        //         while (rs.next()) {
+        //             // 鑾峰彇鎬诲拰
+        //             return rs.getInt("duration");
+        //         }
+        //     } catch (SQLException e) {
+        //         throw new RuntimeException(e);
+        //     }
+        // } catch (SQLException e) {
+        //     System.err.println("SQLite杩炴帴澶辫触: " + e.getMessage());
+        // }
+
+        // 鐩墠鍏堟牴鎹枃浠剁殑鍐呭锛屾墜鍔ㄧ粰鍊硷紝鍚庣画浣跨敤瑙ｆ瀽鏂囦欢鍐呭涓殑鏃堕棿
+        // TODO: 2024/12/27  鐩墠鍏堟牴鎹枃浠剁殑鍐呭锛屾墜鍔ㄧ粰鍊硷紝鎻愰珮澶勭悊閫熷害銆傚悗缁娇鐢ㄨВ鏋愭枃浠跺唴瀹逛腑鐨勬椂闂淬��
         return 1440;
     }
+
 }

--
Gitblit v1.9.3