sql 批量

<select id="selectCode" resultType="java.lang.String">
   SELECT group_concat(goods_property_value) FROM
   baymax.goods_property_value
   <where>
      <foreach collection="codes" item="code" open="no IN(" close=")"
         separator=",">
         #{code}
      </foreach>
   </where>
</select>

<insert id="addProductIntegral" parameterType="com.junfunsoft.baymax.server.dao.dto.OrderProductIntegral">
  insert INTO baymax.order_product_integral(order_product_id,order_integral_id,product_integral_id,integral_product_quantity)
  VALUES <foreach collection="integrals" index="index" item="item" open="("
                  separator="),(" close=")">
  #{item.orderProductId,jdbcType=BIGINT},
  #{item.orderIntegralId,jdbcType=BIGINT},
  #{item.productIntegralId,jdbcType=BIGINT},
  #{item.integralProductQuantity,jdbcType=INTEGER}
</foreach>
</insert>