<update id="batchUpdateStoreStatus" parameterType="java.util.List"> update ba_saas_partner_sales_product <trim prefix="set" suffixOverrides=","> <trim prefix="status =case" suffix="end,"> <foreach collection="list" item="item" index="index"> when id=#{item.id} then #{item.status} </foreach> </trim> </trim> where id in <foreach collection="list" index="index" item="item" separator="," open="(" close=")"> #{item.id} </foreach> </update>
mybatis 批量更新 不需要设置数据库配置文件方式
最新推荐文章于 2022-07-15 01:29:52 发布