mybatis collection 关联查询多个参数

  • column="{evtId=id,businessType=businessType1}" 描述:evtId是关联查询的参数,businessType也是。
    idresultMap的id,businessType1也是如此
    在这里插入图片描述
       <resultMap id="BaseResultMap" type="com.kingdom.kdum.event.vo.event.EvtToDoListVO">
        <id column="id" jdbcType="BIGINT" property="id" />
        <result column="businessType1" jdbcType="INTEGER" />
        <result column="businessType2" jdbcType="INTEGER" />
        <collection property="annexeBeforeList" ofType="com.kingdom.kdum.event.mapper.read.event.EvtAnnexeReadMapper"
                    column="{evtId=id,businessType=businessType1}"
                    select="com.kingdom.kdum.event.mapper.read.event.EvtAnnexeReadMapper.findEventPicByEventIdAndBsType">
        </collection>
        <collection property="annexeAfterList" ofType="com.kingdom.kdum.event.mapper.read.event.EvtAnnexeReadMapper"
                    column="{evtId=id,businessType=businessType2}"
                    select="com.kingdom.kdum.event.mapper.read.event.EvtAnnexeReadMapper.findEventPicByEventIdAndBsType">
        </collection>
    </resultMap>
  • 查询:
       <select id="findEventDetailInfo" resultMap="BaseResultMap" parameterType="java.lang.Long">
          SELECT
          <include refid="Base_Column_List"/>,1 as businessType1,2 as businessType2
          FROM
          evt_t_event e
          where e.id = #{id,jdbcType=BIGINT} AND e.db_status = 1
       </select>
    
Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐