206 |
/*String sql = "INSERT INTO fulddaekning.afstand_anden_rute_thn (orgId,orgPostnr, orgVejnavn,orgGadeid,orgHusnr,orgHusnrBogstav,orgLatitude,orgLongitude,orgRute,id,postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,rute,afstand,`timestamp`) "+ |
/*String sql = "INSERT INTO fulddaekning.afstand_anden_rute_thn (orgId,orgPostnr, orgVejnavn,orgGadeid,orgHusnr,orgHusnrBogstav,orgLatitude,orgLongitude,orgRute,id,postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,rute,afstand,`timestamp`) "+ |
207 |
"VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, now() )"; |
"VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, now() )"; |
208 |
|
|
209 |
|
|
210 |
PreparedStatement saveStmt = conn.prepareStatement(sql);*/ |
PreparedStatement saveStmt = conn.prepareStatement(sql);*/ |
211 |
|
|
212 |
saveStmt.setInt(1, orgAdresse.id); |
saveStmt.setInt(1, orgAdresse.id); |
249 |
|
|
250 |
protected ArrayList<Adresse> hentAdresseListe(PreparedStatement stmt) throws SQLException{ |
protected ArrayList<Adresse> hentAdresseListe(PreparedStatement stmt) throws SQLException{ |
251 |
ArrayList<Adresse> list = new ArrayList<Adresse>( 1000000 ); |
ArrayList<Adresse> list = new ArrayList<Adresse>( 1000000 ); |
252 |
|
|
253 |
|
Constants consts = Constants.getInstance(); |
254 |
|
|
255 |
//logger.info("Starting query"); |
//logger.info("Starting query"); |
256 |
ResultSet res = stmt.executeQuery(); |
ResultSet res = stmt.executeQuery(); |
277 |
|
|
278 |
list.add(adr); |
list.add(adr); |
279 |
|
|
280 |
|
if (consts.doCheckHO() == true && adr.ho == 0) { |
281 |
|
System.out.println( "Mangler HO" ); |
282 |
|
System.out.println( adr ); |
283 |
|
System.exit(0); |
284 |
|
} |
285 |
|
|
286 |
//logger.info( "Adress:" + adr); |
//logger.info( "Adress:" + adr); |
287 |
} |
} |
288 |
|
|