UserMapper.java
@Repository
public interface UserMapper{
Integer batchUpdate(@Param("ids")List<Integer> ids,@Param("userDo")User user);
}
UserMapper.xml
<update id="batchUpdate">
UPDATE user
<set>
<if test="userDO.age != null">
age = #{userDo.age}
</if>
</set>
WHERE id IN
<foreach collection="ids" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</update>