Mybatis使用selectMap返回结果集不是键值对形式＜K, V＞解决案

    
      select
      plan_detail_id as pwid_KEY,
      business_name as pwid_VALUE
      from
      plan_work_info_detail
      
          
              plan_schedule_id = #{planScheduleId}
          
      
    

import org.apache.ibatis.session.ResultContext;
import org.apache.ibatis.session.ResultHandler;
 
import java.util.HashMap;
import java.util.Map;
 
 
public class SelectMapKeyAndValue implements ResultHandler {

    private final HashMap mappedResults = new HashMap();
	@SuppressWarnings({ "rawtypes", "unchecked" })
    @Override
    public void handleResult(ResultContext context) {
        Map map = (Map) context.getResultObject();
        mappedResults.put(map.get("key"), map.get("value"));
    }

    public HashMap getMappedResults() {
        return mappedResults;
    }
}

调用自定义重写的ResultHandler

    public HashMap getDataMap() {
        try{
            SelectMapKeyAndValue handler = new SelectMapKeyAndValue();
            sqlSessionTemplate.select("selectPlanWorkInfoMap", handler);
            HashMap map = handler.getMappedResults();
            return map;
        }catch(Exception e){
           e.printStackTrace();
        }
    }

{AAA=00, BBB=00, CCC=00, DDD=00, EEE=00, FFF=00}