<resultMap id="QueryMonthPageVO" type="com.wx.cspl.mip.model.vo.SuperviseTaskMonthReportVO">
        <result column="id" property="id"/>
        <result column="orgseq" property="orgSeq"/>
        <result column="yearParticular" property="year"/>
        <result column="monthParticular" property="month"/>
        <result column="task_name" property="taskName"/>
        <result column="report" property="monthDetail"/>
        <result column="complete_status" property="finishCode"/>
        <result column="finish_rate" property="progressBar"/>
        <result column="question" property="question"/>
        <result column="measures" property="measures"/>
        <result column="update_time" property="updateTime"/>
        <result column="year_plan_id" property="yearPlanId"/>
        <result column="season" property="season"/>
        <!-- 級聯(lián)查詢季度 -->
        <association property="quarterTarget" column="{yearPlanId= year_plan_id, season = season}"
                     select="com.wx.cspl.mip.dao.QuarterMapper.getQuarter" />
    </resultMap>

其中
<association property="quarterTarget" column="{yearPlanId= year_plan_id, season = season}"
select="com.wx.cspl.mip.dao.QuarterMapper.getQuarter" />
以key:value的形式傳遞值

value = year_plan_id與value = season對應(yīng)resultMap里面的column字段 <result column="year_plan_id" property="yearPlanId"/>
<result column="season" property="season"/>

以map的形式傳值

/** 根據(jù)yearPlanId與Season查詢季度目標 */
    Quarter getQuarter(Map<String,Object> map);

year_plan_id = #{yearPlanId} and season = #{season}
#{yearPlanId}與#{season} 對應(yīng)map的key
parameterType="java.util.Map"
注意參數(shù)類型為map

<!-- 根據(jù)yearPlanId與Season查詢季度目標 -->
    <select id="getQuarter" resultType="com.wx.cspl.mip.model.entity.Quarter" parameterType="java.util.Map">
      select * from t_quarter where year_plan_id = #{yearPlanId} and season = #{season}
    </select>