mybatis批量插入数据

来源:互联网 发布:什么是网络存储 编辑:程序博客网 时间:2024/06/06 00:24
<insert id="addTrainRecordBatch" useGeneratedKeys="true" parameterType="java.util.List">      <selectKey resultType="long" keyProperty="id" order="AFTER">          SELECT          LAST_INSERT_ID()      </selectKey>      insert into t_train_record (add_time,emp_id,activity_id,flag)       values      <foreach collection="list" item="item" index="index" separator="," >          (#{item.addTime},#{item.empId},#{item.activityId},#{item.flag})      </foreach>  </insert>  
0 0
原创粉丝点击