<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>
网友评论