批量删除无非是循环table的tr,取主键td,text
var tbl=document.getElementById("tblId");
var arr = [];
for(var i=0;i<tbl.rows.length;i++)
{
arr.push(tbl.rows[i].cells[0].innerText);//假设第一列为主键id
}页面加个隐藏控件,id="hid_ids" name="hid_ids"
document.getElementById("hid_ids").value=arr.join(",");sumit form
下面到后台写sql="delete from table where id in("+Request["hid_ids"];
修改一样,不过是多用几个hidden,然后拼多个update sql,最后放到一个回滚事务中
var tbl=document.getElementById("tblId");
var arr = [];
for(var i=0;i<tbl.rows.length;i++)
{
arr.push(tbl.rows[i].cells[0].innerText);//假设第一列为主键id
}页面加个隐藏控件,id="hid_ids" name="hid_ids"
document.getElementById("hid_ids").value=arr.join(",");sumit form
下面到后台写sql="delete from table where id in("+Request["hid_ids"];
修改一样,不过是多用几个hidden,然后拼多个update sql,最后放到一个回滚事务中
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>"> <title>分类管理</title> <style type="text/css">
body {
font-family: "Verdana", "Arial", "Helvetica", "sans-serif";
font-size: 14px;
color: #333333;
margin: 0px;
padding: 0px;
}td {
font-family: "Verdana", "Arial", "Helvetica", "sans-serif";
font-size: 14px;
color: #333333;
}a {
color: #999999;
text-decoration: none;
}a:hover {
color: #999999;
text-decoration: none;
}.font12 {
font-size: 12px;
color: #666666;
}</style>
<script type="text/javascript">
/* 空链接 */
function goto(){
}
/* 点击编辑链接 */
function tagEdit(divId,tagId,tagName){
var tagDiv = document.getElementById('tagDiv_' + divId);
tagDiv.innerHTML =
"<input type='text' id='edit_"
+ tagId + "' name='edit_"
+ tagId + "' value='"
+ tagName + "'/> "
+ "<input type='button' value='确定' onclick=editSubmit('"
+ divId + "','"
+ tagId + "') /> "
+ "<input type='button' value='取消' onclick=editCancle('"
+ divId + "','"
+ tagId + "','"
+ tagName + "') />";
}
/* 点击删除链接 */
function tagDelete(divId,tagId){
var conf = window.confirm('您确定删除此分类吗?');
if(!conf){
return ;
}
var tagDiv = document.getElementById('tagDiv_' + divId);
tagDiv.parentNode.removeChild(tagDiv);
/* 对表单进行操作! */
/* 增加要删除的隐藏域 */
var myForm = document.getElementById('manaForm');
var hidden_del = document.createElement('input');
hidden_del.setAttribute('type','hidden');
hidden_del.setAttribute('name','del_'+tagId);
hidden_del.setAttribute('id','del_'+tagId);
hidden_del.setAttribute('value',tagId);
myForm.appendChild(hidden_del);
}
/* 编辑后的 确定按钮 */
function editSubmit(divId,tagId){
/* 得到层 */
var tagDiv = document.getElementById('tagDiv_' + divId);
/* 表单值 */
var editTagValue = document.getElementById('edit_' + tagId).value;
tagDiv.innerHTML = "<table border='0' cellpadding='5' cellspacing='5' align='center'>"
+ "<tr><td width='200'>"
+ " 分类名:" + editTagValue
+ "</td><td>"
+ "<a href='javascript:goto();' "
+ " onclick=tagEdit('"
+ divId +"','"
+ tagId +"','"
+ editTagValue +"')><strong>编辑</strong></a>"
+ "</td>"
+ "<td>"
+ "<a href='javascript:goto();' "
+ " onclick=tagDelete('"
+ divId +"','"
+ tagId +"') ><strong>删除</strong></a>"
+ "</td>"
+ "</tr>"
+"</table>";
/* 加入隐藏域的值 */
/* 对表单进行操作! */
/* 增加要修改的隐藏域 */
var myForm = document.getElementById('manaForm');
/* 判读是否已有此数据 */
var upd_tagId = 'upd_'+tagId ;
var exists = document.getElementById(upd_tagId);
var a2 = myForm.elements[upd_tagId]; if(exists != undefined){
/* 已存在此隐藏域,表明是进行第二次修改操作 */
myForm.removeChild(exists);
}
var hidden_upd = document.createElement('input');
hidden_upd.setAttribute('type','hidden');
hidden_upd.setAttribute('name',upd_tagId);
hidden_upd.setAttribute('id',upd_tagId);
hidden_upd.setAttribute('value',editTagValue);
myForm.appendChild(hidden_upd);
}
/* 编辑后的 取消按钮 */
function editCancle(divId,tagId,tagName){
/* 得到层 */
var tagDiv = document.getElementById('tagDiv_' + divId);
tagDiv.innerHTML = "<table border='0' cellpadding='5' cellspacing='5' align='center'>"
+ "<tr><td width='200'>"
+ " 分类名:" + tagName
+ "</td><td>"
+ "<a href='javascript:goto();' "
+ " onclick=tagEdit('"
+ divId +"','"
+ tagId +"','"
+ tagName +"')><strong>编辑</strong></a>"
+ "</td>"
+ "<td>"
+ "<a href='javascript:goto();' "
+ " onclick=tagDelete('"
+ divId +"','"
+ tagId +"') ><strong>删除</strong></a>"
+ "</td>"
+ "</tr>"
+"</table>";
}
/* 判断是否有必要进行提交 : 如果用户没有做任何操作,我们就没有必要进行任何提交*/
function isSubmit(){
var myForm = document.getElementById('manaForm');
if(myForm.length > 1){
/* 还有其他元素 (除了隐藏域 action 和 提交按钮外) */
myForm.submit();
return true;
}else{
/* return false; */
/* 关闭遮罩 */
var bgObj=parent.document.getElementById("bgDiv"); var msgObj=parent.document.getElementById("msgDiv"); bgObj.style.display = msgObj.style.display = "none";
/* 父窗口刷新 */
/* parent.location.reload(false); */
parent.location.assign(parent.location.href);
}
}
</script> </head> <body>
<table width="450" align="center" cellpadding="0" cellspacing="5"> <tr>
<td align="center"> <form style="margin: 0px; padding: 0px;" target="_top"
method="post" id="manaForm" name="manaForm"
action="<%=request.getContextPath()%>/blog/bloger">
<input type="hidden" id="action" name="action"
value="manaArticleSort" />
<div id="tagDiv_0">
<table border="0" align="center" cellpadding="5" cellspacing="5">
<tr>
<td width="200">
分类名:abc
</td>
<td>
<strong> <a href="javascript:goto();"
onclick="tagEdit('0','sort_id','abc')">编辑</a>
</strong>
</td>
<td>
<strong> <a href="javascript:goto();"
onclick="tagDelete('0','sort_id')">删除</a>
</strong>
</td>
</tr>
</table>
</div>
<div id="tagDiv_1">
<table border="0" align="center" cellpadding="5" cellspacing="5">
<tr>
<td width="200">
分类名:Hello world
</td>
<td>
<strong> <a href="javascript:goto();"
onclick="tagEdit('1','sort_id2','Hello world')">编辑</a>
</strong>
</td>
<td>
<strong> <a href="javascript:goto();"
onclick="tagDelete('1','sort_id2')">删除</a>
</strong>
</td>
</tr>
</table>
</div>
<div id="tagDiv_3">
<table border="0" align="center" cellpadding="5" cellspacing="5">
<tr>
<td width="200">
分类名:好呀
</td>
<td>
<strong> <a href="javascript:goto();"
onclick="tagEdit('3','sort_id3','好呀')">编辑</a>
</strong>
</td>
<td>
<strong> <a href="javascript:goto();"
onclick="tagDelete('3','sort_id3')">删除</a>
</strong>
</td>
</tr>
</table>
</div> </form> </td>
</tr>
<tr>
<td align="center">
<input type="submit" value="保存设置" onclick="return isSubmit()"/>
</td>
</tr>
</table>
</body>
</html>