81 |
list.add(a); |
list.add(a); |
82 |
} |
} |
83 |
res.close(); |
res.close(); |
|
stmt.close(); |
|
|
conn.close(); |
|
84 |
|
|
85 |
System.out.println("Loaded " + list.size() + " adresses"); |
System.out.println("Loaded " + list.size() + " adresses"); |
86 |
|
|
215 |
} |
} |
216 |
|
|
217 |
@Override |
@Override |
218 |
public void saveRequestLog(String brugerid, String postnr, String adresse, SearchResult result) throws SQLException { |
public void saveRequestLog(String brugerid, String postnr, String adresse, String omdelingsdag, SearchResult result) throws SQLException { |
219 |
String setVar = "set sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' "; |
String setVar = "set sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' "; |
220 |
|
|
221 |
String sql = "INSERT INTO logs.hentruteinformation (postnr,adresse,vejnavn,googlevejnavn,husnr,husnr_bogstav,etage,lejlighed,rest,brugerid,status, indlast) " + |
String sql = "INSERT INTO logs.hentruteinformation (postnr,adresse,vejnavn,googlevejnavn,husnr,husnr_bogstav,etage,lejlighed,rest,brugerid,status, OmdelingDag, indlast) " + |
222 |
"VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW() )"; |
"VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW() )"; |
223 |
|
|
224 |
|
|
225 |
|
|
240 |
stmt.setString( 7, result.splitResult.etage); |
stmt.setString( 7, result.splitResult.etage); |
241 |
stmt.setString( 8, result.splitResult.lejlighed); |
stmt.setString( 8, result.splitResult.lejlighed); |
242 |
stmt.setString( 9, result.splitResult.resten); |
stmt.setString( 9, result.splitResult.resten); |
243 |
stmt.setString(10, brugerid); |
stmt.setString(10, brugerid); |
244 |
stmt.setInt(11, getStatusInt(result.status) ); |
stmt.setInt(11, getStatusInt(result.status) ); |
245 |
|
stmt.setString(12, omdelingsdag); |
246 |
|
|
247 |
stmt.executeUpdate(); |
stmt.executeUpdate(); |
248 |
|
|