批量插入返回主键

最新推荐文章于 2024-05-09 18:30:53 发布

weixin_33898876

最新推荐文章于 2024-05-09 18:30:53 发布

阅读量1.5k

点赞数

文章标签：数据库 java python

原文链接：https://my.oschina.net/whatwhy/blog/3020584

版权

2019独角兽企业重金招聘Python工程师标准>>>

要将mybatis升到3.3.1以上

不要在Dao 层加@Param注解

void batchInsert(List<DeviceList> deviceList);

<insert id="batchInsert" parameterType="java.util.List" 
		useGeneratedKeys="true" keyProperty="deviceId">
		INSERT INTO psd_machine.psd_device
		(device_name, device_holder, cargo_track_number, 
		device_code, device_coordinate_x, 
		device_coordinate_y, device_address, device_type)
		VALUES
		<foreach collection="deviceList" item="device" separator=",">
		(#{device.deviceName}, #{device.deviceHolder}, #{device.cargoTrackNumber}, 
		 #{device.deviceCode}, #{device.deviceCoordinateX}, #{device.deviceCoordinateY}, 
		#{device.deviceAddress}, #{device.deviceType})
		</foreach>
	</insert>

转载于:https://my.oschina.net/whatwhy/blog/3020584