Js:
//批量删除
$(".delAll_btn").click(function(){
var checkStatus = table.checkStatus(‘userListTable’),
data = checkStatus.data,
teacher_ids = “”;
if(data.length > 0) {
for (var i in data) {
teacher_ids+=data[i].teacher_id+",";
}
console.log(“teacher_ids为:”+teacher_ids);
layer.confirm(‘确定删除选中的用户?’, {icon: 3, title: ‘提示信息’}, function (index) {
$.get("delMulti.do",{teacherIds:teacher_ids},function(cs){
tableIns.reload();
layer.msg("批量删除"+JSON.parse(cs).msg);
layer.close(index);
})
// $.get(“delMulti.do?teacherIds=”+teacher_ids,function(cs){
// tableIns.reload();
// layer.msg(“批量删除”+JSON.parse(cs).msg);
// layer.close(index);
// })
})
}else{
layer.msg("请选择需要删除的用户");
}
})
Controller:
/**
* 批量删除
* @param ids
* @return
*/
@ResponseBody
@RequestMapping("/delMulti.do")
public JsonBean delMulti(String teacherIds){
List ids = new ArrayList<>();
String[] teacher_ids = teacherIds.split(",");
for (String t_id : teacher_ids) {
Long id = Long.valueOf(t_id);
ids.add(id);
}
return teacherService.delMulti(ids);
}
Service:
public JsonBean delMulti(List<Long> ids) {
JsonBean jsonBean = new JsonBean(-1, "失败", null);
int n=teacherMapper.delMulti(ids);
if(n>0){
jsonBean = new JsonBean(0, "成功", null);
}
return jsonBean;
}
Mapper:
int delMulti(List ids);
Sql:
delete from
teacher
where
teacher_id IN
<foreach
collection="list"
item="item"
open="(" close=")"
separator=",">
#{item}
</foreach>