| | |
| | | KEY `index_alm_cleared_type` (`alm_cleared_type`) |
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='UPS电源历史告警表'; |
| | | |
| | | |
| | | 5.数据库表'web_site.tb_process_survey',新增UPS电源通信线程- 11028 |
| | | INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11028', 'BMS_UPS_POWER_MONITOR', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_UPS_POWER_MONITOR', '2', 'v1.100', 'UPS电源通信线程', '300');"); |
| | | |
| | | |
| | | V1.90 edit at date 2023-10-31 |
| | |
| | | if(false == res.next()) { |
| | | sql.sqlMysqlExecute(" INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11027', 'BMS_FD_K30NT', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_FD_K30NT', '2', 'v1.100', 'FD-K30NT通信线程', '300');"); |
| | | } |
| | | |
| | | //UPS电源通信线程 |
| | | res = sql.sqlMysqlQuery("SELECT ProcessName FROM "+ Sql_Mysql.ProcessSurvey_Table + " WHERE ProcessId = 11028"); |
| | | if(false == res.next()) { |
| | | sql.sqlMysqlExecute(" INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11028', 'BMS_UPS_POWER_MONITOR', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_UPS_POWER_MONITOR', '2', 'v1.100', 'UPS电源通信线程', '300');"); |
| | | } |
| | | } catch (SQLException e) { |
| | | e.printStackTrace(); |
| | | } finally { |
| | |
| | | KEY `index_alm_cleared_type` (`alm_cleared_type`) |
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='UPS电源历史告警表'; |
| | | |
| | | |
| | | 5.数据库表'web_site.tb_process_survey',新增UPS电源通信线程- 11028 |
| | | INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11028', 'BMS_UPS_POWER_MONITOR', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_UPS_POWER_MONITOR', '2', 'v1.100', 'UPS电源通信线程', '300');"); |
| | | |
| | | |
| | | V1.90 edit at date 2023-10-31 |