贴一段批量删除的代码,写得太好了。
页面代码:
<td><input type="checkbox" name="key" id="<c:out value="${vo.recommendId}" />"
value='<c:out value="${vo.recommendId}" />$<c:out value="${vo.tranStatues}" />'
onClick="setCheckValue('<c:out value="${vo.recommendId}" />','<c:out value="${vo.recommendId}" />$<c:out value="${vo.tranStatues}" />')" />
<c:out value="${status.index+1}" />
</td>
function deleteBasicInfo(){
if (parentSelectMap.getCount() == 0) {
alert("请选择要删除的记录!");
return false;
}
var retKeys = parentSelectMap.mapToString();
retKeys =retKeys.replace(/\'/g,"");
// 将retKeys先用,解析一次,再用$解析一次,分装成两个数组,一个用于判读是否未推荐,一个用于存放记录ID
var strArray = new Array();// 存放未做处理的记录
var strPK = new Array();// 存放记录ID
var strTran = new Array();// 存放流程状态
strArray = retKeys.split(",");
// 遍历数组,分装记录ID和流程状态
for(var i=0;i<strArray.length;i++){
var temp = new Array();
// 使用$作为标识符进行解析,分离ID和流程状态
temp = strArray[i].split("$");
strPK[i]=temp[0];
strTran[i]=temp[1];
}
// 遍历流程状态,如果存在未推荐之外状态的记录,则返回;不存在,则执行删除操作
for(var i in strTran){
var tranStatues = strTran[i];
if(!(tranStatues=='' || tranStatues=='0' || tranStatues=='5')) {
alert("存在已推荐的记录,请重新选择!");
return;
}
}
if(confirm("是否确定删除你选中的"+parentSelectMap.getCount()+"条记录?")){
openBrWindow('<%=context%>/zlRecommend.do?method=zlRecommendDel&key='+strPK,'600','400')
}
后台代码:
public ActionForward zlRecommendDel(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response
)throws Exception {
boolean delFlag = true;
ActionForward forward = null;
try
{
String pkId = request.getParameter("key");
System.out.println("批量删除记录的主键字符串:"+pkId);
IZlRecommendBll bll=ZlRecommendBll.getInstance();
//删除主表数据
delFlag = bll.remove(pkId);
//删除企业情况子表
bll.removeEnpInfoByParams(pkId);
//删除目录建议概况子表
IZlProductListBll prdBll=ZlProductListBll.getInstance();
prdBll.deleteByFK(pkId);
}catch(Exception e) {
logger.info(e);
return forward = this.forwardExceptionPage(mapping,request,e);
}
if (delFlag) {
forward = this.forwardMessagePage(mapping,request,"删除成功!",MSG_OPTION_TIPMSG | MSG_OPTION_CLOSE | MSG_OPTION_PARENT_IFRAME_RELOAD);
} else {
forward = this.forwardMessagePage(mapping,request,
"删除失败,请与系统管理员联系!",0);
}
return (forward);
}
对应的数据库操作sql
<!-- ============================= deleteByPK =================================== -->
<statement id="deleteByPK" parameterClass="java.lang.String"><![CDATA[delete from TB_ZL_RECOMMEND where RECOMMEND_ID in ($value$)]]></statement>
<!-- ============================= deleteByPK =================================== -->
<statement id="deleteByPK" parameterClass="java.lang.String"><![CDATA[delete from TB_ZL_PRODUCT_LIST where PRD_LST_ID in ($value$)]]></statement>
<statement id="abatorgenerated_deleteByForeignKey" parameterClass="java.lang.String">
<![CDATA[ delete from TB_ZL_RECOMMEND_EP_INFO
where RECOMMEND_ID in ($recommendId$) ]]>
</statement>
我觉得这个后台代码就非常强大了,关联的子表也批量删除了。只需要在页面获取数据id,做好处理就好了,单条和批量删除都行。
其实把序号的值也加进去,提示不能删除时告诉用户不能删除的记录的序号。