/[projects]/dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayerImplementation.java
ViewVC logotype

Diff of /dao/DaoAdresseService/src/main/java/dk/daoas/daoadresseservice/db/DatabaseLayerImplementation.java

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

revision 2822 by torben, Tue Jan 19 10:23:47 2016 UTC revision 2823 by torben, Tue Jan 19 10:44:24 2016 UTC
# Line 21  import dk.daoas.daoadresseservice.util.T Line 21  import dk.daoas.daoadresseservice.util.T
21    
22  public class DatabaseLayerImplementation implements DatabaseLayer {  public class DatabaseLayerImplementation implements DatabaseLayer {
23                    
24          static boolean DEBUG = false;          public static final boolean DEBUG = true;
25                    
26          @Override          @Override
27          public List<Address> getAllAdresses() throws SQLException {          public List<Address> getAllAdresses() throws SQLException {
# Line 32  public class DatabaseLayerImplementation Line 32  public class DatabaseLayerImplementation
32                  String sql =                  String sql =
33                                  "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, "
34                                  + "rutema,korelistema,ruteti,korelisteti,ruteon,korelisteon,ruteto,korelisteto,rutefr,korelistefr,rutelo,korelistelo,ruteso,korelisteso "                                  + "rutema,korelistema,ruteti,korelisteti,ruteon,korelisteon,ruteto,korelisteto,rutefr,korelistefr,rutelo,korelistelo,ruteso,korelisteso "
35                                  + "FROM fulddaekning.adressetabel "                                  + "FROM fulddaekning.adressetabel_beta "
36                                  + "WHERE gadeid IS NOT NULL "                                  + "WHERE gadeid IS NOT NULL "
37                                  + debugFilter                                  + debugFilter
38                                  ;                                  ;
Legend:
Removed from v.2822  
changed lines
  Added in v.2823
  ViewVC Help
Powered by ViewVC 1.1.20