tuike.asp

来自「本系统分两个子功能: 一:学生事务 统计学生的入学」· ASP 代码 · 共 59 行

ASP
59
字号
<html>

<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新建网页 1</title>
</head>

<body>
<%
sno=session("idstr")
dim conn,connstr
connstr="Driver={sql server};UID=sa;PWD=sa;database=zikao;server=BILLGATES"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from chooseclass where sno= '"&sno&"'"
rs.open sql,conn,3

%>
<table border="1" width="645" height="409">
	<tr>
		<td height="58" width="645" colspan="5">
		<p align="center"><b><font size="7">退课系统</font></b></td>
	</tr>
	<tr>
		<td height="33" width="86">
		<p align="center">课程编号</td>
		<td height="33" width="191">
		<p align="center">课程名称</td>
		<td height="33" width="125">
		<p align="center">上课时间</td>
		<td height="33" width="123">
		<p align="center">上课地点</td>
		<td height="33" width="86">
		<p align="center">操作</td>
	</tr>
	<%while not rs.eof%>
	<tr>
		<td height="31" width="86"><%=rs(1)%> </td>
		<td height="31" width="191"> <%=rs(0)%></td>
		<td height="31" width="125"> <%=rs(2)%></td>
		<td height="31" width="123"> <%=rs(3)%></td>
		<td height="31" width="86">
		<p align="center"><a href="tuikep.asp?sno=<%=sno%>&cno=<%=rs(1)%>">退课</a></td>
	</tr>
	<%
	 rs.movenext
	 wend
	%>
	<tr>
		<td height="266" width="645" colspan="5"> </td>
	</tr>
</table>

</body>

</html>

⌨️ 快捷键说明

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