MyBatis List

2018-09-29  本文已影响0人  她是过来佛

1.首先xml没有配置resultMap

    <select id="selectappointTms" parameterType="com.ccblife.cccp.co.business.pojo.req.QueryAppointmentListReq" resultType="java.util.HashMap">
        SELECT
          a1.POLICY_NO as contNo,
          COUNT(a1.POLICY_NO) as times
        FROM
              T_APPOINTMENT a1
        WHERE a1.POLICY_NO in
            (
                ......
            )
        GROUP BY
            a1.POLICY_NO

2.mapper.java中,map的value泛型为Object

    @Repository
    public interface TAppoinTmentMapper extends BaseMapper<TAppoinTment> {
        List<HashMap<String, Object>> selectappointTms (QueryAppointmentListReq req);
    }

3.在java类中,转换成map代码如

    List<HashMap<String, Object>> hashMapList = mapper.selectappointTms(req);
    HashMap<String, Object> resultMap = new HashMap<String, Object>();
    for (Map<String, Object> map : hashMapList) {
        String contNo = null;
        Integer times = null;
        for (Map.Entry<String, Object> entry : map.entrySet()) {
            if ("CONTNO".equals(entry.getKey())) {
                contNo =  entry.getValue() + "";
            }else if ("TIMES".equals(entry.getKey())) {
                //没有配置resultMap,默认的数字类型是BigDecimal,不知直接用Integer强转
                times = ((java.math.BigDecimal) entry.getValue()).intValue();
            }
        }
        resultMap.put(contNo, times);
    }
    for(QueryAppointmentListResp resp : resps){
        resp.setAppointTms(resultMap.get(resp.getContNo()) + "");
    }