for (int j=0;j< delID.length;j++){ strSql = "delete FROM [TBL_USER] WHERE [ID] = " & delID[i] //执行 }
String sqlStr = "delete from table where "; String[] id = request.getParameterValues("checkboxName"); try{ for(int i = 0;i<id.length();i++){ (i = 0)?(sqlStr += " id =" + id[i]):(sqlStr +=" and id = " + id[i]); } }catch(Exception e){ //id[]为空 }
strSql = "delete FROM [TBL_USER] WHERE [ID] = " & delID[i]
//执行
}
String[] id = request.getParameterValues("checkboxName");
try{
for(int i = 0;i<id.length();i++){
(i = 0)?(sqlStr += " id =" + id[i]):(sqlStr +=" and id = " + id[i]);
}
}catch(Exception e){
//id[]为空
}
然后进行集体删除
注意对他进行赋值
<td><input type="checkbox" name="chkid" value="<%=ID%>"></td>