Mabitis结果集转map

需求：给定一组日期，查出每个日期所在范围内的周，并将数据与该日期组成map一同返回,key -> 日期，value -> week

MPST1001DAO.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >

<mapper namespace="com.faw_qm.erpcg.mps.mps.MPST1001.dao.MPST1001DAO">

    <resultMap id="mapResultLong" type="java.util.HashMap">
        <result property="key" column="k" javaType="string" jdbcType="VARCHAR"/>
        <result property="value" column="v" javaType="string" jdbcType="VARCHAR"/>
    </resultMap>

    <select id="getWeekMapByDate" resultMap="mapResultLong">
        <foreach item="item" index="index" collection="list"  separator=" union all " >
            SELECT
            #{item} AS k ,
            `week` v
            FROM
            `ompslaborcal`
            WHERE
            startDate <![CDATA[ <= ]]> #{item} AND endDate <![CDATA[ >= ]]>  #{item}
        </foreach>
    </select>
</mapper>

MPST1001DAO

@Mapper
@Repository
public interface MPST1001DAO {
    Map<String, String> getWeekMapByDate(@Param("list") Collection ids);
}

定义查询结果转换器
MapResultHandler

public class MapResultHandler implements ResultHandler {
    private final Map mappedResults = new HashMap();

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

    public Map getMappedResults() {
        return mappedResults;
    }
}

自定义SessionMapper，获取连接执行MPST1001DAO层方法，调用结果处理器处理结果
SessionMapper

@Repository
public class SessionMapper extends SqlSessionDaoSupport {

    @Resource
    public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory) {
        super.setSqlSessionFactory(sqlSessionFactory);
    }

    @SuppressWarnings("unchecked")
    public Map<String, String> getWeekMapByDate(Collection list) {
        MapResultHandler handler = new MapResultHandler();
        this.getSqlSession().select(MPST1001DAO.class.getName() + ".getWeekMapByDate", list, handler);
        Map<String, String> map = handler.getMappedResults();
        return map;
    }
}

注入SessionMapper之后调用

@Service
public class MPST1001ServiceImpl implements MPST1001Service {

    @Autowired
    private SessionMapper dao;

    @Override
    public String getWeekMapByDate(String str) {
        Map<String, String> houseMapByAreaId = dao.getWeekMapByDate(new ArrayList(Arrays.asList("2021-01-13", "2021-01-05")));
        return JSON.toJSONString(houseMapByAreaId);
    }
}