From 171c51b63d5d8c14cdefc1e8ca1e1b0f8cc620d2 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期一, 24 七月 2023 14:01:29 +0800
Subject: [PATCH] 2.'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'表新增上上限告警等级和下下限告警等级 `alarm_limitL_level` int(11) NOT NULL DEFAULT '1' COMMENT '下限告警等级', `alarm_limitH_level` int(11) NOT NULL DEFAULT '1' COMMENT '上限告警等级',
---
BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java | 22 ++++++++++++++++++++++
1 files changed, 22 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java
index fdf0a5d..db9f5ae 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java
@@ -349,6 +349,8 @@
" `alm_delay_time` int(11) NOT NULL DEFAULT '60' COMMENT '告警延迟时长[单位：秒]'," +
" `alarm_limitH_upper_level` int(11) NOT NULL DEFAULT '1' COMMENT '上上限告警等级'," +
" `alarm_limitL_lower_level` int(11) NOT NULL DEFAULT '1' COMMENT '下下限告警等级'," +
+ " `alarm_limitH_level` int(11) NOT NULL DEFAULT '1' COMMENT '上限告警等级'," +
+ " `alarm_limitL_level` int(11) NOT NULL DEFAULT '1' COMMENT '下限告警等级'," +
" PRIMARY KEY (`num`)" +
") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表';";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
@@ -441,6 +443,26 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
+ " ADD COLUMN `alarm_limitL_lower_level` int(11) NOT NULL DEFAULT '1' COMMENT '下下限告警等级';");
}
+ res = null;
+ //添加 alarm_limitH_level --上限告警等级
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_pwrdev_alarm'"
+ + " AND table_name='tb_pwrdev_alarm_param_forsx'"
+ + " AND column_name='alarm_limitH_level'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
+ + " ADD COLUMN `alarm_limitH_level` int(11) NOT NULL DEFAULT '1' COMMENT '上限告警等级';");
+ }
+ res = null;
+ //添加 alarm_limitL_level --下下限告警等级
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_pwrdev_alarm'"
+ + " AND table_name='tb_pwrdev_alarm_param_forsx'"
+ + " AND column_name='alarm_limitL_level'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
+ + " ADD COLUMN `alarm_limitL_level` int(11) NOT NULL DEFAULT '1' COMMENT '下限告警等级';");
+ }
res = sql.sqlMysqlQuery("SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Inf_Table);
StringBuffer buf_base = new StringBuffer("INSERT INTO " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + "(PowerDeviceId,alm_id,alm_level,alarm_limitH,alarm_limitH_EN,alarm_limitL,alarm_limitL_EN,alarm_name,alarm_type) VALUES");
--
Gitblit v1.9.1