📄 xqzc.asp
字号:
<!--#include file="pwd.asp" -->
<!--#include file="cjgl_conn.inc" -->
<!--#include file="xmgl_conn.inc" -->
<%
if session("sbjmc")="" then
response.write "未选择班级！<a href=""cjgl.asp"">返回</a>"
response.end
end if
Set RS = Server.CreateObject("ADODB.RecordSet")
tcjk=session("sbjdm")&session("sxqdm")&"1" '平时成绩一库名
sql="select * from "&tcjk
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
on error goto 0 '恢复错误检查
%>
<!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>
<%
tkck=session("sbjdm")&session("sxqdm") '开设课程库名
sql="select * from "&tkck
on error resume next '忽略错误继续向下执行
RS.Open sql, cjgl_Conn
if err<>0 then '开设课程库不存在
response.write(session("sbjmc")&session("sxqmc")&"未开设课程！<a href=""cjgl.asp"">返回</a>")
rs.close
set rs=nothing
on error goto 0 '恢复错误检查
response.end
end if
tsql=" (xh text (2) CONSTRAINT kcdm PRIMARY KEY,xm text (8),zf short,mc short"
do while not rs.eof
tsql=tsql&","&rs("kcdm")&" short"
rs.movenext
loop
tsql=tsql&")"
rs.close
sql="select * from "&session("sbjdm")&" order by xh"
RS.Open sql, xmgl_Conn
for i=1 to 8
tcjk=tkck&trim(cstr(i))
sql="create table "&tcjk&tsql
cjgl_conn.execute(sql)
rs.movefirst
do while not rs.eof
txh=rs("xh")
txm=rs("xm")
sql="insert into "&tcjk&"(xh,xm) values ('"&txh&"','"&txm&"')"
cjgl_conn.execute(sql)
rs.movenext
loop
if err=0 then
response.write "已建立第"&cstr(i)&"个成绩表!<br>"
else
response.write "不能建立第"&cstr(i)&"个成绩表，该表可能已经存在，应全部删除后重新注册!<br>"
end if
next
on error goto 0 '恢复错误检查
rs.close
set rs=nothing
%>
<p>
<a href="cjgl.asp">返回</a>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -