cancelresult.asp

来自「该资料包含大量网络开发的案例和源代码」· ASP 代码 · 共 42 行

ASP
42
字号
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>退课结果</title>
<meta name="Microsoft Border" content="b, default">
</head>

<body><!--msnavigation--><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><!--msnavigation--><td valign="top">
<%
	dim adoConn
    dim adoRS
	dim sConnection
    dim sSQL
    dim Cancel,i
    
    cancel=split(request.form("cancel")&", ",",")
  	
    set adoConn=server.createobject("ADODB.Connection")
    sConnection="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.mappath("student.mdb")
    adoConn.open sConnection
    
    i=0
    
    do while trim(cancel(i))<>""     
    	sSQL="delete from sc where sc.sno="&session("user")&" and sc.cno="& cancel(i)
		adoconn.execute(sSQL) 
		i=i+1		  	
	loop
	
	adoConn.close
    set adoConn=nothing
	response.write "</p><p align='center'>退课成功!<br><br><p align='center'><a href='CancelClass.asp'>返回退课</a></p>"
%>	
<p align="center"><a href="index.asp">返回主页</a></p>
<!--msnavigation--></td></tr><!--msnavigation--></table><!--msnavigation--><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td>

<p align="center"><font color="#333333" size="2">版权所有|关于我们</font>

</td></tr><!--msnavigation--></table></body>

</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?