92 |
"AND a.postnr=? " + |
"AND a.postnr=? " + |
93 |
"AND latitude IS NOT NULL " + |
"AND latitude IS NOT NULL " + |
94 |
"AND longitude IS NOT NULL " + |
"AND longitude IS NOT NULL " + |
95 |
"AND gadeid IS NOT NULL "; |
"AND gadeid IS NOT NULL " + |
96 |
|
"AND (a.distributor IS NULL OR a.distributor<>'LUKKET') "; |
97 |
PreparedStatement stmt = conn.prepareStatement(sql); |
PreparedStatement stmt = conn.prepareStatement(sql); |
98 |
stmt.setInt(1, postnr); |
stmt.setInt(1, postnr); |
99 |
|
|
109 |
|
|
110 |
String sql = "SELECT postnr " + |
String sql = "SELECT postnr " + |
111 |
"FROM fulddaekning.adressetabel " + |
"FROM fulddaekning.adressetabel " + |
|
//"WHERE distributor = ? and rute is not null " + |
|
112 |
"WHERE postnr BETWEEN ? AND ? " + |
"WHERE postnr BETWEEN ? AND ? " + |
113 |
|
"AND rute is null " + // Træk kun liste på postnumre hvor der er ikke-dækkede adresser |
114 |
"GROUP BY postnr " + |
"GROUP BY postnr " + |
115 |
"ORDER by postnr"; |
"ORDER by postnr"; |
116 |
PreparedStatement stmt = conn.prepareStatement(sql); |
PreparedStatement stmt = conn.prepareStatement(sql); |