8,028
社区成员
发帖
与我相关
我的任务
分享
<insert id="insertBatch" >
insert into table(id, task_id, coupon_id,
user_id, expire_time, create_time,
update_time, is_deleted) values
<foreach collection="list" item="item" index="index" separator="," >
(#{item.id,jdbcType=INTEGER}, #{item.taskId,jdbcType=INTEGER}, #{item.couponId,jdbcType=INTEGER},
#{item.userId,jdbcType=INTEGER}, #{item.expireTime,jdbcType=TIMESTAMP}, #{item.createTime,jdbcType=TIMESTAMP},
#{item.updateTime,jdbcType=TIMESTAMP}, #{item.isDeleted,jdbcType=TINYINT})
</foreach>
</insert>