批量删除
前端页面
HTML
按钮展示批量删除
<button type="button" class="btn btn-primary" id="btn-delete" style="margin-top: 8px;margin-bottom: 8px; margin-right: 12px;">
<i class="fa fa-trash"></i> 批量删除
</button>
js
记得在表格内增加列:{checkbox:true}
$(function() {
/** 批量删除 **/
$('#btn-delete').on('click', function () {
deleteMore();
});
});
//批量删除
function deleteMore() {
var selected = $('#qyldsclTable').bootstrapTable('getAllSelections');
var ids = new Array();
for (var i = 0; i < selected.length; i++) {
var id = selected[i].ID;
ids[i] = id;
}
if(confirm("您确定要删除单条或者多条标签记录吗?删除后无法恢复,请谨慎操作!")){
$.ajax({
type : "post",
url: basePath + '/submit/sjzDeleteMore' ,
data:{"ids":ids.toString()},
dataType : "json",
success : function() {
refresh("#qyldsclTable");
$.tips.success(ALERT.REMOVE_SUCCESS);
}
});
}
}
后端
@RequestMapping("/sjzDeleteMore")
@ResponseBody
public Map<String,Object> sjzDeleteMore(HttpServletRequest request) throws Exception{
String parameter = request.getParameter("ids");
String[] ids = parameter.split(",");
try {
for (int i = 0; i < ids.length; i++) {
qyldMapper.deleteById(ids[i]);
}
return new ResultMap().addCode(Consts.CODE_SUCCESS).toMap();
} catch (Exception e) {
e.printStackTrace();
return new ResultMap().addCode(Consts.CODE_ERROR).toMap();
}
}