LiJun
2018-10-26 ad22ba26863980edd80a1f9adfebb8daba31d74d
gx_tieta/src/com/fgkj/dao/impl/BattMap_informationImpl.java
@@ -175,7 +175,7 @@
      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 (" +
@@ -202,6 +202,7 @@
                  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);