101 |
"FROM fulddaekning.adressetabel a " + |
"FROM fulddaekning.adressetabel a " + |
102 |
"LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + |
"LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + |
103 |
"WHERE rute IS NULL " + //Ingen dækning |
"WHERE rute IS NULL " + //Ingen dækning |
104 |
//"AND a.postnr BETWEEN ? AND ? " + |
"AND a.postnr BETWEEN ? AND ? " + |
|
"AND a.postnr BETWEEN 8000 and 8600 " + |
|
|
//"AND a.postnr BETWEEN 9000 AND 9300 " + |
|
105 |
"AND latitude IS NOT NULL " + |
"AND latitude IS NOT NULL " + |
106 |
"AND longitude IS NOT NULL " + |
"AND longitude IS NOT NULL " + |
107 |
"AND gadeid IS NOT NULL " + |
"AND gadeid IS NOT NULL " + |
108 |
"AND (a.distributor IS NULL OR a.distributor<>'LUKKET') " + |
"AND (a.distributor IS NULL OR a.distributor<>'LUKKET') " |
109 |
"LIMIT 2500"; |
//"LIMIT 2500" |
110 |
|
; |
111 |
PreparedStatement stmt = conn.prepareStatement(sql); |
PreparedStatement stmt = conn.prepareStatement(sql); |
112 |
//stmt.setInt(1, minPostnr); |
stmt.setInt(1, minPostnr); |
113 |
//stmt.setInt(2, maxPostnr); |
stmt.setInt(2, maxPostnr); |
114 |
|
|
115 |
List<Adresse> list = hentAdresseListe( stmt ); |
List<Adresse> list = hentAdresseListe( stmt ); |
116 |
alleIkkeDaekkede = list.toArray( new Adresse[ list.size() ] ); |
alleIkkeDaekkede = list.toArray( new Adresse[ list.size() ] ); |