批量插入数据

incomingInfoMapper.insertOperationWithProcessCode(operationNoList);

int insertOperationWithProcessCode(@Param("operationNoList") List<IcomItemOfPperationEntity> operationNoList);

<!--生成带工艺代码的作业流程单-->
<insert id="insertOperationWithProcessCode" parameterType="java.util.List">
    <foreach collection="operationNoList" item="item" index="index" separator=";">
        INSERT INTO ICOM_ITEM_OF_OPERATION
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="item.cid!= null">
                CID,
            </if>
            <if test="item.batchNo!= null">
                BATCH_NO,
            </if>
            <if test="item.operationNo != null">
                OPERATION_NUM,
            </if>
            <if test="item.process_manage_code!= null">
                PROCESS_MANAGE_CODE
            </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="item.cid!= null">
                #{item.cid},
            </if>
            <if test="item.batchNo!= null">
                #{item.batchNo},
            </if>
            <if test="item.operationNo != null">
                #{item.operationNo},
            </if>
            <if test="item.process_manage_code!= null">
                #{item.process_manage_code}
            </if>
        </trim>
    </foreach>
</insert>