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); |