21 |
|
|
22 |
public class DatabaseLayerImplementation implements DatabaseLayer { |
public class DatabaseLayerImplementation implements DatabaseLayer { |
23 |
|
|
24 |
static boolean DEBUG = false; |
public static final boolean DEBUG = false; |
25 |
|
|
26 |
@Override |
@Override |
27 |
public List<Address> getAllAdresses() throws SQLException { |
public List<Address> getAllAdresses() throws SQLException { |
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 |
; |
; |