mapper中使用list作为参数实现批量插入

Mapper.java

public int insertBatch(@Param("customerChangeRecordList") List<CustomerChangeRecord> customerChangeRecordList);

mapper.xml

<insert id="insertBatch" parameterType="java.util.List">
  insert into cms_customer_change_record(customer_id,type,sys_user_id,content,create_time,create_by)
  VALUES
  <foreach collection="customerChangeRecordList" item="item" separator =",">
    <trim prefix="(" suffix=")" suffixOverrides=",">
      #{item.customerId},
      #{item.type},
      #{item.sysUserId},
      #{item.content},
      #{item.createTime},
      #{item.createBy},
    </trim>
  </foreach>
</insert>