迷茫了 迷茫了, 用复选框删除数据怎么也也删不掉了,求教大神。
本来是想用JS结合做出一个选中然后删除的效果, 但删除总是实现不了, 无法获得选择的ID啊, 怎么办。求教了。
article.jsp
<%@page pageEncoding="utf-8" contentType="text/html;charset=utf-8"%>
<%@ page language="java"%>
<%@ page import="java.sql.*" import="java.util.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>后台管理系统</title>
<link rel="stylesheet" type="text/css" href="images/Style.css">
<script language="javascript" src="../a2j/class.js"></script>
<script language="javascript">
var IsChkAll = false;
function ChkAll(frm)
{
IsChkAll = !IsChkAll;
for(var i=0; i<frm.elements.length; i++)
if (frm.elements[i].type == "checkbox")
frm.elements[i].checked = IsChkAll;
}
function a_edit(frm)
{
var a_id=0;
var a_count=0;
for(var i=0; i<frm.elements.length; i++)
if(frm.elements[i].name=="Id" && frm.elements[i].checked)
{
a_id = frm.elements[i].value;
a_count ++;
}
if(a_count!=1)
alert("请选择一篇你需要修改/查看的文章");
else
document.URL="Article_Edit.asp?action=edit&Id=" + a_id + "&ChannelID=1";
}
function a_action(frm,aStr)
{
var a_count=0;
for(var i=0; i<frm.elements.length; i++)
if(frm.elements[i].name=="Id" && frm.elements[i].checked)
a_count ++;
if(a_count==0)
alert("你需要至少选择一篇文章进行相关操作");
else
{
frm.Cmd.value = aStr;
frm.submit();
}
}
</script>
</head>
<body>
<style type="text/css">
#showMsg{
width:200px;
position:absolute;
top:30px;
right:28px;
border:solid 1px #666666;
padding:8px;
color:#FF0000;
background-color:#FFFFFF;
z-index:1000;
}
</style>
<script language="javascript">
String.prototype.trim = function(){ return this.replace(/(^\s*)|(\s*$)/g, "");}
//显示错误信息
function ShowErrMsg(Info)
{
document.getElementById("showMsg").innerHTML = Info;
}
window.onscroll = function()
{
var t = document.body.scrollTop + 30;
document.getElementById("showMsg").style.top = t + "px";
}
</script>
<div id="showMsg">准备就绪,欢迎使用...</div>
<table cellspacing="0" cellpadding="5" width="100%" bgcolor="#fda700"
border="0" style="border-bottom:2px solid #CCCCCC;border-top:2px solid #CCCCCC;">
<tbody>
<tr>
<td nowrap="nowrap" width="2%"></td>
<td nowrap="nowrap" width="2%"><a title="后退" href="javascript:history.back();"><img
height="15" src="images/jiantou-Control-a1.jpg" width="16"
border="0" /></a></td>
<td nowrap="nowrap" width="89%"><table cellspacing="0" cellpadding="0" width="100%" border="0">
<tbody>
<tr>
<td align="center"><strong></strong> 欢迎您!</td>
</tr>
</tbody>
</table></td>
<td valign="bottom" nowrap="nowrap" width="4%" height="22"><a title="前进"
href="javascript:history.go(1);"><img height="16"
src="images/jiantou-Control-b2.jpg" width="15" align="right" border="0" /> </a> </td>
<td nowrap="nowrap" align="right" width="3%"> </td>
</tr>
</tbody>
</table>
<br />
<table cellspacing="0" cellpadding="0" width="98%" align="center" border="0">
<tbody>
<tr>
<td style="PADDING-LEFT: 2px; HEIGHT: 22px"
background="images/tab_top_bg.gif"><table cellspacing="0" cellpadding="0" width="477" border="0">
<tbody>
<tr>
<td width="147"><table height="22" cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td width="3"><img id="tabImgLeft__0" height="22"
src="images/tab_active_left.gif" width="3" /></td>
<td
background="images/tab_active_bg.gif" class="tab"><strong class="mtitle">文章管理</strong></td>
<td width="3"><img id="tabImgRight__0" height="22"
src="images/tab_active_right.gif"
width="3" /></td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table></td>
</tr>
<tr>
<td bgcolor="#ffffff"><table cellspacing="0" cellpadding="0" width="100%" border="0">
<tbody>
<tr>
<td width="1" background="images/tab_bg.gif"><img height="1"
src="images/tab_bg.gif" width="1" /></td>
<td
style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px; PADDING-TOP: 10px"
valign="top"><div id="tabContent__0" style="DISPLAY: block; VISIBILITY: visible">
<table cellspacing="1" cellpadding="1" width="100%" align="center"
bgcolor="#8ccebd" border="0">
<tbody>
<tr>
<td
style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px; PADDING-TOP: 10px"
valign="top" bgcolor="#fffcf7">
<table width="98%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#CCCCCC">
<form id="Form" name="Form" method="get" action="article.jsp">
<tr>
<td colspan="8" align="left" bgcolor="#EBEBEB"><select name="stype" id="stype">
<option value="Title">按标题</option>
<option value="Content">按内容</option>
</select>
[解决办法]
对于复选框,应该按这种方式去取值吧:
if (obj.options[i].selected) {
arrSelValue[j] = obj.options[i].value;
arrSelText[j] = obj.options[i].text;
}
[解决办法]
先把你的表单提交方式改为post,再去测试下看传过去了没,没出问题就用request.getparameter("id");取到id就可以,这个不难啊。。。
[解决办法]
String[] deletes=request.getParameterValues(复选框的name);
for(int i=0;i<deletes.length;i++){
String sql="......where id="+deletes[i];
.......
运行sql语句
.......
}
类似这样试试