mybatis实现批量插入list

mapper层接口

int insertToolRecordList(@Param(value = "recordList") List<ToolRecord> recordList);

xml文件sql

  <insert id="insertToolRecordList" parameterType="java.util.List">
        insert into tool_record (tool_id, sole_id, create_by, create_time)
        VALUES
        <foreach collection="recordList" item="record" index="index" separator=",">
            (#{record.toolId}, #{record.soleId}, #{record.createBy}, #{record.createTime})
        </foreach>
 </insert>