我在开发中遇到一个需求,通过读取Excel到数据库中,获取全部数据的总和。
List<Map<String, String>> result = new ArrayList<Map<String, String>>();
List<Map<String, Object>> allresult = new ArrayList<Map<String, Object>>();
Map<String, Object> result1=new HashMap<String, Object>();
for(Map<String, String> map:result){
for(String key:map.keySet()){
Long value = Long.parseLong(map.get(key));
if(result1.containsKey(key)){
Long temp = Long.parseLong(result1.get(key).toString());
value +=temp;
}
result1.put(key, value);
}
}
allresult.add(result1);