271 |
Constants consts = Constants.getInstance(); |
Constants consts = Constants.getInstance(); |
272 |
|
|
273 |
//logger.info("Starting query"); |
//logger.info("Starting query"); |
274 |
ResultSet res = stmt.executeQuery(); |
try ( ResultSet res = stmt.executeQuery() ) { |
275 |
//logger.info("Starting exec query done"); |
|
|
|
|
|
while (res.next()) { |
|
|
|
|
|
double latitude = res.getDouble(7); |
|
|
double longitude = res.getDouble(8); |
|
|
|
|
|
|
|
|
Address adr = new Address(latitude,longitude); |
|
|
|
|
|
adr.id = res.getInt(1); |
|
|
adr.postnr = res.getShort(2); |
|
|
adr.vejnavn = vejnavnCache.getInstance( res.getString(3) ); |
|
|
adr.gadeid = res.getInt(4); |
|
|
adr.husnr = res.getShort(5); |
|
|
adr.husnrbogstav = husnrbogstavCache.getInstance( res.getString(6) ); |
|
|
//adr.latitude = res.getDouble(7); |
|
|
//adr.longitude = res.getDouble(8); |
|
|
adr.ruteMandag = ruteCache.getInstance( res.getString(9) ); |
|
|
adr.ho = res.getShort(10); |
|
|
|
|
|
list.add(adr); |
|
276 |
|
|
277 |
if (consts.doCheckHO() == true && adr.ho == 0) { |
while (res.next()) { |
278 |
System.out.println( "Mangler HO" ); |
|
279 |
System.out.println( adr ); |
double latitude = res.getDouble(7); |
280 |
System.exit(0); |
double longitude = res.getDouble(8); |
281 |
|
|
282 |
|
|
283 |
|
Address adr = new Address(latitude,longitude); |
284 |
|
|
285 |
|
adr.id = res.getInt(1); |
286 |
|
adr.postnr = res.getShort(2); |
287 |
|
adr.vejnavn = vejnavnCache.getInstance( res.getString(3) ); |
288 |
|
adr.gadeid = res.getInt(4); |
289 |
|
adr.husnr = res.getShort(5); |
290 |
|
adr.husnrbogstav = husnrbogstavCache.getInstance( res.getString(6) ); |
291 |
|
//adr.latitude = res.getDouble(7); |
292 |
|
//adr.longitude = res.getDouble(8); |
293 |
|
adr.ruteMandag = ruteCache.getInstance( res.getString(9) ); |
294 |
|
adr.ho = res.getShort(10); |
295 |
|
|
296 |
|
list.add(adr); |
297 |
|
|
298 |
|
if (consts.doCheckHO() == true && adr.ho == 0) { |
299 |
|
System.out.println( "Mangler HO" ); |
300 |
|
System.out.println( adr ); |
301 |
|
throw new RuntimeException("Mangler HO: "+ adr); |
302 |
|
} |
303 |
|
|
304 |
|
//logger.info( "Adress:" + adr); |
305 |
} |
} |
306 |
|
|
307 |
//logger.info( "Adress:" + adr); |
res.close(); |
308 |
|
stmt.close(); |
309 |
|
|
310 |
|
return list; |
311 |
} |
} |
|
|
|
|
res.close(); |
|
|
stmt.close(); |
|
|
|
|
|
return list; |
|
312 |
} |
} |
313 |
|
|
314 |
} |
} |