<!-- mybatis根据id批量更新对象属性 -->
<update id="batchUpdatePeopleInfo" parameterType="java.util.List" >
update people_info
<set>
<trim prefix="people_name =case " suffix="end,">
<foreach collection="list" item="item" index="index">
when
id=#{item.id} then #{item.peopleName}
</foreach>
</trim>
<trim prefix="mobile_phone =case" suffix="end,">
<foreach collection="list" item="item" index="index">
when
id=#{item.id} then #{item.mobilePhone}
</foreach>
</trim>
<trim prefix="consignee_address =case" suffix="end,">
<foreach collection="list" item="item" index="index">
when
id=#{item.id} then #{item.consigneeAddress}
</foreach>
</trim>
</set>
where id in
<foreach collection="list" index="index" item="item"
separator="," open="(" close=")">
#{item.id}
</foreach>
</update>
Mybatis-批量更新
最新推荐文章于 2024-03-28 21:05:32 发布