//sql<update id="batchStu">deletefrom email
where id in<foreach collection="array"index="no" item="id"open="("
separator=","close=")">
${id}
</foreach></update>
//控制层// 批量删除数据@RequestMapping("exam/del")publicObjectidelStu(@RequestParam("id")Integer[] id){int i = emailService.batchStu(id);if(i >=1){returnnewResult("200","删除成功", i, id);}else{returnnewResult("200","删除失败", i,null);}}
//dao层intbatchStu(Integer[] id);
//HTML前台<script type="text/html" id="toolbarDemo"><div class="layui-btn-container"><a class="layui-btn layui-btn-normal layui-btn-sm" lay-event="batchdel">批量删除</a></div></script>
table.on('toolbar(test)',function(obj){var checkStatus = table.checkStatus(obj.config.id),
data = checkStatus.data;
console.log(data)
console.log(obj.config.id)switch(obj.event){case'batchdel'://上面的名称var checkStatus = table.checkStatus(obj.config.id);var data = checkStatus.data;if(data.length ==0){
layer.msg('至少选一个吧');returnfalse;}
layer.confirm('真的要删除选中的项吗?',function(
index){
layer.close(index);
index = layer.load(1,{
shade:[0.1,'#fff']});var arr =[];var id =null;for(var i =0; i < data.length; i++){
arr.push(checkStatus.data[i].id);//改成数据库id}var id = arr.join(",")
$.post(globalData.server +'exam/del',{//接口'id': id
},function(data){var i = data.count;if(i >=1){
layer.msg('删除成功',{
icon:1,
time:2000},function(){
window.location.reload();back();});}else{
layer.msg("删除失败!");}},'json');})break;}});
```java//sql <update id="batchStu"> delete from email where id in <foreach collection="array" index="no" item="id" open="(" separator="," close=")"> ${id} </foreach>.