mybatis批量插入但是数据库字段限制not null:
网上搜了一堆都是copy或者放个链接跳来跳去,不然就是一堆废话。自己解决了,上传一下。
<insert id="batchInsert" parameterType="java.util.List" useGeneratedKeys="true" keyProperty="id">
<foreach collection="list" item="item" separator=";">
INSERT INTO publication
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="item.id != null">
id,
</if>
<if test="item.doi != null">
doi,
</if>
<if test="item.title != null">
title,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="item.id != null">
#{item.id,jdbcType=INTEGER},
</if>
<if test="item.doi != null">
#{item.doi,jdbcType=VARCHAR},
</if>
<if test="item..title != null">
#{item..title,jdbcType=VARCHAR},
</if>
</trim>
</foreach>
</insert>