From 90c0fe3cc6fae4fd252c6ad1cbf5a30a3f557b70 Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期一, 02 十二月 2019 09:28:07 +0800
Subject: [PATCH] 紫晶中的tb_battmap_information表中添加stationName3字段
---
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 21 ++++++++++++++++++++-
1 files changed, 20 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
index dea6e04..aea823d 100644
--- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
+++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -650,7 +650,7 @@
}
//---------------------------------------------------------------------------------------------//
//为紫晶平台添加指定的列
- boolean isZijing = true;
+ boolean isZijing = false;
if(isZijing) {
//添加电压等级列
res = sqlMysqlQuery("SELECT * FROM information_schema.columns"
@@ -891,6 +891,25 @@
}
}
//---------------------------------------------------------------------------------------------//
+ //----------------------------- tb_fbsdev_statechange_inf 表中新增2个字段 ----------------------------------------------------------------//
+ res = sqlMysqlQuery("SELECT DATA_TYPE FROM information_schema.columns"
+ + " WHERE table_schema='db_app_sys'"
+ + " AND table_name='tb_fbsdev_statechange_inf'"
+ + " AND column_name='eve_type'");
+ if(false == res.next()) {
+ sqlMysqlExecute("ALTER TABLE " + FBSDevStateChangeInf_Table
+ + " ADD COLUMN `eve_type` int DEFAULT 0;");
+ }
+
+ res = sqlMysqlQuery("SELECT DATA_TYPE FROM information_schema.columns"
+ + " WHERE table_schema='db_app_sys'"
+ + " AND table_name='tb_fbsdev_statechange_inf'"
+ + " AND column_name='module_num'");
+ if(false == res.next()) {
+ sqlMysqlExecute("ALTER TABLE " + FBSDevStateChangeInf_Table
+ + " ADD COLUMN `module_num` int DEFAULT 0;");
+ }
+
}
//使用db数据库
--
Gitblit v1.9.1