mybatis+oracle批量新增
2020-01-01 本文已影响0人
没见过的颜色
sql语句
INSERT ALL
into test_2020(id,name) values('1','1')
into test_2020(id,name) values('2','2')
into test_2020(id,name) values('3','3')
SELECT 1 FROM dual
myBatis映射文件 xxxxxmapper.xml
<insert id="batchCreateUser" parameterType="com.test.bean.userBean">
INSERT ALL
<foreach collection="list" item="obj" index="index" separator=" ">
into test_2020(id,name) values(#{obj.id},#{obj.name})
</foreach>
SELECT 1 FROM dual
</insert>
