?? 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 + -