| | |
| | | //批量升级前验证升级的设备必须处于在线监测状态(9100state的workstate为0)
|
| | | public List judgeStation(Object obj){
|
| | | List<Integer> list=(List<Integer>) obj;
|
| | | String sql=" select distinct dev_id,db_battinf.tb_battinf.stationname3 from db_ram_db.tb_fbs9100_state,db_battinf.tb_battinf " +
|
| | | String sql=" select distinct dev_id,db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.stationname3 from db_ram_db.tb_fbs9100_state,db_battinf.tb_battinf " +
|
| | | " where db_ram_db.tb_fbs9100_state.dev_id=db_battinf.tb_battinf.fBSDeviceId and dev_workstate=0 and dev_id in(";
|
| | | String devSql="";
|
| | | Object[] object=new Object[list.size()];
|
| | |
| | | while(rs.next()){
|
| | | BattInf binf=new BattInf();
|
| | | binf.setFBSDeviceId(rs.getInt("dev_id"));
|
| | | binf.setStationName(rs.getString("stationName"));
|
| | | binf.setStationName3(rs.getString("stationName3"));
|
| | | list.add(binf);
|
| | | }
|