11111

DELL

2025-04-28 eb746715527db9b42740db84bb576735185e21cd

 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 + " WHERE del_flag = 0  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);         //'锁状态',

@@ -77,6 +77,9 @@
               Lock_Task_SQL.queryLock_Rt_TableByLockId(pool, lock_id, tmp_lock.lockState);

               Lock_Task_SQL.queryLock_Report_TableByLockId(pool, lock_id, tmp_lock.lockReport, nowYear);

               

               Lock_Task_SQL.insertLock_IdCard_Table(pool, lock_id);

               Lock_Task_SQL.insertLock_Rt_Table(pool, lock_id);

					
               mInfs.add(tmp_lock);

            }