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);
请阅读后点赞,谢谢