mybatis 完美内嵌循环多参数传递
column="{disp_pri_order = disp_pri_order,region_cd=region_cd}"
可实现完美多参内嵌循环传递
select disp_pri_order seq_shop_num,#{region_cd} as region_cd
from tableA
</select>
<resultMap id="categoryGroupInfo" type="cn.com.ToCGrp">
<result property="disp_pri_order" column="disp_pri_order" />
<result property="region_cd" column="region_cd" />
<collection property="brandSuggestionList" select="selectSuggestionBrands" javaType="java.util.ArrayList" column="{disp_pri_order = disp_pri_order,region_cd=region_cd}" ofType="cn.com.ocj.display.domain.original.ToContent" />
</resultMap>
<select id="selectSuggestionBrands" parameterType="java.util.Map" resultMap="contentInfo">
select * from tabB where seq_temp_corner_num=301 and seq_temp_corner_tgt_num =421 and region_cd=#{region_cd}
and set_num=#{disp_pri_order}
</select>
