From 1af31e38c6a2cd072ed310149c656780610fe57b Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期一, 21 四月 2025 08:42:54 +0800
Subject: [PATCH] 2.修复锁具开启之后记录bug
---
ElectLock_Monitor/src/com/dev/lock/data/ElectLock_Array.java | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/ElectLock_Monitor/src/com/dev/lock/data/ElectLock_Array.java b/ElectLock_Monitor/src/com/dev/lock/data/ElectLock_Array.java
index a56bf44..1bd136d 100644
--- a/ElectLock_Monitor/src/com/dev/lock/data/ElectLock_Array.java
+++ b/ElectLock_Monitor/src/com/dev/lock/data/ElectLock_Array.java
@@ -25,7 +25,7 @@
public boolean initEleLockData(MysqlConnPool pool) {
- String sql_str = " SELECT * FROM " + Sql_Mysql.Lock_Inf_Table;
+ String sql_str = " SELECT * FROM " + Sql_Mysql.Lock_Inf_Table + " ORDER BY lock_id ";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
ResultSet res = null;
boolean isChange = false;
@@ -35,7 +35,7 @@
res = sql.sqlMysqlQuery(sql_str);
while(res.next()) {
int lock_id = res.getInt("lock_id");
- int area_id = res.getInt("area_id"); //鍖哄煙ID
+ int station_id = res.getInt("station_id"); //鏈烘埧ID
String lock_name = res.getString("lock_name"); //閿佸悕绉�
String lock_type = res.getString("lock_type"); //閿佺被鍨�(鏃犳簮,钃濈墮)
int lock_state = res.getInt("lock_state"); //閿佺姸鎬�
@@ -63,7 +63,7 @@
} else {
ElectLock_Inf tmp_lock = new ElectLock_Inf(pool);
tmp_lock.setLock_id(lock_id);
- tmp_lock.setArea_id(area_id); //'鍖哄煙id',
+ tmp_lock.setStation_id(station_id); //'鍖哄煙id',
tmp_lock.setLock_name(lock_name); //'閿佸悕绉�',
tmp_lock.setLock_type(lock_type); //'閿佺被鍨�(鏃犳簮,钃濈墮)',
tmp_lock.setLock_state(lock_state); //'閿佺姸鎬�',
--
Gitblit v1.9.1