实现MyBatis批量插入

最新推荐文章于 2024-07-24 14:08:06 发布

software_Dev_

最新推荐文章于 2024-07-24 14:08:06 发布

阅读量1.2k

点赞数

分类专栏： MyBatis 文章标签：实现MyBatis批量插入

本文链接：https://blog.csdn.net/qq_36014509/article/details/89339956

版权

MyBatis 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

Service

int createList(List<ProductDeviceEntity> roductDeviceEntityList);

ServiceImpl

	@Override
	public int createList(List<ProductDeviceEntity> roductDeviceEntityList) {
		log.info("ProductDeviceServiceImpl ==> createList()");
		int res = productDeviceMapper.createList(roductDeviceEntityList);
		return res;
	}

Dao

int createList(List<ProductDeviceEntity> roductDeviceEntityList);

Mapper

<insert id="createList" parameterType="java.util.List"
		useGeneratedKeys="false">
		insert into product_device
		(
		product_id, user_id, device_code,order_id,promo_code
		)
		values
		<foreach collection="list" item="item" index="index"
			separator=",">
			(
			#{item.productId},
			#{item.userId},
			#{item.deviceCode},
			#{item.orderId},
			#{item.promoCode},
			)
		</foreach>
	</insert>