mybatis-update

1. 多条件更新
   case when
   id = 可以放在 when后面 也可以放在when前面

UPDATE tests
<trim prefix="SET" suffixOverrides=",">
    <trim  prefix=" sex = CASE " suffix=" END, " >
        <foreach collection="list"   index="index" item="item">
            <if test="item.sex!=null">
                WHEN  id = #{item.id}  THEN #{item.sex}
            </if>
        </foreach>
    </trim>
    <trim  prefix=" score = CASE " suffix=" END " >
        <foreach collection="list"   index="index" item="item">
            <if test="item.score!=null">
                WHEN  id = #{item.id}  THEN #{item.score}
            </if>
        </foreach>
    </trim>
</trim>
WHERE id in
<foreach collection="list" separator="," open="(" close=")" index="index" item="item">
    #{item.id}
</foreach>

2. 第二种更新条数比较少的
   update table a join table b on a.id = ? and b.id = ? set a.name = ? , b.name = ?