<pre name="code" class="java">Map<String,Object> map = new HashMap<String,Object>();
for (int j = 0;rs.next() ;j++) {
String startDate1 =rs.getString("year");
String currency = rs.getString("currency");
double amount = rs.getDouble("amount");
double huilv ;
if("CNY".equals(currency)){
huilv = 1.0;
}else{
huilv = MyTools.insatnce.getDouble("SELECT CNY FROM pmExchangeRate WHERE CURTYPE LIKE '"+currency+"%' AND WORKDATE = (SELECT max(workdate) from PMEXCHANGERATE WHERE CURTYPE LIKE '"+currency+"%')");
}
if(map.containsKey(startDate1)){
map.put(startDate1, Double.parseDouble(map.get(startDate1)+"")+amount*huilv);
}else{
map.put(startDate1, amount*huilv);
}
}
for (String key : map.keySet()) {
BaseFmFinanceContractExt vo=new BaseFmFinanceContractExt();
vo.setAmount(Double.parseDouble(map.get(key)+""));
vo.setStartDate(key);
vo.setConnectContract("");
list.add(vo);
}
循环遍历rs结果集存入Map集合
最新推荐文章于 2021-02-27 01:31:16 发布