Mybatis中返回map集合---数据处理

1.mapper.xml

<select id=" queryCaseList " resultType="java.util.HashMap">
        SELECT a.TASK_DEF_KEY as name ,COUNT(1) as value
        FROM  ...
        <where>
          ...
        </where>
        GROUP BY name
</select>

2.mapper.java 用 List<Map<>> 接收

List<HashMap<String,Object>> queryCaseList(Case case);

3.得到数据

4.数据处理

public HashMap queryCaseList(){
	List<HashMap<String,Object>> taskCount = caseUrbanMapper.queryCaseList(Case case);
    //数据处理
    Map<String,String> res = new HashMap<>();
    for (Map<String, Object> map : taskCount) {
	    List list = new ArrayList();
    	//System.out.println(map.toString());
    	map.forEach((k,v)->{
			//System.out.println("key:"+k+">>>value:"+v);
    		list.add(v);
	    });
        res.put(list.get(0).toString(),list.get(1).toString());
     }
     return res;
}

5.结果

{	
	inspect=1, 
	specialityDept=1, 
	caseRegister=3, 
	closeCase=1, 
	caseVerify=1, 
	putOn=1, 
	toBeInspect=1
}