save_stu_add.asp

来自「推荐：很好的考试系统。该考试系统有2000余试题」· ASP 代码 · 共 27 行

<!--#include file="../include/conn2.asp"-->
<!--#include file="usercheck.asp"-->
<%
stuNum=trim(request("stu_num"))
VerificationSql="select STU_NUM from Verification where STU_NUM='"&stuNum&"'"
set rsT=conn.execute(VerificationSql)
if not rsT.eof then
	Session("sa_help")="对不起，这个考生学号已经有了！请重试！"
	response.redirect("stu_add.asp")
end if

stuName=trim(request("stu_name"))
stuClass=trim(request("stu_class"))
stuSex=trim(request("stu_sex"))
'stuResult=trim(request("stu_result"))
'stuIp=trim(request("stu_ip"))
'stuLogin=trim(request("stu_login"))
'stuSubmit=trim(request("stu_submit"))

saveAddSql="insert into Verification (STU_NUM,STU_NAME,STU_CLASS,STU_SEX) values('"&stuNum&"','"&stuName&"','"&stuClass&"','"&stuSex&"')"
set rsT=conn.execute(saveAddSql)
Session("sa_help")="上条记录添加完毕！"
conn.close
set conn=nothing
server.transfer("stu_list.asp")
%>