准备工作
现在有一张表为:student,相关字段如下:
- mapper层方法
int batchUpdateStudent(List<Student> studentList);
- xml语句
<update id="batchUpdateStudent">
update student
<trim prefix="set" suffixOverrides=",">
<trim prefix="name =case" suffix="end,">
<foreach collection="list" item="item" index="index">
<if test="item.name!&