| | |
|---|
| | | int uid=page.getPageAll();
|
|---|
| | | Connection conn=DBUtil.getConn();
|
|---|
| | | String numberSql="SELECT FOUND_ROWS() number";//存放总数
|
|---|
| | | String sql="select SQL_CALC_FOUND_ROWS 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 SQL_CALC_FOUND_ROWS distinct tb_battmap_information.num,tb_battmap_information.StationId,tb_battmap_information.StationName,address,longitude,latitude,information,db_battinf.tb_battinf.FBSDeviceId,db_battinf.tb_battinf.station_install " +
|
|---|
| | | " 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 (" +
|
|---|
| | |
|---|
| | | " left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.stationid=db_battinf.tb_battinf.stationid " +
|
|---|
| | | " 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=? ) " +
|
|---|
| | | " where db_user.tb_user_inf.uid=? and tb_battinf.station_install=true) " +
|
|---|
| | | " 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() {
|
|---|
| | |
|---|
| | | binformation.setLatitude(rs.getDouble("latitude"));
|
|---|
| | | binformation.setInformation(rs.getString("information"));
|
|---|
| | | binformation.setFBSDeviceId(rs.getInt("fBSDeviceId"));
|
|---|
| | | binformation.setInformation(rs.getString("station_install"));
|
|---|
| | | Page p=new Page();
|
|---|
| | | binformation.setPage(p);
|
|---|
| | | list.add(binformation);
|
|---|
