/[projects]/dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java
ViewVC logotype

Diff of /dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 2206 by torben, Thu Sep 11 14:46:59 2014 UTC revision 2207 by torben, Thu Sep 11 16:42:08 2014 UTC
# Line 122  public class Database { Line 122  public class Database {
122                  return list;                  return list;
123          }          }
124    
125          public ArrayList<Adresse> hentDaekkedeAdresser( BoundingBox bbox) throws SQLException {          public Adresse[] hentDaekkedeAdresser( BoundingBox bbox) throws SQLException {
126                  String sql = "SELECT id,postnr,adresse,gadeid,husnr,husnrbogstav,latitude,longitude,rute " +                  String sql = "SELECT id,postnr,adresse,gadeid,husnr,husnrbogstav,latitude,longitude,rute " +
127                                  "FROM fulddaekning.adressetabel " +                                  "FROM fulddaekning.adressetabel " +
128                                  "WHERE rute IS NOT NULL " +                                  "WHERE rute IS NOT NULL " +
# Line 142  public class Database { Line 142  public class Database {
142                  stmt.setDouble(4, bbox.longitudeMax);                  stmt.setDouble(4, bbox.longitudeMax);
143                  stmt.setString(5, Lookup.distributor);                  stmt.setString(5, Lookup.distributor);
144    
145                  return hentAdresseListe( stmt );                  List<Adresse> list = hentAdresseListe( stmt );
146                    return list.toArray( new Adresse[ list.size() ] );
147    
148          }          }
149    
Legend:
Removed from v.2206  
changed lines
  Added in v.2207
  ViewVC Help
Powered by ViewVC 1.1.20