/[projects]/dao/DaoAdresseVedligehold/src/main/java/dk/daoas/adressevedligehold/db/DatabaseCoverageUpdate.java
ViewVC logotype

Diff of /dao/DaoAdresseVedligehold/src/main/java/dk/daoas/adressevedligehold/db/DatabaseCoverageUpdate.java

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

revision 2840 by torben, Mon Jan 25 10:25:22 2016 UTC revision 2844 by torben, Mon Jan 25 21:43:59 2016 UTC
# Line 20  import dk.daoas.adressevedligehold.util. Line 20  import dk.daoas.adressevedligehold.util.
20    
21  public class DatabaseLayerImplementation  {  public class DatabaseLayerImplementation  {
22                    
23          static boolean DEBUG = false;          static boolean DEBUG = true;
24                    
25                    
26          public List<Address> getAllAdresses() throws SQLException {          public List<Address> getAllAdresses() throws SQLException {
27                  TimingHelper timing = new TimingHelper();                  TimingHelper timing = new TimingHelper();
28                                    
29                  String debugFilter = DatabaseLayerImplementation.DEBUG ? " WHERE postnr = 8700 " : "";                  String debugFilter = DatabaseLayerImplementation.DEBUG ? " WHERE postnr >= 6000 " : "";
30                                    
31                  String sql =                  String sql =
32                                  "SELECT id,vejnavn,husnr,husnrbogstav,kommunekode,vejkode,postnr,gadeid,upper(distributor) AS distributor,dbkbane,latitude,longitude, "                                  "SELECT id,vejnavn,husnr,husnrbogstav,kommunekode,vejkode,postnr,gadeid,upper(distributor) AS distributor,dbkbane,latitude,longitude, "
Legend:
Removed from v.2840  
changed lines
  Added in v.2844
  ViewVC Help
Powered by ViewVC 1.1.20