mybatis-嵌套集合:
<collection property="goodsInfoList" javaType="java.util.ArrayList" ofType="xxxx.GoodsInfoEntity" select="selectGoods" column="id"/>
property:字段名
javaType:返回类型
ofType:list里面的类型
select:对应当前xml文件里面的查询
column:传入查询的字段数据
返回map
<select id="XXXXID" resultType="java.util.HashMap"> select boi.customerNum,boi.customerName from T1 suo inner join T2 boi on boi.id = suo.org_id where suo.user_id = #{userId} </select>
DAO:
List<Map<String, String>> selectOperatorMapByUserId(@Param("userId")String userId);
注意:这里返回的map数据是这样的:customerNum : 111
customerName:nana
并不是我原来以为的 customerNum-customerName
list<map> 转map:
List<Map> countMap = xxxx()
Map resultMap = countMap.stream().collect( Collectors.toMap(s->s.get("key"), s -> s.get("value")));