Springboot+Mybatis批量导入多条数据

来源:互联网 发布:搞笑一家人知乎 编辑:程序博客网 时间:2024/05/22 02:15

在Mapper.xml最下面填写

 1 <!-- 批量插入生成的兑换码 --> 2      <insert id ="insertCodeBatch" parameterType="java.util.List" > 3             <selectKey resultType ="java.lang.Integer" keyProperty= "id" 4                  order= "AFTER"> 5                 SELECT LAST_INSERT_ID() 6             </selectKey > 7            insert into redeem_code 8            (bach_id, code, type, facevalue,create_user,create_time) 9            values10             <foreach collection ="list" item="reddemCode" index= "index" separator =",">11                 (12                 #{reddemCode.batchId}, #{reddemCode.code},13                 #{reddemCode.type},14                 #{reddemCode.facevalue},15                 #{reddemCode.createUser}, #{reddemCode.createTime}16                 )17             </foreach >18      </insert >
原创粉丝点击