mybatis resultMap collection聚合String

背景

• 主表index_dict_data

• 內容表index_dict_cn_name

• 期望輸出數據結構:即聯表之后根據indexId聚合,然后將cnName字段聚合到一個List<String>中

  [    {        "indexId": "pageCrashNum",        "cnNames": ["崩潰數","崩潰數"]    },    {        "indexId": "pageCrashRate",        "cnNames": ["崩潰率","崩潰率"]    },    {        "indexId": "pageCrashUserNum",        "cnNames": ["崩潰用戶數","崩潰用戶數"]    }]

配置

mapper.xml

<resultMap  type="com.wf.indexmetrics.IndexMetricsDictionary">    <result column="indexId" property="indexId"/>    <collection property="cnNames" javaType="list" ofType="java.lang.String">        <!--雖然配置多個字段, 但是只會返回第一個, 但是聚合的時候會加入其他字段作為key-->        <result column="cnName"/>        <!--必須有唯一id, 否則對于相同的cnName為只保留一個-->        <result column="cnNameId"/>    </collection></resultMap><select  resultMap="dictMap">    select    tidd.index_id as indexId,    tidd.dimension as dimension,    cn.cn_name as cnName,    cn.id as cnNameId    FROM    index_dict_data tidd    LEFT JOIN index_dict_cn_name cn ON cn.index_id = tidd.index_id    <where>        and tidd.index_id in        <foreach collection="indexKeys" open="(" separator="," close=")" item="item">            #{item}        </foreach>    </where></select>

源碼解析

• org.apache.ibatis.executor.resultset.DefaultResultSetHandler#applyNestedResultMappings

private boolean applyNestedResultMappings(ResultSetWrapper rsw, ResultMap resultMap, MetaObject metaObject, String parentPrefix, CacheKey parentRowKey, boolean newObject) {    boolean foundValues = false;    for (ResultMapping resultMapping : resultMap.getPropertyResultMappings()) {        final String nestedResultMapId = resultMapping.getNestedResultMapId();        if (nestedResultMapId != null && resultMapping.getResultSet() == null) {            try {                final String columnPrefix = getColumnPrefix(parentPrefix, resultMapping);                final ResultMap nestedResultMap = getNestedResultMap(rsw.getResultSet(), nestedResultMapId, columnPrefix);                if (resultMapping.getColumnPrefix() == null) {                    // try to fill circular reference only when columnPrefix                    // is not specified for the nested result map (issue #215)                    Object ancestorObject = ancestorObjects.get(nestedResultMapId);                    if (ancestorObject != null) {                        if (newObject) {                            linkObjects(metaObject, resultMapping, ancestorObject); // issue #385                        }                        continue;                    }                }                // rowKey實際為-2048015495:-685734919:com.sf.dev.mapper.IndexMetricsDictNewMapper.mapper_resultMap[dictMap]_collection[cnNames]:cnName:崩潰率:cnNameId:1008                final CacheKey rowKey = createRowKey(nestedResultMap, rsw, columnPrefix);                // combinedKey實際為-381970743:-2436525477:com.sf.dev.mapper.IndexMetricsDictNewMapper.mapper_resultMap[dictMap]_collection[cnNames]:cnName:崩潰率:cnNameId:1008:-1750790558:-229051733:com.sf.dev.mapper.IndexMetricsDictNewMapper.dictMap:metricsKey:pageCrashRate:dimension:%                final CacheKey combinedKey = combineKeys(rowKey, parentRowKey);                // 此處通過combinedKey判斷是否已存在值, 如果只有cnName而沒有cnNameId就會判斷已存在, 在后面的邏輯就不會再加入到List                Object rowValue = nestedResultObjects.get(combinedKey);                boolean knownValue = rowValue != null;                instantiateCollectionPropertyIfAppropriate(resultMapping, metaObject); // mandatory                if (anyNotNullColumnHasValue(resultMapping, columnPrefix, rsw)) {                    rowValue = getRowValue(rsw, nestedResultMap, combinedKey, columnPrefix, rowValue);                    if (rowValue != null && !knownValue) {                        // 把cnName add到List                        linkObjects(metaObject, resultMapping, rowValue);                        foundValues = true;                    }                }            } catch (SQLException e) {                throw new ExecutorException("Error getting nested result map values for '" + resultMapping.getProperty() + "'.  Cause: " + e, e);            }        }    }    return foundValues;}

問題

• 起初沒有配置cnNameId,保持唯一性,導致相同的cnName只保留了1個,實際應該保留2個

參考

• Mybatis resultMap 嵌套集合

• mybatis 結果映射 collection oftype為string,integer等類型