xml同一字段多数据查询

第一种方法：

<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>