<!-- 批量修改镇区分配信息 -->
<update id="editCmsDataTownAssignmentBatch" parameterType="java.util.List" >
update cms_data_town_assignment
set assignment =
<foreach collection="list" item="item" index="index" open="case id" close="end" separator="">
when #{item.id} then
#{item.assignment}
</foreach>
where id in
<foreach collection="list" item="item" index="index"
separator="," open="(" close=")">
#{item.id}
</foreach>
</update>
mybatis批量修改
最新推荐文章于 2024-07-24 21:47:59 发布