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); |