From 7c594971d117f8ef5ca3977f1d087aa216e147df Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期六, 22 三月 2025 10:01:05 +0800
Subject: [PATCH] 修复系统参数表运行时报错
---
BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java | 34 ++++++++++++++++++++++------------
1 files changed, 22 insertions(+), 12 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java b/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
index c5d3d2d..4f20d0a 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
@@ -507,20 +507,20 @@
sql_str_bf.append("('42', '瀵嗙爜璁剧疆瑙勫垯-浣嶆暟', '8', '10','Password setting rules - number of digits'),");
sql_str_bf.append("('43', '瀵嗙爜璁剧疆瑙勫垯-绗﹀彿绫诲瀷', '4', '10','Password Setting Rules - Symbol Types'),");
sql_str_bf.append("('44', '鍘嗗彶鏁版嵁鐨勯┘宄伴攨搴曞姛鑳藉紑鍚�', '1', '11','Enabling the Hump Pot Bottom Function of Historical Data'),");
- sql_str_bf.append("('45', '鍘嗗彶鏁版嵁鐨勬暟鎹樉绀虹矑搴�', '5', '11','Data display granularity of historical data'),");
+ sql_str_bf.append("('45', '鍘嗗彶鏁版嵁鐨勬暟鎹樉绀虹矑搴�', '5', '11','Data display granularity of historical data')");
- sql_str_bf.append("('47', '鏀剧數鏃堕暱', '10', '12',''),");
- sql_str_bf.append("('48', '宸﹁竟瑙勫畾鏀剧數鏃堕暱', '10', '12',''),");
- sql_str_bf.append("('49', '宸﹁竟瑙勫畾鏃堕棿娆℃暟', '10', '12',''),");
- sql_str_bf.append("('50', '鍙宠竟瑙勫畾鏃堕棿鏃堕暱', '1', '12',''),");
- sql_str_bf.append("('51', '鍙宠竟瑙勫畾鏃堕棿娆℃暟', '1', '12',''),");
- sql_str_bf.append("('52', '鏀剧數浼樺寲鏃堕棿', '2', '13',''),");
+ sql_str_bf.append(",('47', '鏀剧數鏃堕暱', '10', '12','')");
+ sql_str_bf.append(",('48', '宸﹁竟瑙勫畾鏀剧數鏃堕暱', '10', '12','')");
+ sql_str_bf.append(",('49', '宸﹁竟瑙勫畾鏃堕棿娆℃暟', '10', '12','')");
+ sql_str_bf.append(",('50', '鍙宠竟瑙勫畾鏃堕棿鏃堕暱', '1', '12','')");
+ sql_str_bf.append(",('51', '鍙宠竟瑙勫畾鏃堕棿娆℃暟', '1', '12','')");
+ sql_str_bf.append(",('52', '鏀剧數浼樺寲鏃堕棿', '2', '13','')");
- sql_str_bf.append("('53', '鏍稿鏀剧數鏃堕棿杩囨护', '2', '14',''),");
- sql_str_bf.append("('54', '鏍稿鍏呯數鏃堕棿杩囨护', '2', '14',''),");
- sql_str_bf.append("('55', '鐩戞祴鏀剧數鏃堕棿杩囨护', '2', '14',''),");
- sql_str_bf.append("('56', '鐩戞祴鍏呯數鏃堕棿杩囨护', '2', '14','')");
- sql_str_bf.append("('57', '鐢ㄦ埛瀵嗙爜鏃舵晥', '-1', '15','')");
+ sql_str_bf.append(",('53', '鏍稿鏀剧數鏃堕棿杩囨护', '2', '14','')");
+ sql_str_bf.append(",('54', '鏍稿鍏呯數鏃堕棿杩囨护', '2', '14','')");
+ sql_str_bf.append(",('55', '鐩戞祴鏀剧數鏃堕棿杩囨护', '2', '14','')");
+ sql_str_bf.append(",('56', '鐩戞祴鍏呯數鏃堕棿杩囨护', '2', '14','')");
+ sql_str_bf.append(",('57', '鐢ㄦ埛瀵嗙爜鏃舵晥', '-1', '15','')");
//System.out.println(sql_str_bf.toString());
sql.sqlMysqlExecute(sql_str_bf.toString());
@@ -796,6 +796,16 @@
+ " ADD COLUMN `AppServer_Reinit_BattGroupData_6184_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '鍏ㄥ姛鑳介�嗗彉鍋囪礋杞介噸杞界數姹犵粍鏁版嵁';");
}
+ //娣诲姞6286閲嶈浇鏁版嵁
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_app_sys'"
+ + " AND table_name='tb_app_sys'"
+ + " AND column_name='AppServer_Reinit_BattGroupData_6286_EN'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
+ + " ADD COLUMN `AppServer_Reinit_BattGroupData_6286_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'BTS2202RS485閲嶈浇鐢垫睜缁勬暟鎹�';");
+ }
+
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1