XXXMapper.xml中嵌套查询

<resultMap id="LiveUserNocticeMap" type="com.fxkj.common.vo.LiveUserNocticeVo">

    <!-- 定义一些返回字段 -->

    <result column="platform_id" property="platformId" jdbcType="VARCHAR"/>

    <result column="user_id" property="userId" jdbcType="VARCHAR"/>

    <result column="notice_cover" property="noticeCover" jdbcType="VARCHAR"/>

    <result column="title" property="title" jdbcType="VARCHAR"/>

    <result column="introduce" property="introduce" jdbcType="VARCHAR"/>

    <result column="show_time" property="showTime" jdbcType="TIMESTAMP"/>

    <result column="end_time" property="endTime" jdbcType="TIMESTAMP"/>

    <!-- 调用方法返回数据赋值到该字段 -->

    <association property="isLike" column="{notice_id=notice_id,user_id=user_id}" select="com.fxkj.common.mapper.LiveUserNoticeMapper.findLiveUserNoticeLikeCount">

    </association>

  </resultMap>

 

<!-- 查询语句 --> 

<select id="findLiveUserNoticeLikeCount" parameterType="java.util.Map" resultType="java.lang.Integer">

    select count(*) from live_user_notice_data where notice_id = #{notice_id} and fans_id = #{user_id} and data_type = 2

  </select>