50 |
public Database(SafeProperties conf) throws SQLException,IOException { |
public Database(SafeProperties conf) throws SQLException,IOException { |
51 |
this.conn = getConnection( conf ); |
this.conn = getConnection( conf ); |
52 |
|
|
53 |
String sql = "INSERT INTO fulddaekning.afstand_anden_rute_ny (orgId,orgPostnr, orgAdresse,orgGadeid,orgHusnr,orgHusnrBogstav,orgLatitude,orgLongitude,orgRute,id,postnr,adresse,gadeid,husnr,husnrbogstav,latitude,longitude,rute,afstand,`timestamp`) "+ |
String sql = "INSERT INTO fulddaekning.afstand_anden_rute_ny (orgId,orgPostnr, orgAdresse,orgGadeid,orgHusnr,orgHusnrBogstav,orgRute,id,postnr,adresse,gadeid,husnr,husnrbogstav,rute,afstand,`timestamp`) "+ |
54 |
"VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, now() )"; |
"VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, now() )"; |
55 |
|
|
56 |
saveStmt = conn.prepareStatement(sql); |
saveStmt = conn.prepareStatement(sql); |
57 |
|
|
202 |
saveStmt.setInt(4, orgAdresse.gadeid); |
saveStmt.setInt(4, orgAdresse.gadeid); |
203 |
saveStmt.setShort(5, orgAdresse.husnr); |
saveStmt.setShort(5, orgAdresse.husnr); |
204 |
saveStmt.setString(6, orgAdresse.husnrbogstav); |
saveStmt.setString(6, orgAdresse.husnrbogstav); |
205 |
saveStmt.setDouble(7, orgAdresse.latitude); |
saveStmt.setString(7, orgAdresse.rute); |
206 |
saveStmt.setDouble(8, orgAdresse.longitude); |
|
207 |
saveStmt.setString(9, orgAdresse.rute); |
|
208 |
|
saveStmt.setInt(8, bedsteAdresse.id); |
209 |
|
saveStmt.setShort(9, bedsteAdresse.postnr); |
210 |
saveStmt.setInt(10, bedsteAdresse.id); |
saveStmt.setString(10, bedsteAdresse.adresse); |
211 |
saveStmt.setShort(11, bedsteAdresse.postnr); |
saveStmt.setInt(11, bedsteAdresse.gadeid); |
212 |
saveStmt.setString(12, bedsteAdresse.adresse); |
saveStmt.setShort(12, bedsteAdresse.husnr); |
213 |
saveStmt.setInt(13, bedsteAdresse.gadeid); |
saveStmt.setString(13, bedsteAdresse.husnrbogstav); |
214 |
saveStmt.setShort(14, bedsteAdresse.husnr); |
saveStmt.setString(14, bedsteAdresse.rute); |
|
saveStmt.setString(15, bedsteAdresse.husnrbogstav); |
|
|
saveStmt.setDouble(16, bedsteAdresse.latitude); |
|
|
saveStmt.setDouble(17, bedsteAdresse.longitude); |
|
|
saveStmt.setString(18, bedsteAdresse.rute); |
|
215 |
|
|
216 |
saveStmt.setDouble(19, bedsteAfstand); |
saveStmt.setDouble(15, bedsteAfstand); |
217 |
|
|
218 |
saveStmt.addBatch(); |
saveStmt.addBatch(); |
219 |
batchCount++; |
batchCount++; |