107 |
|
|
108 |
String sql = "INSERT IGNORE INTO fulddaekning.adressetabel " + |
String sql = "INSERT IGNORE INTO fulddaekning.adressetabel " + |
109 |
"(vejnavn,husnr,husnrbogstav,kommunekode,vejkode,postnr,gadeid,dbkbane,indlast,aendret,david,googlechecked," + |
"(vejnavn,husnr,husnrbogstav,kommunekode,vejkode,postnr,gadeid,dbkbane,indlast,aendret,david,googlechecked," + |
110 |
"RuteMa,KorelisteMa,RuteTi,KorelisteTi,RuteOn,KorelisteOn,RuteTo,KorelisteTo,RuteFr,KorelisteFr,RuteLo,KorelisteLo,RuteSo,KorelisteSo) " + |
"RuteMa,KorelisteMa,RuteTi,KorelisteTi,RuteOn,KorelisteOn,RuteTo,KorelisteTo,RuteFr,KorelisteFr,RuteLo,KorelisteLo,RuteSo,KorelisteSo, " + |
111 |
|
"kommentar,latitude,longitude) " + |
112 |
"VALUES " + |
"VALUES " + |
113 |
"(?,?,?,?,?,?,?,?, now(), now(), ?, 0, " + |
"(?,?,?,?,?,?,?,?, now(), now(), ?, 0, " + |
114 |
"?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; |
"?,?,?,?,?,?,?,?,?,?,?,?,?,?," + |
115 |
|
"?,?,?) "; |
116 |
|
|
117 |
|
|
118 |
try (Connection con = DBConnection.getConnection()) { |
try (Connection con = DBConnection.getConnection()) { |
147 |
stmt.setString(21, addr.korelisteLordag); |
stmt.setString(21, addr.korelisteLordag); |
148 |
stmt.setString(22, addr.ruteSondag); |
stmt.setString(22, addr.ruteSondag); |
149 |
stmt.setString(23, addr.korelisteSondag); |
stmt.setString(23, addr.korelisteSondag); |
150 |
|
|
151 |
|
stmt.setString(24, addr.kommentar); |
152 |
|
|
153 |
|
if (addr.latitude != 0.0) { |
154 |
|
stmt.setDouble(25, addr.latitude); |
155 |
|
} else { |
156 |
|
stmt.setNull(25, java.sql.Types.DOUBLE); |
157 |
|
} |
158 |
|
if (addr.longitude != 0.0) { |
159 |
|
stmt.setDouble(26, addr.longitude); |
160 |
|
} else { |
161 |
|
stmt.setNull(26, java.sql.Types.DOUBLE); |
162 |
|
} |
163 |
|
|
164 |
|
|
165 |
stmt.execute(); |
stmt.execute(); |