我怎么循环判断好多Checkbox框有没有选中，从而从库中删除选中的Checkbox所对应的这一条记录

wwwdw 2003-12-04 10:36:17

...全文

117 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

wanghr100 2003-12-05

打赏
举报

Order.asp

<%
dim conn
dim connstr
on error resume next
connstr="DBQ="+server.MapPath("test.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.CreateObject("ADODB.CONNECTION")
conn.open connstr
%>
<%
set rs1=Server.CreateObject("ADODB.Recordset")
for each iselects in Request.Form("sname")
rs1.open "delete * from test where id="+iselects,conn,1
rs1.close
next
%>
<form action="Order.asp" method="post">
<%
sql="Select * from test"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
do until rs.eof
%>
<input type=checkbox name="sname" value="<%=rs("id")%>"><%=rs("name")%><br>
<% rs.movenext
loop%>
<input type=submit value="Submit">
</form>

数据库设计
test.mdb
表test
id 自动编号
name 字符
行了..

wwwdw 2003-12-05

打赏
举报

这个倒是挺简单。不过

aaaaa_1 参数是从哪里得来的？是做什么用的？

我要加到什么地方呢？

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="java"%>
<%@ page import ="java.util.*,java.sql.*"%>

<html>
<head>
</head>
<body>
<form name="blzt" method="post" action="">
<table border="1" width="100%">
<div align="center"><font size="5">文件来源维护</font></div>
<tr> </tr>
<tr>
<td width="9%" height="12"> <div align="center"><font size="2">
<input type="checkbox" name="all" onClick="selectall()" value="0"><div align="reght">选择</div></font></div></td>

<td width="13%"><font size="2"><div align="center">办理状态标识</div></font></td>
<td width="19%"><font size="2"><div align="center">办理状态</div></font></td>
<td width="20%"><font size="2"><div align="center">排序号</div></font></td>
<td width="22%"><font size="2"><div align="center">描述信息</div></font></td>
<td width="22%"><font size="2"><div align="center">有效性标识</div></font></td>
</tr>
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.1.4.10:1521:bgtgw";
//orcl为你的数据库的SID
String user="szfbgt";
String password="1";

Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
//String sql_query="select * from dic_blztb";
//String sql_add="insert into dic_blztb(blzt_id,blzt,pxh,msxx,yxxbs)values('10','办理中','10','10','1')";
//String sql_update="update dic_blztb set blzt_id='9999' where blzt_id='2'";
// String sql_delete="delete dic_blztb where blzt_id=6";
//ResultSet rs=stmt.executeQuery(sql_query);
// stmt.executeQuery(sql_delete);
//stmt.executeQuery(sql_update);
//stmt.executeUpdate(sql_add);
//out.println("添加成功！<br><br>");

//out.println("更新成功！<br><br>");
// out.println("删除成功！<br><br>");

String sql_query="select * from dic_blztb";
ResultSet rs=stmt.executeQuery(sql_query);
/* while(rs.next()){
//int blzt_id=rs.getInt("blzt_id");
//String blzt=rs.getString("blzt");
//String pxh=rs.getString("pxh");
//String msxx=rs.getString("msxx");
//String yxxbs=rs.getString("yxxbs");
// out.println("插入成功");
out.println(rs.getString("blzt"));
out.println("<br>");
out.println(rs.getString("blzt_id"));
}*/while(rs.next()){
String blzt_id=rs.getString("blzt_id");
String blzt=rs.getString("blzt");
String pxh=rs.getString("pxh");
String msxx=rs.getString("msxx");
String yxxbs=rs.getString("yxxbs");

}

%>
<td height="20"> <div align="center"> <font size="2">

</font></div></td>
<td width="13%"><font size="2"><div align="center"><%=blzt_id%></div></font></td>
<td width="19%"><font size="2"><div align="center"><%=blzt%></div></font></td>
<td width="20%"><font size="2"><div align="center"><%=pxh%></div></font></td>
<td width="22%"><font size="2"><div align="center"><%=msxx%></div></font></td>
<td width="22%"><font size="2"><div align="center"><%=yxxbs%></div></font></td>
</tr>
</table>
<table width="70%" align="center" border="1"><div align="center">
<input type="button" name="add" value="增加" onclick="fun_add()">
<input type="button" name="modify" value="修改" onclick="fun_modify()">
<input type="button" name="del" value="删除" onclick="fun_del()"></div>

</table>
<%

</form>

</body>
</html>

iinohk 2003-12-04

打赏
举报

我常用這招，不過太多checkbox的話就會很慢
<%
...
strSQL="select * from table where value="&request.form("query")
...
%>
<form name="form1" action="#" method="post" onsubmit="createquery('aaaa')">
<input type="checkbox" name="aaaaa_1" value="1">
.
.這裡有很多都是name="aaaa_x"，x是整數的checkbox
.
<input type=hidden name=query>
<input type=submit value=submit>
</form>
<script>
function createquery(name){
for(var i=0;i<document.all.form1.length;i++){
if(document.all.form1.element[i].name.substring(0, 3)==name)
if(document.all.form1.element[i].checked)
document.all.query.value+=document.all.form1.element[i].value + " or ";
}
document.all.query.value=document.all.query.value.substring(0, document.all.query.value.length-3);
}
</script>

bzscs 2003-12-04

打赏
举报

没选中的就不用理会，判断选中的就删除

tiannet 2003-12-04

打赏
举报

sobeatiful 2003-12-04

打赏
举报

干嘛搞得着复杂，直接
<%
...
String[] aa=request.getParameterValues("aaaaa_1");
String sql="";
if(aa!=null){
sql=sql+"delete table where field="+aa[];
}

%>
然后执行这段sql语句就可以了