sql语句
批量更新方法修改
<update id="updateByList" parameterType="java.util.List"> update 表名 <trim prefix="set" suffixOverrides=","> <trim prefix="name =case" suffix="end,"> <foreach collection="list" item="item" index="index"> <if test="item.name!=null"> when id = #{item.id} then #{item.name} </if> </foreach> </trim> </trim> <where> id in <foreach collection="list" index="index" item="item" separator="," open="(" close=")"> #{item.id} </foreach> </where> </update>