<update id="batchUpdateModel" > update STUDENT set status = <foreach collection="list" item="item" index="index" separator=" " open="case" close="else status end,"> when id=#{item.id} then #{status} </foreach> version = <foreach collection="list" item="item" index="index" separator=" " open="case" close=" else version end,"> when id=#{item.id} then #{item.version}+1 </foreach> update_time = <foreach collection="list" item="item" index="index" separator=" " open="case" close=" else update_time end"> when id=#{item.id} then NOW() </foreach> where (id, version) in <foreach collection="list" index="index" item="item" separator="," open="(" close=")"> (#{item.id}, #{item.version}) </foreach> </update>
mybatis 批量更新
最新推荐文章于 2023-07-02 23:18:19 发布