BattMonitor_DB_Builder/bin/com/database_util/DB_Alarm.classBinary files differ
BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Alarm.classBinary files differ
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt
@@ -5,6 +5,9 @@ 1.创建表'db_alarm.tb_alarm_manual_clear' 2.创建表'web_site.tb_fbs9100_setparam_temp' 3.创建表'db_param.tb_appalm_param',并录入所有[电源，电池，设备告警是否能自动消失配置] 4.创建表'db_alarm.tb_battalarm_data_verify'-电池告警确认表 5.创建表'db_alarm.tb_devalarm_data_verify'-设备告警确认表 6.创建表'db_pwrdev_alarm.tb_pwrdev_alarm_verify'-电源告警确认表 V1.84 edit at date 2023-07-27 1.删除默认的电源交流停电告警参数 BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
@@ -32,6 +32,10 @@ createTb_Alarm_Relation_Table(pool, recreate); //创建告警对应关系 createTb_Alarm_Manual_Clear_Table(pool,recreate); createTb_Battalarm_Data_Verify_Table(pool, recreate); //创建电池告警确认处理表 createTb_Devalarm_Data_Verify_Table(pool, recreate); //创建设备告警确认处理表 System.out.println(" db_alarm init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)); } @@ -575,6 +579,121 @@ sql.close_con(); } } /** * * @Title: create tb_battalarm_data_verify * @Description:电池告警确认处理表 * @param pool * @param recreate * @author author * @date 2021年9月6日 */ public static void createTb_Battalarm_Data_Verify_Table(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Battalarm_Data_Verify_Table; String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Battalarm_Data_Verify_Table + " (" + " `num` bigint(20) NOT NULL AUTO_INCREMENT," + " `BattGroupId` int(11) NOT NULL DEFAULT '0'," + " `MonNum` int(11) NOT NULL DEFAULT '0'," + " `Record_Id` bigint(20) NOT NULL DEFAULT '0'," + " `alm_id` int(11) NOT NULL DEFAULT '0'," + " `alm_signal_id` int(11) NOT NULL DEFAULT '0'," + " `alm_level` int(11) NOT NULL DEFAULT '0'," + " `alm_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + " `alm_end_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + " `alm_value` float NOT NULL DEFAULT '0'," + " `alm_is_confirmed` tinyint(1) NOT NULL DEFAULT '0'," + " `alm_confirmed_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + " `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," + " `usr_Id` int(11) NOT NULL DEFAULT '0'," + " `work_flag` tinyint(4) NOT NULL DEFAULT '0'," + " `msg_flag` tinyint(4) NOT NULL DEFAULT '0'," + " `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'," + " PRIMARY KEY (`num`)," + " KEY `index_battgroup_id` (`BattGroupId`)," + " KEY `index_Record_Id` (`Record_Id`)," + " KEY `index_alm_id` (`alm_id`)," + " KEY `index_alm_start_time` (`alm_start_time`)," + " KEY `index_alm_cleared_type` (`alm_cleared_type`)," + " KEY `index_alm_signal_id` (`alm_signal_id`)," + " KEY `index_alm_level` (`alm_level`)" + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电池告警确认处理表';"; 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(); } } /** * * @Title: create tb_devalarm_data_verify * @Description:设备告警确认处理表 * @param pool * @param recreate * @author author * @date 2021年9月6日 */ public static void createTb_Devalarm_Data_Verify_Table(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Devalarm_Data_Verify_Table; String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Devalarm_Data_Verify_Table + " (" + " `num` bigint(20) NOT NULL AUTO_INCREMENT," + " `record_id` bigint(20) NOT NULL DEFAULT '0'," + " `dev_id` int(11) NOT NULL DEFAULT '0'," + " `dev_ip` varchar(24) NOT NULL DEFAULT '127.0.0.1'," + " `alm_type` int(11) NOT NULL DEFAULT '0'," + " `alm_level` int(11) NOT NULL DEFAULT '0'," + " `alm_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + " `alm_end_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + " `alm_value` float NOT NULL DEFAULT '0'," + " `alm_is_confirmed` tinyint(1) NOT NULL DEFAULT '0'," + " `alm_confirmed_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + " `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," + " `usr_Id` int(11) NOT NULL DEFAULT '0'," + " `work_flag` tinyint(4) NOT NULL DEFAULT '0'," + " `msg_flag` tinyint(4) NOT NULL DEFAULT '0'," + " `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]'," + " PRIMARY KEY (`num`)," + " KEY `index_record_id` (`record_id`)," + " KEY `index_dev_id` (`dev_id`)," + " KEY `index_alm_type` (`alm_type`)," + " KEY `index_alm_start_time` (`alm_start_time`)," + " KEY `index_alm_cleared_type` (`alm_cleared_type`)" + ") ENGINE=InnoDB AUTO_INCREMENT=16726 DEFAULT CHARSET=utf8 COMMENT='设备告警确认处理表';"; 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(); } } } BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java
@@ -29,6 +29,9 @@ createPwrdev_Alarm_Param_ForSX_Table(pool, recreate); createPwrdev_Alarm_Verify_Table(pool, recreate); //电源告警确认处理表 System.out.println(" db_pwrdev_alarm init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)); } @@ -60,6 +63,50 @@ sql.close_con(); } } /** * 创建电源告警确认处理表 * @param pool * @param recreate */ private static void createPwrdev_Alarm_Verify_Table(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Alarm_Verify_Table; String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Alarm_Verify_Table + " (" + " `num` bigint(20) NOT NULL AUTO_INCREMENT," + " `record_id` bigint(20) NOT NULL DEFAULT '0'," + " `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," + " `alm_type` int(11) NOT NULL DEFAULT '0'," + " `alm_level` int(11) NOT NULL DEFAULT '0'," + " `alm_source` int(11) NOT NULL DEFAULT '0'," + " `alm_index` int(11) NOT NULL DEFAULT '0'," + " `alm_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + " `alm_end_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + " `alm_value` float NOT NULL DEFAULT '0'," + " `alm_is_confirmed` tinyint(1) NOT NULL DEFAULT '0'," + " `alm_confirmed_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + " `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," + " `usr_Id` int(11) NOT NULL DEFAULT '0'," + " `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]'," + " `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'," + " PRIMARY KEY (`num`)," + " KEY `index_record_id` (`record_id`)," + " KEY `index_pwrdev_id` (`PowerDeviceId`)," + " KEY `index_alm_type` (`alm_type`)," + " KEY `index_alm_start_time` (`alm_start_time`)," + " KEY `index_alm_cleared_type` (`alm_cleared_type`)" + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='电源告警确认处理表';"; Sql_Mysql sql = new Sql_Mysql(pool.getConn()); try { if(true == recreate) { sql.sqlMysqlExecute(sql_str01); } sql.sqlMysqlExecute(sql_str02); } catch (SQLException e) { e.printStackTrace(); } finally { sql.close_con(); } } private static void createPwrdev_Time_Adj_Alarm_Table(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Time_Adj_Alarm_Table; String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Time_Adj_Alarm_Table + " (" + BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -282,6 +282,9 @@ public final static String Tb_Alarm_Relation_Table = DB_ALARM + ".`tb_alarm_relation`"; public final static String Tb_Alarm_Manual_Clear_Table = DB_ALARM + ".`tb_alarm_manual_clear`"; public final static String Tb_Battalarm_Data_Verify_Table = DB_ALARM + ".`tb_battalarm_data_verify`"; //电池告警确认处理表 public final static String Tb_Devalarm_Data_Verify_Table = DB_ALARM + ".`tb_devalarm_data_verify`"; //设备告警确认处理表 /***************************** db_app_sys 数据库 ***************************************/ public final static String Page_Param_Table = DB_AppSys + ".`tb_page_param`"; @@ -328,6 +331,7 @@ public final static String Pwrdev_Alarm_Param_ForSX_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_alarm_param_forsx`"; //山西电源告警参数表 public final static String Pwrdev_Alarm_Verify_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_alarm_verify`"; //电源告警确认处理表 /***************************** db_pwrdev_data_rt 数据库 ************************************/ BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -5,6 +5,9 @@ 1.创建表'db_alarm.tb_alarm_manual_clear' 2.创建表'web_site.tb_fbs9100_setparam_temp' 3.创建表'db_param.tb_appalm_param',并录入所有[电源，电池，设备告警是否能自动消失配置] 4.创建表'db_alarm.tb_battalarm_data_verify'-电池告警确认表 5.创建表'db_alarm.tb_devalarm_data_verify'-设备告警确认表 6.创建表'db_pwrdev_alarm.tb_pwrdev_alarm_verify'-电源告警确认表 V1.84 edit at date 2023-07-27 1.删除默认的电源交流停电告警参数
