From 01218fde055b6fcd55f2820caa20cf9dd0c6d7e3 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 09 八月 2022 14:31:02 +0800
Subject: [PATCH] V1.37 edit at date 2022-08-09 1.默认创建'db_pwrdev_data_rt.tb_pwrdev_event'表用于记录山西61850设备的交流输入1/2的状态切换记录
---
BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java | 32 ++++++++++++++++++++++++++++++--
1 files changed, 30 insertions(+), 2 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
index 6cac18b..2a906b8 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
@@ -68,14 +68,32 @@
" KEY index_alm_cleared_type (alm_cleared_type)" +
") ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ ResultSet res = null;
try {
if(true == recreate) {
sql.sqlMysqlExecute(sql_str01);
}
- sql.sqlMysqlExecute(sql_str02);
+ sql.sqlMysqlExecute(sql_str02);
+
+ //添加指定的alm_value列'告警值'
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_alarm'"
+ + " AND table_name='tb_devalarm_data_history'"
+ + " AND column_name='alm_value'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data__History_Table
+ + " ADD COLUMN alm_value float NOT NULL DEFAULT '0';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
+ if(null != res) {
+ try {
+ res.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
sql.close_con();
}
}
@@ -116,6 +134,16 @@
}
sql.sqlMysqlExecute(sql_str02);
+ //添加指定的alm_value列'告警值'
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_alarm'"
+ + " AND table_name='tb_devalarm_data'"
+ + " AND column_name='alm_value'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data_Table
+ + " ADD COLUMN alm_value float NOT NULL DEFAULT '0';");
+ }
+ res = null;
//添加指定的work_flag列(派单管理)
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
@@ -126,7 +154,7 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data_Table
+ " ADD COLUMN `work_flag` tinyint NOT NULL DEFAULT 0;");
}
-
+ res = null;
//添加指定的msg_flag列(派单管理)
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ " WHERE table_schema='db_alarm'"
--
Gitblit v1.9.1