From be007235b7dc947bc42d1c132945c0a0c79488e7 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期五, 04 十一月 2022 10:17:33 +0800
Subject: [PATCH] V1.45 edit at date 2022-11-04 1.新增电操开关表'db_ram_db.tb_fbs9100_setparam'表新增字段 `MonCapStd` int(11) NOT NULL DEFAULT '0' COMMENT '标称容量' ----- 电操开关新增参数标称容量
---
BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java | 9 +++++++++
1 files changed, 9 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java b/BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java
index 40c16c3..35b7317 100644
--- a/BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java
+++ b/BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java
@@ -903,6 +903,15 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table
+ " ADD COLUMN `HV_mon_uppernum3` int(11) NOT NULL DEFAULT '0' COMMENT '恒压阶段3上限个数'");
}
+ //2022-11-04添加指定的MonCapStd列(标称容量)
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100_setparam'"
+ + " AND column_name='MonCapStd'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table
+ + " ADD COLUMN `MonCapStd` int(11) NOT NULL DEFAULT '0' COMMENT '标称容量';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1