mybatis 完美内嵌循环多参数传递

column="{disp_pri_order=disp_pri_order,region_cd=region_cd}"

可实现完美多参内嵌循环传递

引用
<select id="selectCategoryGroups" parameterType="java.util.Map"  resultMap="categoryGroupInfo">

selectdisp_pri_orderseq_shop_num,#{region_cd}asregion_cd

fromtableA

</select>

<resultMapid="categoryGroupInfo"type="cn.com.ToCGrp">

<resultproperty="disp_pri_order"column="disp_pri_order"/>

<resultproperty="region_cd"column="region_cd"/>

<collectionproperty="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>

<selectid="selectSuggestionBrands"parameterType="java.util.Map"resultMap="contentInfo">

select*fromtabBwhereseq_temp_corner_num=301andseq_temp_corner_tgt_num=421andregion_cd=#{region_cd}

andset_num=#{disp_pri_order}

</select>

相关推荐