mybatis批量插入

批量插入
可以判断字段是否为空，再进行插入.
插入的字段，可以根据传入的对象值进行判断.

<insert id="batchInsert" parameterType="java.util.List">
    insert into tbl_integral_youzan_coupon_verify_logs (
    <foreach item="log" collection="logs" index="index" open="("   separator="," close=")">
    <if test="index == 0">
      <if test="log.batchNo != null" >
        batch_no,
      </if>
      is_deleted, version, channel
      )
      </if>
    </foreach>
    values
    <foreach collection="logs" item="log" index="index" separator=",">
      (
        <if test="log.batchNo != null">
        #{log.batchNo,jdbcType=VARCHAR},
        </if>
        0,1, #{log.channel}
      )
    </foreach>
  </insert>

mapper.xml

int batchInsert(@Param("logs")List<IntegralYouzanCouponVerifyLogs> logs);