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 | 32 +++++++++++++++++++++++++++++++-
1 files changed, 31 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/se/simu/utils/CsvToSQLiteUtils.java b/src/main/java/com/se/simu/utils/CsvToSQLiteUtils.java
index 0ce72c1..165bb0d 100644
--- a/src/main/java/com/se/simu/utils/CsvToSQLiteUtils.java
+++ b/src/main/java/com/se/simu/utils/CsvToSQLiteUtils.java
@@ -230,6 +230,12 @@
}
}
+ /**
+ * 鑾峰彇鎬昏
+ *
+ * @param tableName 琛ㄥ悕绉�
+ * @return {@link Double}
+ */
public static Double getTotal(String tableName) {
// 1. 鍒涘缓SQLite鏁版嵁搴撹繛鎺�
try (Connection conn = DriverManager.getConnection("jdbc:sqlite:rainfall.db")) {
@@ -254,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