<resultMap id="commissionRec" type="CommissionRec" >
<result property="sourceName" column="cmr_sourceName"/>
<result property="totalMoney" column="cmr_totalMoney"/>
<result property="totalCard" column="cmr_totalCard"/>
<result property="totalCommission" column="cmr_totalCommission"/>
<result property="commissionTimes" column="cmr_commissionTimes"/>
<result property="isProvided" column="cmr_isProvided"/>
<result property="userInfo.userId" column="us_userId"/>
<result property="userInfo.userName" column="us_userName"/>
<association property="memberCard" resultMap="memberCardTemplate" />
<!--
<association property="userInfo" resultMap="userInfo" />
-->
</resultMap>
--------------------------------------------------------------------------------------------------------------------------------------------------------
<resultMap id="userInfo" type="cn.sstech.member.marketing.model.base.BaseUserInfo" >
<id property="userId" column="us_userId"/>
<result property="userName" column="us_userName"/>
</resultMap>
--------------------------------------------------------------------------------------------------------------------------------------------------------
查询结果
如上图所示查询结果中,第一条和第二条只有us_userId是不重复的,而剩下的字段都被注入到CommissionRec对象中。这时
1.用association注入userInfo mybatis会因为数据一样而将前两条数据合为一个CommissionRec对象,us_userId则随便调一个注入到userInfo对象中
2.用 <result property="userInfo.userId" column="us_userId"/>这种制定具体字段名的方式注入,mybatis会因为记录数据有所不同而将前两条数据设为2个CommissionRec对象.
转载自:https://blog.csdn.net/wuyezhiyu/article/details/81364974