| | |
|---|
| | | " left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
|
|---|
| | | " left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +
|
|---|
| | | " where db_user.tb_user_inf.uid=? ) " +
|
|---|
| | | " limit ?,? " +
|
|---|
| | | " order by tb_battmap_information.StationId ";
|
|---|
| | | " order by tb_battmap_information.StationId "+
|
|---|
| | | " limit ?,? " ;
|
|---|
| | | List<BattMap_information> list=DAOHelper.executeQueryLimit(sql, conn,new Object[]{uid,(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | |
|---|
| | | //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 " +
|
|---|
| | | 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, " +
|
|---|
| | | " 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.setNum(rs.getInt("num"));
|
|---|
| | | binformation.setStationId(rs.getString("stationId"));
|
|---|
| | | binformation.setStationName(rs.getString("stationName"));
|
|---|
| | | binformation.setStationName1(rs.getString("stationName1"));
|
|---|
| | | binformation.setStationName2(rs.getString("stationName2"));
|
|---|
| | | binformation.setStationName3(rs.getString("stationName3"));
|
|---|
| | | binformation.setAddress(rs.getString("address"));
|
|---|
| | | binformation.setLongitude(rs.getDouble("longitude"));
|
|---|
| | | binformation.setLatitude(rs.getDouble("latitude"));
|
|---|
