MyBatis批量插入

75 阅读1分钟
int batchSave(@Param("list")List<TestA> list);

    <insert id="batchSave" parameterType="TestA">
    insert into tA
    <trim prefix="(" suffix=")" suffixOverrides=",">
         name,
         age,
         number
    </trim>
    values
    <foreach collection="list" index="index" item="item" separator=",">
        (
        <trim suffixOverrides=",">
            #{item.name,jdbcType=VARCHAR},
            #{item.age,jdbcType=INTEGER},
            #{item.number,jdbcType=VARCHAR}
        </trim>
        )
    </foreach>
</insert>