175 |
} |
} |
176 |
} |
} |
177 |
|
|
178 |
public static Map<Integer,HundredePctBean> get100PctList() throws SQLException { |
public static Map<Short,HundredePctBean> get100PctList() throws SQLException { |
179 |
String sql = "SELECT postnr,UPPER(distributor) as distributor,rute,koreliste,dbkbane " + |
String sql = "SELECT postnr,UPPER(distributor) as distributor,rute,koreliste,dbkbane " + |
180 |
"FROM bogleveringer.adresser_udenfor_daekning"; |
"FROM bogleveringer.adresser_udenfor_daekning"; |
181 |
|
|
184 |
) { |
) { |
185 |
ResultSet res = stmt.executeQuery(sql); |
ResultSet res = stmt.executeQuery(sql); |
186 |
|
|
187 |
Map<Integer,HundredePctBean> map = new HashMap<Integer,HundredePctBean>(); |
Map<Short, HundredePctBean> map = new HashMap<Short,HundredePctBean>(); |
188 |
|
|
189 |
DeduplicateHelper<String> distributorCache = new DeduplicateHelper<String>(); |
DeduplicateHelper<String> distributorCache = new DeduplicateHelper<String>(); |
190 |
|
|
192 |
|
|
193 |
|
|
194 |
HundredePctBean bean = new HundredePctBean(); |
HundredePctBean bean = new HundredePctBean(); |
195 |
bean.postnr = res.getInt(1); |
bean.postnr = (short) res.getInt(1); |
196 |
bean.distributor = distributorCache.getInstance(res.getString(2)); |
bean.distributor = distributorCache.getInstance(res.getString(2)); |
197 |
bean.rute = res.getString(3); |
bean.rute = res.getString(3); |
198 |
bean.koreliste = res.getString(4); |
bean.koreliste = res.getString(4); |