From e70dfa4d8068d0ffba5bc88acedf71b3b353f60f Mon Sep 17 00:00:00 2001
From: DELL <DELL@WIN-3EOIPEE9ML1>
Date: 星期五, 23 二月 2024 15:48:42 +0800
Subject: [PATCH] 修复bug
---
iec61850_forFoShanAES_Model/src/com/iedscout/BTS61850_IEDScout_Task_Thread_SQL.java | 15 ++++++++++++++-
1 files changed, 14 insertions(+), 1 deletions(-)
diff --git a/iec61850_forFoShanAES_Model/src/com/iedscout/BTS61850_IEDScout_Task_Thread_SQL.java b/iec61850_forFoShanAES_Model/src/com/iedscout/BTS61850_IEDScout_Task_Thread_SQL.java
index 6385c01..da05550 100644
--- a/iec61850_forFoShanAES_Model/src/com/iedscout/BTS61850_IEDScout_Task_Thread_SQL.java
+++ b/iec61850_forFoShanAES_Model/src/com/iedscout/BTS61850_IEDScout_Task_Thread_SQL.java
@@ -94,7 +94,7 @@
try {
res = sql.sqlMysqlQuery(sql_str_sel);
if(res.next()) {
- sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.Ied_NodeState_Table + " SET node_value = '" + value.node_value + "',node_name = '" + value.node_name + "' WHERE node_path = '" + value.node_path + "';");
+ //sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.Ied_NodeState_Table + " SET node_value = '" + value.node_value + "',node_name = '" + value.node_name + "' WHERE node_path = '" + value.node_path + "';");
}else {
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Ied_NodeState_Table + "(node_path,node_name,node_value) VALUES('" + value.node_path + "','" + value.node_name + "','" + value.node_value + "');");
}
@@ -165,6 +165,19 @@
}
}
+
+ public static void updateupdateIed_NodeState_Table(MysqlConnPool pool,ScoutData data) {
+ StringBuffer sql_str = new StringBuffer(" UPDATE " + Sql_Mysql.Ied_NodeState_Table + " SET node_value = " + data.node_value + ",node_name = '"+ data.node_name +"' where node_path = '"+ data.node_path +"';");
+ Sql_Mysql sql = new Sql_Mysql(pool);
+ try {
+ //System.out.println(sql_str.toString());
+ sql.sqlMysqlExecute(sql_str.toString());
+ } catch (SQLException e) {
+ sql.logger.error("BTS61850_IEDScout_Task_Thread_SQL.updateupdateIed_NodeState_Table():" + e.toString(), e);
+ } finally {
+ sql.close_con();
+ }
+ }
/**
* 娓呯┖'db_ied_scout.tb_ied_nodestate'琛ㄤ腑鐨勬墍鏈夋暟鎹�
* @param pool
--
Gitblit v1.9.1