From 2622d9aacbb178ea07edcbd4f31cc14d630814d3 Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期二, 24 九月 2019 16:10:12 +0800
Subject: [PATCH] 修改软件版本并且记录当前修改的记录
---
BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java | 20 ++++++++++++++++++++
1 files changed, 20 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 6a17179..988cda9 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
@@ -352,6 +352,26 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table
+ " ADD COLUMN `AutoTestStartVol` float NOT NULL DEFAULT 0;");
}
+
+ //添加指定的 OnLineVol_Low 列(在线电压低阀值)
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100_setparam'"
+ + " AND column_name='OnLineVol_Low'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table
+ + " ADD COLUMN `OnLineVol_Low` float NOT NULL DEFAULT 0;");
+ }
+
+ //添加指定的 OffLineYH_Cycle 列(离线养护周期)
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100_setparam'"
+ + " AND column_name='OffLineYH_Cycle'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table
+ + " ADD COLUMN `OffLineYH_Cycle` int NOT NULL DEFAULT 0;");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1