From 2993f12d24195683aed69ff88ff53af2a198fe55 Mon Sep 17 00:00:00 2001
From: DELL <DELL@WIN-3EOIPEE9ML1>
Date: 星期三, 27 三月 2024 15:38:16 +0800
Subject: [PATCH] 启动时默认录入未添加的机房的内阻测试计划记录
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 19 +++++++++++++++++--
1 files changed, 17 insertions(+), 2 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
index e3b08e3..5259524 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
@@ -196,16 +196,31 @@
" PRIMARY KEY (`num`) USING BTREE" +
") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='机房内阻测试计划信息表';";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ ResultSet res = null;
try {
if(true == recreate) {
sql.sqlMysqlExecute(sql_str01);
}
sql.sqlMysqlExecute(sql_str02);
-
-
+ res = sql.sqlMysqlQuery(" SELECT DISTINCT(StationId) FROM " + Sql_Mysql.BattInf_Table +
+ " WHERE StationId NOT IN (" +
+ " SELECT stationid " +
+ " FROM " + Sql_Mysql.Tb_Resset_Station_Table +
+ " )");
+ while(res.next()) {
+ String station_id = res.getString("StationId");
+ sql.sqlMysqlExecute("INSERT INTO web_site.tb_resset_station(stationid) VALUES("+station_id+");");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
+ if(null != res) {
+ try {
+ res.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
sql.close_con();
}
}
--
Gitblit v1.9.1