不太会。总结一下....
<resultMap id="addressAndUser" type="AddressAndUser">
<result column="did" property="id"/>
<result column="addr" property="addr"/>
<result column="phone" property="phone"/>
<result column="postcode" property="postcode"/>
<result column="userId" property="userId"/>
<association property="user" column="userId" javaType="User"
select="com.tledu.MybatisTest.mapper.IUserMapper.getUserById2" fetchType="lazy"/>
</resultMap>
property="user"(实体类,下方代码看出,是addressAndUser类的属性,简单来说是匹配的类型,与collection对照可以理解)column="userId(匹配的属性的字段名,注解的另一种方法中on的条件,这里user_id as 为userId)" javaType="User"(匹配的类型,此为简写后,应为User实体类路径)
或者
<resultMap id="addressAndUser2" type="AddressAndUser">
<result column="did" property="id"/>
<association property="user" javaType="User" column="uid" autoMapping="true" resultMap="ass">
<result column="uid" property="id"/>
</association>
</resultMap>
<select id="getAddressAndUser" parameterType="Integer" resultMap="addressAndUser">
<!-- select-->
<!-- ad.id as did,-->
<!-- ad.addr,-->
<!-- ad.phone,-->
<!-- ad.postcode,-->
<!-- us.id as uid,-->
<!-- us.username,-->
<!-- us.password,-->
<!-- us.type,-->
<!-- us.nickname-->
<!-- from t_address ad-->
<!-- left join t_user us on ad.user_id=us.id-->
<!-- where ad.id=#{id}-->
select id,addr,postcode,phone,user_id as userId from t_address where id=#{id}
</select>
collection用法和上面差不要多,要注意的是:
id是resultMap以及Collection的子标签,标记出作为 ID 的结果可以帮助提高整体性能。特别注意的是,id是当前命名空间中的一个唯一标识,用于标识一个结果映射。
错误使用会导致只返回该订单某商品的一条记录。因为对于某个商品,麻辣味和五香味只是商品规格,其商品id是相同的。
原文链接:https://blog.csdn.net/LIZHONGPING00/article/details/109148269
而且他是ofType, association是Javatype
<resultMap id="userAndAddress2" type="UserAndAddress" >
<id property="id" column="id"/>
<result column="username" property="username"/>
<collection property="addressList" column="id" ofType="Address">
<result property="addr" column="addr"/>
<result property="postcode" column="postcode"/>
<result property="phone" column="phone"/>
</collection>
</resultMap>