-
业务场景:
-
批量插入sku配置信息;
-
-
注意事项:
-
foreach标签的使用;
-
最终生成的是一条sql:UPDATE (fileds ... ) VALUES (values1 ... ), (values2 ... ), (values3 ...);
-
-
实际代码:
-
mapper层:
Integer batchInsertTeamActivitySkuConfig(@Param("teamActivitySkuConfigPOList") List<TeamActivitySkuConfigPO> teamActivitySkuConfigPOList); -
xml:
<insert id="batchInsertTeamActivitySkuConfig" parameterType="java.util.List"> INSERT INTO `team_activity_sku_config` <trim prefix="(" suffix=")" suffixOverrides=","> `sku_config_id`, `config_id`, `operation_activity_id`, `merchant_id`, `spu_id`, `sku_id`, `activity_start_time`, `activity_end_time`, `activity_stock`, `status`, `sku_min_price`, `sku_max_price`, `total_limit_per_sku`, `leader_target_user_type`, `leader_target_reward`, `follower_target_user_type`, `follower_target_reward`, `team_members_num`, </trim> VALUES <foreach collection="teamActivitySkuConfigPOList" item="item" separator=","> <trim prefix="(" suffix=")" suffixOverrides=","> #{item.skuConfigId}, #{item.configId}, #{item.operationActivityId}, #{item.merchantId}, #{item.spuId}, #{item.skuId}, #{item.activityStartTime}, #{item.activityEndTime}, #{item.activityStock}, #{item.status}, #{item.skuMinPrice}, #{item.skuMaxPrice}, #{item.totalLimitPerSku}, #{item.leaderTargetUserType}, #{item.leaderTargetReward}, #{item.followerTargetUserType}, #{item.followerTargetReward}, #{item.teamMembersNum}, </trim> </foreach> </insert>
-
本文介绍了在业务场景中,如何使用foreach标签和mapper接口批量插入TeamActivitySkuConfig数据,通过XML中的SQL模板生成多行UPDATE语句进行配置信息的更新。

被折叠的 条评论
为什么被折叠?



