mybatis批量新增insert

<insert id="batchInsertTScriptPenetrationTypeRelation" parameterType="list">
        insert into t_script_penetration_type_relation
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="collection[0].id != null  and collection[0].id != ''">id,</if>
            <if test="collection[0].scriptId != null  and collection[0].scriptId != ''">script_id,</if>
            <if test="collection[0].penetrationTypeId != null  and collection[0].penetrationTypeId != ''">
                penetration_type_id,
            </if>
        </trim>
        values
        <foreach collection="list" item="typeRelation" separator=",">
            (
            <if test="typeRelation.id != null  and typeRelation.id != ''">#{typeRelation.id},</if>
            <if test="typeRelation.scriptId != null  and typeRelation.scriptId != ''">#{typeRelation.scriptId},</if>
            <if test="typeRelation.penetrationTypeId != null  and typeRelation.penetrationTypeId != ''">
                #{typeRelation.penetrationTypeId}
            </if>
            )
        </foreach>
    </insert>
  public int batchInsertTScriptPenetrationTypeRelation(List<TScriptPenetrationTypeRelation> scriptPenetrationTypeRelations);

 

posted @ 2021-07-12 15:12  小拐  阅读(141)  评论(0)    收藏  举报