From 08dc1e837b3763bb8bc7d5a62c541ebb12bc611a Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期六, 11 七月 2020 09:40:59 +0800
Subject: [PATCH] 适应于广东电信版本平台添加组2接触器导通阻抗
---
BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java | 11 ++++++++++-
1 files changed, 10 insertions(+), 1 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 0225d1c..d52159f 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
@@ -138,7 +138,7 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table
+ " ADD COLUMN `dev_condvoldp` float NOT NULL DEFAULT 0;");
}
- //添加dev_conresist
+ //添加dev_conresist 组1接触器导通阻抗
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ " WHERE table_schema='db_ram_db'"
+ " AND table_name='tb_fbs9100_state'"
@@ -147,6 +147,15 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table
+ " ADD COLUMN `dev_conresist` float NOT NULL DEFAULT 0;");
}
+ //添加dev_conresist 组2接触器导通阻抗
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100_state'"
+ + " AND column_name='dev_conresist1'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table
+ + " ADD COLUMN `dev_conresist1` float NOT NULL DEFAULT 0 after dev_conresist;");
+ }
//添加dev_condcurr
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ " WHERE table_schema='db_ram_db'"
--
Gitblit v1.9.1