📄 作业入库.txt
字号:
<% 'from jxHomework1 form 6项值输入
xuehao= request("xuehao")
jihao = request("iphao")
zuoye = request("zuoye")
tihao = request("tihao")
sDir = request("dir")
Response.Write "<body bgColor = #D9ECFF><center>"
if zuoye = "" then
Response.Write now() &" <font color=red><b>作业为空，不提交。</b></font></center>":
Response.end
elseif len(zuoye) > 8192 then
Response.Write " <font color=red>由于硬盘空间的原因，限制作业的文本大小<8k，
请删减后再提交。</font></center>": Response.end
end if
zuoye = replace(zuoye, "<BR>", vbCrLf)
zuoye = replace(zuoye, chr(34), "'") ' " -> '
zuoye = replace(zuoye, "'", "''")
sDBFile = "/jxyd/HomeWork/"& sDir &"/Work"& left(tihao,1) &"Get.mdb"
Set dbc = Server.CreateObject("ADODB.Connection")
strConn = "driver={Microsoft Access Driver (*.mdb)}"
dbc.open strConn & ";dbq=" & Server.MapPath(sDBfile)
sql = "select * from 作业题目 where 学号='"& xuehao &"'"
Set rs = dbc.execute(sql)
if rs.EOF then
sql = "insert into 作业题目(日期,学号,机号,内容)"
sql = sql & "values('"& now() &"','"& xuehao &"','"& jihao &"','"& zuoye &"')"
Set rs = dbc.execute(sql)
Response.Write now() &" <font color=red><b>成功提交作业。</b></font></center>"
else
riqi = rs("日期"): defen = rs("得分")
sql = "update 作业题目 SET 日期='"& now() &"',机号='"& jihao &"',内容='"& zuoye &"',
得分='"& cstr(cint(defen)-1) &"' where 学号='"& xuehao &"'"
Set rs = dbc.execute(sql)
Response.Write now() &" <font color=red><b>第"& cstr(cint(abs(defen))+1) &"次成功提交作业。
</b></font></center>"
end if
Set rs = Nothing: Set dbc = Nothing
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -