67 |
DeduplicateHelper<String> vejnavnCache = new DeduplicateHelper<String>(81920); |
DeduplicateHelper<String> vejnavnCache = new DeduplicateHelper<String>(81920); |
68 |
DeduplicateHelper<String> husnrbogstavCache = new DeduplicateHelper<String>(); |
DeduplicateHelper<String> husnrbogstavCache = new DeduplicateHelper<String>(); |
69 |
DeduplicateHelper<String> distributorCache = new DeduplicateHelper<String>(); |
DeduplicateHelper<String> distributorCache = new DeduplicateHelper<String>(); |
70 |
DeduplicateHelper<String> dirigeringsCache = new DeduplicateHelper<String>(16*1024); |
DeduplicateHelper<String> dirigeringsCache = new DeduplicateHelper<String>(16*1024); |
71 |
|
|
72 |
|
DeduplicateHelper<String> baneCache = new DeduplicateHelper<String>(); |
73 |
|
|
74 |
|
|
75 |
while (res.next()) { |
while (res.next()) { |
84 |
a.postnr = (short)res.getInt(7); |
a.postnr = (short)res.getInt(7); |
85 |
a.gadeid = res.getInt(8); |
a.gadeid = res.getInt(8); |
86 |
a.distributor = distributorCache.getInstance(res.getString(9)); |
a.distributor = distributorCache.getInstance(res.getString(9)); |
87 |
a.dbkBane = (short) res.getInt(10); |
a.dbkBane = baneCache.getInstance(res.getString(10)); |
88 |
a.latitude = (float) res.getDouble(11); |
a.latitude = (float) res.getDouble(11); |
89 |
a.longitude = (float) res.getDouble(12); |
a.longitude = (float) res.getDouble(12); |
90 |
|
|
145 |
stmt.setShort(5, addr.vejkode); |
stmt.setShort(5, addr.vejkode); |
146 |
stmt.setShort(6, addr.postnr); |
stmt.setShort(6, addr.postnr); |
147 |
stmt.setInt(7, addr.gadeid); |
stmt.setInt(7, addr.gadeid); |
148 |
stmt.setShort(8, addr.dbkBane); |
stmt.setString(8, addr.dbkBane); |
149 |
stmt.setString(9, david); |
stmt.setString(9, david); |
150 |
|
|
151 |
stmt.setString(10, addr.ruteMandag); |
stmt.setString(10, addr.ruteMandag); |
226 |
stmt.setString(15, addr.korelisteSondag); |
stmt.setString(15, addr.korelisteSondag); |
227 |
|
|
228 |
stmt.setString(16, addr.distributor); |
stmt.setString(16, addr.distributor); |
229 |
stmt.setInt(17, addr.dbkBane); |
stmt.setString(17, addr.dbkBane); |
230 |
|
|
231 |
|
|
232 |
|
|