/**
* 批量删除;
* @param ids
* @return
*/
public boolean deleteAdmin(String[] ids) {
StringBuffer sb = new StringBuffer();
for (String id : ids) {
sb.append(id);
sb.append(",");
}
sb.deleteCharAt(sb.length() - 1);//截掉最后一个','
// System.out.println(sb.toString());
String sql = "delete from admin where id in(" + sb + ")";
// System.out.println(sql);
if (super.executeSQL(sql) != 0) {
return true;
}
return false;
}
function tryDelAdmin(id) {
if (window.confirm("确定要删除吗?")) {
location.href = "ToDelAdmin.jsp?id=" + id;
}
}
<td style="cursor: pointer; color: blue" align="center"
οnclick="tryDelAdmin(<%=admin.getId()%>)">
DEL
</td>
<input type="checkbox" name="checkbox" value="<%=admin.getId()%>">
String[] ids = request.getParameterValues("checkbox");
if (ids != null && ids.length > 0) {
AdminDAO dao = new AdminDAO();
boolean isDelMulOK = dao.deleteAdmin(ids);
if (isDelMulOK) {
response.sendRedirect("ShowDetail.jsp");
} else {
//response.sendRedirect("");
//自动定向到505
}
dao.close();
}else{
response.sendRedirect("ShowDetail.jsp");
return;
}