📄 kskc.asp
字号:
<!--#include file="pwd.asp" -->
<!--#include file="cjgl_conn.inc" -->
<%
if session("sbjmc")="" then
response.write "未选择班级！<a href=""cjgl.asp"">返回</a>"
response.end
end if
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<title>
<%=session("sbjmc")%><%=session("sxqmc")%>开设课程
</title>
<META NAME="Generator" CONTENT="EditPlus 1.2">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<BODY BGCOLOR="#c0c0c0">
<h3 align=center>“<%=session("sbjmc")%>(<%=session("sbjdm")%>)”<%=session("sxqmc")%>开设课程</h3>
<%
tcjk=session("sbjdm")&session("sxqdm")&"8" '总评成绩库名
sql="select * from "&tcjk
Set RS = Server.CreateObject("ADODB.RecordSet")
on error resume next '忽略错误继续向下执行
RS.Open sql, cjgl_Conn
rs.close
if err=0 then '总评成绩库存在，已注册
response.write(session("sbjmc")&session("sxqmc")&"已注册，不能再开设课程！<a href=""cjgl.asp"">返回</a>")
set rs=nothing
on error goto 0 '恢复错误检查
response.end
end if
tkck=session("sbjdm")&session("sxqdm") '开设课程库名
sql="create table "&tkck&" (kcdm text (3) CONSTRAINT kcdm PRIMARY KEY,kcmc text (16),jsxm text (8))"
cjgl_conn.execute(sql)
on error goto 0 '恢复错误检查
sql="select * from kck order by kcdm"
RS.Open sql, cjgl_Conn
%>
<FORM METHOD=post ACTION="kskc1.asp">
<center><table border="0" cellpadding="8">
<tr>
<td valign="top">
选择课程<br>
<select name="kc" multiple size="20">
<option selected><%=rs("kcmc")%></option>
<%
rs.movenext
do while not rs.eof
%>
<option><%=rs("kcmc")%></option>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</select>
</td>
<td valign="center">
<input type="submit" name="cmd1"
value="确定"><p><input type="reset" name="cmd2"
value="取消"></p>
<p>
<a href="cjgl.asp">返回</a></p>
</td>
</tr>
</table>
</center>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -