2020-11-27---插入返回主键

2020-11-27  本文已影响0人  李霖神谷

<insert id="batchInsert" parameterType="list" keyProperty="id" useGeneratedKeys="true">
insert into conditions_menu (menu_id, condition_id, related_file_count)
values
<foreach collection="list" item="item" index="index" open="" close="" separator=",">
(#{item.menuId,jdbcType=INTEGER}, #{item.conditionId,jdbcType=INTEGER}, #{item.relatedFileCount,jdbcType=INTEGER})
</foreach>
</insert>

上一篇 下一篇

猜你喜欢

热点阅读