我要评论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>总结
以上为个人经验，希望能给大家一个参考，也希望大家多多支持代码网。
发表评论