<!--int updateStreamBoxes(@Param("list") List<SBox> list);-->
<update id="updateStreamBoxes" parameterType="list">
update stream_box
<trim prefix="set" suffixOverrides=",">
<trim prefix="use_state =case" suffix="end,">
<foreach collection="list" item="i" index="index">
when stream_box_id=#{i.streamBoxId} then #{i.useState}
</foreach>
</trim>
<trim prefix=" set_id =case" suffix="end,">
<foreach collection="list" item="i" index="index">
when stream_box_id=#{i.streamBoxId} then #{i.setId}
</foreach>
</trim>
<trim prefix=" pre_set_id =case" suffix="end,">
<foreach collection="list" item="i" index="index">
when stream_box_id=#{i.streamBoxId} then #{i.preSetId}
</foreach>
</trim>
<trim prefix=" pre_use_capability =case" suffix="end,">
<foreach collection="list" item="i" index="index">
when stream_box_id=#{i.streamBoxId} then #{i.preUseCapability}
</foreach>
</trim>
<trim prefix=" last_set_id =case" suffix="end,">
<foreach collection="list" item="i" index="index">
when stream_box_id=#{i.streamBoxId} then #{i.lastSetId}
</foreach>
</trim>
<trim prefix=" last_use_capability =case" suffix="end,">
<foreach collection="list" item="i" index="index">
when stream_box_id=#{i.streamBoxId} then #{i.lastUseCapability}
</foreach>
</trim>
</trim>
where
<foreach collection="list" separator="or" item="i" index="index" >
id=#{i.streamBoxId}
</foreach>
</update>
其中白色字體部分中炬搭，帶
_下劃線部分是數(shù)據(jù)庫中的字段融虽，駝峰命名的是數(shù)據(jù)庫字段對應的javaBean的屬性有额。
