From aa8c04269a191e7c4b157b6442b7beb0e064a5b5 Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期三, 23 九月 2020 11:34:00 +0800
Subject: [PATCH] 2kw添加实时和历史故障检测和存储
---
ElectricalSystem_MonitorServer_2KW/src/com/electrical/TwoKW/Electrical_2KWTask_SQL.java | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/ElectricalSystem_MonitorServer_2KW/src/com/electrical/TwoKW/Electrical_2KWTask_SQL.java b/ElectricalSystem_MonitorServer_2KW/src/com/electrical/TwoKW/Electrical_2KWTask_SQL.java
index d5f21cc..5a93497 100644
--- a/ElectricalSystem_MonitorServer_2KW/src/com/electrical/TwoKW/Electrical_2KWTask_SQL.java
+++ b/ElectricalSystem_MonitorServer_2KW/src/com/electrical/TwoKW/Electrical_2KWTask_SQL.java
@@ -793,6 +793,35 @@
sql.close_con();
}
}
+
+ /**
+ * 查询当前设备上一次的历史告警记录表
+ * @param pool
+ * @param alarm
+ */
+ public static void searchLastDeviceAlarm(MysqlConnPool pool,Electric_2MW_alarm alarm) {
+ String sql_str = "SELECT * FROM "+Sql_Mysql.Tb_Electric_2MW_alarm+" WHERE electric_id = " + alarm.electric_id;
+ ResultSet res = null;
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ res = sql.sqlMysqlQuery(sql_str);
+ while(res.next()) {
+ //加载当前设备之前的实时告警记录
+ alarm.setAlarmStateByAlarm_id(res.getInt("alarm_id"));
+ }
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ if(res != null) {
+ try {
+ res.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
+ sql.close_con();
+ }
+ }
}
--
Gitblit v1.9.1