修改按钮绑定事件
function doDelete(){
//获取数据表格中所有选中的行,返回数组对象
var rows = $("#grid").datagrid("getSelections");
if(rows.length == 0){
//没有选中记录,弹出提示
$.messager.alert("提示信息","请选择需要删除的取派员!","warning");
}else{
//选中了取派员,弹出确认框
$.messager.confirm("删除确认","你确定要删除选中的取派员吗?",function(r){
if(r){
var array = new Array();
//确定,发送请求
//获取所有选中的取派员的id
for(var i=0;i<rows.length;i++){
var staff = rows[i];//json对象
var id = staff.id;
array.push(id);//加到数组中
}
var ids = array.join(",");//1,2,3,4,5
location.href = "staffAction_deleteBatch.action?ids="+ids;//发出请求
}
});
}
}
Action
private String ids;
public void setIds(String ids) {
this.ids = ids;
}
public String deleteBatch(){
//直接调用service
staffService.deleteBatch(ids);
return LIST;
}
Service
public void deleteBatch(String ids) {
if(StringUtils.isNotBlank(ids)){
//001,002,003
String[] staffIds = ids.split(",");
for (String id : staffIds) {
//调用dao方法
staffDao.executeUpdate("staff.delete", id);
}
}
}
Staff.hbm.xml
dao
public void executeUpdate(String queryName, Object... objects) {
Session session = this.getSessionFactory().getCurrentSession();
Query namedQuery = session.getNamedQuery(queryName);
int i = 0;
for(Object object:objects){
namedQuery.setParameter(i++, object);
}
namedQuery.executeUpdate();
}