From d3fb0864720b977eee0b80cafefcd2eee4a6d005 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期一, 15 八月 2022 13:58:07 +0800
Subject: [PATCH] V1.38 edit at date 2022-08-15 1.表'db_ram_db.tb_fbs9100_state'表新增字段 -- 充放电一体机新增市电中断判断 `a059_acvolLowFlag` int(11) NOT NULL DEFAULT '0' COMMENT '市电中断状态(0：正常；1：市电中断)'
---
BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
index abb8966..d2b9139 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
@@ -1946,6 +1946,17 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table
+ " ADD COLUMN `a059_onlineSaveVol` float NOT NULL DEFAULT '0' COMMENT '充放电一体机切换电池组保护电压';");
}
+
+ res = null;
+ //添加字段a059_acvolLowFlag-市电中断状态
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100_state'"
+ + " AND column_name='a059_acvolLowFlag'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table
+ + " ADD COLUMN `a059_acvolLowFlag` int(11) NOT NULL DEFAULT '0' COMMENT '市电中断状态(0：正常；1：市电中断)';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1