| | |
|---|
| | | 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"); //锁状态
|
|---|
| | |
|---|
| | | } 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); //'锁状态',
|
|---|
