<insert id="batchInsertJob" parameterType="java.util.List">
insert into job
(job_id,uid,start_time,`count`,is_deleted,`user_reason`,`is_permitted`,`question_id`)
values
<foreach collection="list" item="item" index="index" separator=",">
(
#{item.jobId},
#{item.uid},
#{item.startTime},
#{item.count},
#{item.isDeleted},
#{item.userReason},
#{item.isPermitted},
#{item.questionId}
)
</foreach>
</insert>
mybatis 批量插入写法
最新推荐文章于 2024-04-13 21:32:22 发布