| | |
|---|
| | | //9.1查询已经添加物理信息的机房(用户管理的，3.根据具体id查询告警信息等)
|
|---|
| | | public List serchInBattMapByUid3(Object obj) {
|
|---|
| | | BattMap_information binfor=(BattMap_information) obj;
|
|---|
| | | String sql="select distinct tb_battmap_information.num,tb_battmap_information.StationId,tb_battmap_information.StationName,address,longitude,latitude,information,db_battinf.tb_battinf.FBSDeviceId,tb_battinf.stationName1,tb_battinf.stationName2,tb_battinf.stationName3 " +
|
|---|
| | | String sql="select distinct tb_battmap_information.num,tb_battmap_information.StationId,tb_battmap_information.StationName,address,longitude,latitude,information,db_battinf.tb_battinf.FBSDeviceId,tb_battinf.stationName1,tb_battinf.stationName2,tb_battinf.stationName3,tb_battinf.stationName5 " +
|
|---|
| | | " from web_site.tb_battmap_information,db_battinf.tb_battinf " +
|
|---|
| | | " where tb_battmap_information.StationId=db_battinf.tb_battinf.StationId " +
|
|---|
| | | " and tb_battmap_information.StationId in (" +
|
|---|
| | |
|---|
| | | binformation.setStationName1(rs.getString("stationName1"));
|
|---|
| | | binformation.setStationName2(rs.getString("stationName2"));
|
|---|
| | | binformation.setStationName3(rs.getString("stationName3"));
|
|---|
| | | binformation.setStationName5(rs.getString("stationName5"));
|
|---|
| | | binformation.setAddress(rs.getString("address"));
|
|---|
| | | binformation.setLongitude(rs.getDouble("longitude"));
|
|---|
| | | binformation.setLatitude(rs.getDouble("latitude"));
|
|---|
