update dept
set updateTime = now(),
dname = case deptno
<foreach collection="list" item="item">
when #{item.deptno} then #{item.dname }
</foreach>
end
where deptno in
<foreach collection="list" item="item" open="(" separator="," close=")">
#{item.deptno}
</foreach>
格式: update 表名 set 字段= case 主键 when 值 then 字段赋值 end,........where 主键 in (*,*,*)