循环遍历rs结果集存入Map集合

最新推荐文章于 2021-02-27 01:31:10 发布

李晓LOVE向阳

最新推荐文章于 2021-02-27 01:31:10 发布

阅读量4.1k

点赞数

本文链接：https://blog.csdn.net/u013310119/article/details/52183938

版权

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