| | |
|---|
| | | //9.1查询已经添加物理信息的机房(用户管理的)
|
|---|
| | | public List serchInBattMapByUid(Object obj) {
|
|---|
| | | User_inf uinf=(User_inf) obj;
|
|---|
| | | String sql="select tb_battmap_information.num,tb_battmap_information.StationId,tb_battmap_information.StationName,address,longitude,latitude,information,db_battinf.tb_battinf.FBSDeviceId " +
|
|---|
| | | 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 " +
|
|---|
| | | " 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 (" +
|
|---|
| | |
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binformation.getStationId()}, new BattMap_informationImpl());
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | //地图上根据机房名称查询经纬度
|
|---|
| | | public List serchTudeByStationName(Object obj){
|
|---|
| | | BattMap_information binformation=(BattMap_information) obj;
|
|---|
| | | String sql="select num, StationId,StationName,address,longitude,latitude,information from web_site.tb_battmap_information " +
|
|---|
| | | " where StationName like ?";
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binformation.getStationName()}, new BattMap_informationImpl());
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | public static void main(String[] args) {
|
|---|
| | | BattMap_informationImpl bimpl=new BattMap_informationImpl();
|
|---|
| | | Batt_Maint_Dealarm bmd=new Batt_Maint_Dealarm();
|
|---|
