第一种方法:
<select id="selectDeptOrderCgAmountTwoMapper" resultMap="BaseResultMap" parameterType="java.lang.Long" >
select
<include refid="Base_Column_List" />
from tb_dept_order_cent
where 1=1
<if test="curIds !=null and curIds.size()>0">
and curId in
<foreach collection="list" separator="," item="item">
#{goods_code, jdbcType=VARCHAR}
</foreach>
</if>
</select>
第二种方法:
<select id="selectDeptOrderCgAmountTwoMapper" resultMap="BaseResultMap" parameterType="java.lang.Long" >
select
<include refid="Base_Column_List" />
from tb_dept_order_cent
where 1=1 and
<if test="curIds !=null ">
FIND_IN_SET(goods_code,#{curIds,jdbcType=VARCHAR})
</if>
</select>