mysql 批量修改状态
接收到的是数据是数组格式
- Controller
@PostMapping("/onLineCourse")
public AjaxResult onLineCourse(@RequestBody List<Long> ids){
return courseService.onLineCourse(ids);
}
- 业务层
courseMapper.onLineCourse(ids);
3.Mapper
<update id="onLineCourse" parameterType="list">
update t_course set status=1 where id in
<foreach collection="list" open="(" close=")" item="item">
#{item}
</foreach>