From e6c729f96678f70aed8f8d3baabe8fb46c1b79b4 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期五, 25 八月 2023 10:01:07 +0800
Subject: [PATCH] V3.106 lijun edit 2023-08-25 1.修复历史实时数据中的超时历史实时数据表循环删除功能优化 2.优化设备通信计数设备通信断开后重新计数
---
BattFBS9600XSP2/src/com/dev/fbs9600/FBS9600_State_SQL.java | 36 +++++++++++++++++++++++++++++++++---
1 files changed, 33 insertions(+), 3 deletions(-)
diff --git a/BattFBS9600XSP2/src/com/dev/fbs9600/FBS9600_State_SQL.java b/BattFBS9600XSP2/src/com/dev/fbs9600/FBS9600_State_SQL.java
index 4827a9f..fa667b4 100644
--- a/BattFBS9600XSP2/src/com/dev/fbs9600/FBS9600_State_SQL.java
+++ b/BattFBS9600XSP2/src/com/dev/fbs9600/FBS9600_State_SQL.java
@@ -412,19 +412,49 @@
+ " dev_ip = '" + state.ip_addr+"',"
+ " dev_captest_groupvol="+state.dev_groupvols[0]+","
+ " dev_captest_curr = "+state.dev_currs[0]+","
- + " dev_commcount = "+state.com_count+","
- + " dev_errcommcount= "+state.com_err_count
+ + " dev_commcount = "+state.getTotalCommCount()+","
+ + " dev_errcommcount= "+state.getTotalErrCommCount()
+ " WHERE dev_id= " + state.dev_id;
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
try {
sql.sqlMysqlExecute(sql_str);
} catch (SQLException e) {
- e.printStackTrace();
+ sql.logger.error(e.toString(), e);
} finally {
sql.close_con();
}
}
+
+ public static void queryFBS9100State_Table(MysqlConnPool pool, FBS9600_State state) {
+ String sql_str = " select * from db_ram_db.tb_fbs9100_state "
+ + " WHERE dev_id= " + state.dev_id;
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ ResultSet res = null;
+ try {
+ res = sql.sqlMysqlQuery(sql_str);
+ if(res.next()) {
+ state.setWorkState(res.getInt("dev_workstate"));
+ state.dev_groupvols[0] = res.getFloat("dev_captest_groupvol");
+ state.dev_currs[0] = res.getFloat("dev_captest_curr");
+ state.com_totalcount = res.getInt("dev_commcount");
+ state.com_err_totalcount = res.getInt("dev_errcommcount");
+
+ }
+ } catch (Exception e) {
+ sql.logger.error(e.toString(), e);
+ } finally {
+ if(null != res) {
+ try {
+ res.close();
+ } catch (SQLException e) {
+ sql.logger.error(e.toString(), e);
+ }
+ }
+ sql.close_con();
+ }
+ }
+
/**
* 鏇存柊绋嬪簭鍚姩鏃堕棿浠ュ強瀵瑰簲绋嬪簭鐨勭増鏈彿
* @param pool
--
Gitblit v1.9.1