191 |
Map<Short, HundredePctBean> map = new HashMap<Short,HundredePctBean>(); |
Map<Short, HundredePctBean> map = new HashMap<Short,HundredePctBean>(); |
192 |
|
|
193 |
DeduplicateHelper<String> distributorCache = new DeduplicateHelper<String>(); |
DeduplicateHelper<String> distributorCache = new DeduplicateHelper<String>(); |
194 |
|
DeduplicateHelper<String> ruteCache = new DeduplicateHelper<String>(); |
195 |
|
DeduplicateHelper<String> korelisteCache = new DeduplicateHelper<String>(); |
196 |
|
|
197 |
while (res.next()) { |
while (res.next()) { |
198 |
|
|
200 |
HundredePctBean bean = new HundredePctBean(); |
HundredePctBean bean = new HundredePctBean(); |
201 |
bean.postnr = (short) res.getInt(1); |
bean.postnr = (short) res.getInt(1); |
202 |
bean.distributor = distributorCache.getInstance(res.getString(2)); |
bean.distributor = distributorCache.getInstance(res.getString(2)); |
203 |
bean.rute = res.getString(3); |
bean.rute = ruteCache.getInstance( res.getString(3) ); |
204 |
bean.koreliste = res.getString(4); |
bean.koreliste = korelisteCache.getInstance(res.getString(4) ); |
205 |
bean.dbkBane = (short)res.getInt(5); |
bean.dbkBane = (short)res.getInt(5); |
206 |
|
|
207 |
map.put(bean.postnr, bean); |
map.put(bean.postnr, bean); |
220 |
public void saveRequestLog(String brugerid, String postnr, String adresse, String omdelingsdag, SearchResult result) throws SQLException { |
public void saveRequestLog(String brugerid, String postnr, String adresse, String omdelingsdag, SearchResult result) throws SQLException { |
221 |
String setVar = "set sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' "; |
String setVar = "set sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' "; |
222 |
|
|
223 |
String sql = "INSERT INTO logs.hentruteinformation (postnr,adresse,vejnavn,googlevejnavn,husnr,husnr_bogstav,etage,lejlighed,rest,brugerid,status, omdelingsdag, indlast) " + |
String sql = "INSERT INTO logs.hentruteinformation (postnr,adresse,vejnavn,googlevejnavn,husnr,husnr_bogstav,etage,lejlighed,rest,brugerid,status, OmdelingDag, indlast) " + |
224 |
"VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW() )"; |
"VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW() )"; |
225 |
|
|
226 |
|
|
242 |
stmt.setString( 7, result.splitResult.etage); |
stmt.setString( 7, result.splitResult.etage); |
243 |
stmt.setString( 8, result.splitResult.lejlighed); |
stmt.setString( 8, result.splitResult.lejlighed); |
244 |
stmt.setString( 9, result.splitResult.resten); |
stmt.setString( 9, result.splitResult.resten); |
245 |
stmt.setString(10, brugerid); |
stmt.setString(10, brugerid); |
246 |
stmt.setString(11, omdelingsdag); |
stmt.setInt(11, getStatusInt(result.status) ); |
247 |
stmt.setInt(12, getStatusInt(result.status) ); |
stmt.setString(12, omdelingsdag); |
248 |
|
|
249 |
stmt.executeUpdate(); |
stmt.executeUpdate(); |
250 |
|
|