mybatis collection 关联查询多个参数

最新推荐文章于 2024-08-11 20:12:40 发布

王子様~

最新推荐文章于 2024-08-11 20:12:40 发布

阅读量6.3k

点赞数

分类专栏： Mybatis 文章标签： mybatis collect多个参数

本文链接：https://blog.csdn.net/qq_31424825/article/details/105593171

版权

Mybatis 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

mybatis collection 关联查询多个参数

column="{evtId=id,businessType=businessType1}" 描述：evtId是关联查询的参数，businessType也是。
id是resultMap的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>