From 4ac0d38c6cd96d308bb38a4c0591403d8ede8c57 Mon Sep 17 00:00:00 2001 From: DELL <1525436766@qq.com> Date: 星期五, 07 二月 2025 16:39:36 +0800 Subject: [PATCH] 2.记录每年月季度的开锁次数,以及每年锁具状态变化记录-已完成 --- ElectLock_Monitor/src/com/dev/lock/comm/Lock_Task_SQL.java | 3 ++- 1 files changed, 2 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 9ac63d4..97d82e0 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 @@ -88,7 +88,8 @@ " Set lock_state = " + state.getLock_state() + " ,lock_online = " + state.getLock_online() + " ,lock_mac = '" + state.getLockMacAddr() + "'" + - " ,last_update_time = '" + Com.getDateTimeFormat(inf.getLast_update_time(), Com.DTF_YMDhms) + "'" + + " ,lock_open_count = " + state.getLock_open_count() + + " ,last_update_time = '" + Com.getDateTimeFormat(state.getLast_update_time(), Com.DTF_YMDhms) + "'" + " WHERE lock_id = " + inf.getLock_id(); Sql_Mysql sql = new Sql_Mysql(pool.getConn()); try { -- Gitblit v1.9.1