From 027d4a8e00a9881884824be44d9aee0289b747d4 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 15 八月 2023 16:34:25 +0800
Subject: [PATCH] V1.85 edit at date 2023-08-15 1.创建表'db_alarm.tb_alarm_manual_clear' 2.创建表'web_site.tb_fbs9100_setparam_temp' 3.创建表'db_param.tb_appalm_param',并录入所有[电源，电池，设备告警是否能自动消失配置]
---
BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 56 insertions(+), 0 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 a6961f9..29cc248 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
@@ -30,6 +30,8 @@
createTb_Alarm_Detail_Table(pool, recreate); //创建告警详情
createTb_Alarm_Relation_Table(pool, recreate); //创建告警对应关系
+
+ createTb_Alarm_Manual_Clear_Table(pool,recreate);
System.out.println(" db_alarm init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
}
@@ -519,6 +521,60 @@
sql.close_con();
}
}
+ /**
+ *
+ * @Title: create tb_alarm_manual_clear
+ * @Description:告警对应关系
+ * @param pool
+ * @param recreate
+ * @author author
+ * @date 2021年9月6日
+ */
+ public static void createTb_Alarm_Manual_Clear_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Alarm_Manual_Clear_Table;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Alarm_Manual_Clear_Table + " (" +
+ " `id` int(11) NOT NULL AUTO_INCREMENT," +
+ " `station_id` varchar(10) DEFAULT NULL," +
+ " `station_name1` varchar(45) DEFAULT NULL," +
+ " `station_name2` varchar(45) DEFAULT NULL," +
+ " `station_name3` varchar(45) DEFAULT NULL," +
+ " `station_name5` varchar(45) DEFAULT NULL," +
+ " `alarm_type` tinyint(4) DEFAULT NULL COMMENT '告警类型:1-电池,2-设备,3-电源'," +
+ " `batt_group_id` int(11) DEFAULT NULL," +
+ " `batt_group_name` varchar(45) DEFAULT NULL," +
+ " `mon_num` int(11) DEFAULT NULL," +
+ " `device_id` int(11) DEFAULT NULL," +
+ " `device_name` varchar(45) DEFAULT NULL," +
+ " `power_device_id` int(11) DEFAULT NULL," +
+ " `alm_start_time` datetime DEFAULT NULL," +
+ " `alm_id` int(11) DEFAULT NULL," +
+ " `alm_signal_id` int(11) DEFAULT NULL," +
+ " `reason` varchar(255) DEFAULT NULL COMMENT '恢复原因'," +
+ " `create_time` datetime DEFAULT NULL," +
+ " `deal_user_id` int(11) DEFAULT NULL," +
+ " PRIMARY KEY (`id`)" +
+ ") ENGINE=InnoDB 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);
+
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ if(null != res) {
+ try {
+ res.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
+ sql.close_con();
+ }
+ }
}
--
Gitblit v1.9.1