根据ID更新商品编号商品价格
<update id="updateCopeHdxx" parameterType="java.util.List"> update T_JQ_SPHDMBB <trim prefix="set" suffixOverrides=","> <trim prefix="spbh=case" suffix="end,">//注意逗号 <foreach collection="list" item="i" index="index"> <if test="i.spbh != null"> when id= '${i.id}' then #{i.spbh} </if> </foreach> </trim> <trim prefix="spjg=case" suffix="end"> <foreach collection="list" item="i" index="index"> <if test="i.spjg != null"> when id= '${i.id}' then #{i.spjg} </if> </foreach> </trim> </trim> where ( <foreach collection="list" separator="or" item="i" index="index"> id= '${i.id}' </foreach> ) </update>