<foreach collection=“list“ item=“item“ index=“index“ open=““ close=““ separator=“;“>属性的含义

本文详细解析了MyBatis中的Foreach元素及其属性的作用,包括item、index、collection等,并介绍了collection属性在不同场景下的具体应用。

<foreach collection="list" item="item" index="index" open="" close="" separator=";">属性的含义

foreach的主要用在构建in条件中,它可以在SQL语句中进行迭代一个集合。
foreach元素的属性主要有 item,index,collection,open,separator,close。
item集合中每一个元素进行迭代时的别名,
index表示在迭代过程中,每次迭代到的位置,
open该语句以什么开始,
separator在每次进行迭代之间以什么符号作为分隔 符,
close以什么结束,
在使用foreach的时候最关键的也是最容易出错的就是collection属性,
该属性是必须指定的,但是在不同情况 下,该属性的值是不一样的,
主要有一下3种情况:
1.     如果传入的是单参数且参数类型是一个List的时候,collection属性值为list
2.     如果传入的是单参数且参数类型是一个array数组的时候,collection的属性值为array
3.     如果传入的参数是多个的时候,我们就需要把它们封装成一个Map了
 

<update id="batchUpdate" parameterType="java.util.List"> UPDATE batchs <set> batch_name = CASE batch_id <foreach collection="list" item="item"> <if test="item.batchName != null">WHEN #{item.batchId} THEN #{item.batchName}</if> </foreach> ELSE batch_name END, model_id = CASE batch_id <foreach collection="list" item="item"> <if test="item.modelId != null and item.modelId != ''">WHEN #{item.batchId} THEN #{item.modelId}</if> </foreach> ELSE model_id END, production_id = CASE batch_id <foreach collection="list" item="item"> <if test="item.productionId != null and item.productionId != ''">WHEN #{item.batchId} THEN #{item.productionId}</if> </foreach> ELSE production_id END, bom_id = CASE batch_id <foreach collection="list" item="item"> <if test="item.bomId != null and item.bomId != ''">WHEN #{item.batchId} THEN #{item.bomId}</if> </foreach> ELSE bom_id END, amounts = CASE batch_id <foreach collection="list" item="item"> <if test="item.amounts != null">WHEN #{item.batchId} THEN #{item.amounts}</if> </foreach> ELSE amounts END, complete_amount = CASE batch_id <foreach collection="list" item="item"> <if test="item.completeAmount != null">WHEN #{item.batchId} THEN #{item.completeAmount}</if> </foreach> ELSE complete_amount END, update_time = CASE batch_id <foreach collection="list" item="item"> <if test="item.updateTime != null">WHEN #{item.batchId} THEN #{item.updateTime}</if> </foreach> ELSE update_time END, update_by = CASE batch_id <foreach collection="list" item="item"> <if test="item.updateBy != null">WHEN #{item.batchId} THEN #{item.updateBy}</if> </foreach> ELSE update_by END, del_flag = CASE batch_id <foreach collection="list" item="item"> <if test="item.delFlag != null">WHEN #{item.batchId} THEN #{item.delFlag}</if> </foreach> ELSE del_flag END, factory_id = CASE batch_id <foreach collection="list" item="item"> <if test="item.factoryId != null">WHEN #{item.batchId} THEN #{item.factoryId}</if> </foreach> ELSE factory_id END </set> WHERE batch_id IN ( <foreach collection="list" item="item" separator=","> #{item.batchId} </foreach> ) </update>怎么修改
08-26
<update id="batchUpdate" parameterType="java.util.List"> UPDATE batchs SET batch_name = CASE batch_id <foreach collection="list" item="item"> <if test="item.batchName != null"> WHEN #{item.batchId} THEN #{item.batchName} </if> </foreach> ELSE batch_name END, model_id = CASE batch_id <foreach collection="list" item="item"> <if test="item.modelId != null and item.modelId != ''"> WHEN #{item.batchId} THEN #{item.modelId} </if> </foreach> ELSE model_id END, production_id = CASE batch_id <foreach collection="list" item="item"> <if test="item.productionId != null and item.productionId != ''"> WHEN #{item.batchId} THEN #{item.productionId} </if> </foreach> ELSE production_id END, bom_id = CASE batch_id <foreach collection="list" item="item"> <if test="item.bomId != null and item.bomId != ''"> WHEN #{item.batchId} THEN #{item.bomId} </if> </foreach> ELSE bom_id END, amounts = CASE batch_id <foreach collection="list" item="item"> <if test="item.amounts != null"> WHEN #{item.batchId} THEN #{item.amounts} </if> </foreach> ELSE amounts END, complete_amount = CASE batch_id <foreach collection="list" item="item"> <if test="item.completeAmount != null"> WHEN #{item.batchId} THEN #{item.completeAmount} </if> </foreach> ELSE complete_amount END, update_time = CASE batch_id <foreach collection="list" item="item"> <if test="item.updateTime != null"> WHEN #{item.batchId} THEN #{item.updateTime} </if> </foreach> ELSE update_time END, update_by = CASE batch_id <foreach collection="list" item="item"> <if test="item.updateBy != null"> WHEN #{item.batchId} THEN #{item.updateBy} </if> </foreach> ELSE update_by END, factory_id = CASE batch_id <foreach collection="list" item="item"> <if test="item.factoryId != null"> WHEN #{item.batchId} THEN #{item.factoryId} </if> </foreach> ELSE factory_id END WHERE batch_id IN <foreach collection="list" item="item" open="(" separator="," close=")"> #{item.batchId} </foreach> </update>怎么改
08-26
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值