From 6ab9c7858c234f51719acc3e514a1af769da578b Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期四, 19 十二月 2024 10:26:10 +0800
Subject: [PATCH] 更新实时数据同时更新锁具inf表
---
ElectLock_Monitor/src/com/dev/lock/comm/Lock_Task_SQL.java | 23 ++++++++++++++++++++++-
1 files changed, 22 insertions(+), 1 deletions(-)
diff --git a/ElectLock_Monitor/src/com/dev/lock/comm/Lock_Task_SQL.java b/ElectLock_Monitor/src/com/dev/lock/comm/Lock_Task_SQL.java
index 512c2e5..961473f 100644
--- a/ElectLock_Monitor/src/com/dev/lock/comm/Lock_Task_SQL.java
+++ b/ElectLock_Monitor/src/com/dev/lock/comm/Lock_Task_SQL.java
@@ -14,7 +14,7 @@
public static void insertLock_Rt_Table(MysqlConnPool pool,int lock_id,ElectLock_State state) {
- String sql_str_sel = "SELECT * FROM " + Sql_Mysql.Lock_Rt_Table + " WHERE lock_id = 1";
+ String sql_str_sel = "SELECT * FROM " + Sql_Mysql.Lock_Rt_Table + " WHERE lock_id = " + lock_id;
String sql_str_ins = "INSERT INTO " + Sql_Mysql.Lock_Rt_Table + "(lock_id,client_ip) VALUES("+lock_id+",'" + state.getClient_ip() + "');";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
ResultSet res = null;
@@ -68,6 +68,27 @@
}
/**
+ * 鏇存柊 tb_lock_inf 琛ㄤ腑閿佺殑鐘舵��
+ * @param pool
+ * @param lock_id
+ * @param state
+ */
+ public static void updateLock_Inf_Table(MysqlConnPool pool,int lock_id,ElectLock_State state) {
+ String sql_str = "UPDATE " + Sql_Mysql.Lock_Inf_Table +
+ " Set lock_state = " + state.getLock_state() +
+ " WHERE lock_id = " + lock_id;
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ sql.sqlMysqlExecute(sql_str);
+ } catch (SQLException e) {
+ sql.logger.error(e.toString(),e);
+ } finally {
+ sql.close_con();
+ }
+ }
+
+
+ /**
* 鏌ヨ鏄惁鏈夐渶瑕佹帶鍒剁殑閿佸叿
* @param pool
* @param lock_id
--
Gitblit v1.9.1