/[projects]/dao/DaoAdresseVedligehold/src/main/java/dk/daoas/adressevedligehold/db/DatabaseLayerImplementation.java |
Parent Directory | Revision Log | Patch
revision 2843 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, " |
|
ViewVC Help | |
Powered by ViewVC 1.1.20 |