📄 inf_input_student_result.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<!--#include file="verifyTeacher.asp"-->
<%
var studentNo;
var name;
var sex;
var birthday;
var minzu;
var tuanyuan;
var college;
var profession;
var classId;
var peiyanfs;
var xuezhi;
var ruxuelf;
var xueli;
var waiyu;
var waiyudj;
var jiankangzk;
var zaidu;
var address;
var phoneNum;
var email;
var homepage;
var text;
var Commandtext;
studentNo=Request.Form("Num");
name=Request.Form("Name");
sex=Request.Form("Sex");
birthday=Request.Form("Bothyear")+"-"+Request.Form("Bothmonth")+"-"+Request.Form("Bothday");
minzu=Request.Form("Ration");
tuanyuan=Request.Form("Polity");
college=Request.Form("Collage");
profession=Request.Form("Profession");
classId=Request.Form("Class");
peiyanfs=Request.Form("Plant");
xuezhi=Request.Form("Order");
ruxuelf=Request.Form("Intime");
xuezhi=Request.Form("Grade");
waiyu=Request.Form("Foregin");
waiyudj=Request.Form("Foregingrade");
jikangzk=Request.Form("Health");
zaidu=Request.Form("Reading");
address=Request.Form("Address");
phoneNum=Request.Form("Telephone");
email=Request.Form("Email");
homepage=Request.Form("Personalpage");
text=Request.Form("Text");
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!--#include file="link.asp"-->
<title>学生信息输入结果</title>
</head>
<body>
<!--#include file="top.asp"-->
<%
Commandtext="INSERT INTO student VALUES('"+name+"','"+studentNo+"','"+sex+"','"+birthday+"','"+minzu+"','"+tuanyuan+"','"+college+"','"+profession+"','"+classId+"','"+studentNo+"','"+peiyanfs+"','"+xuezhi+"','"+ruxuelf+"','"+xueli+"','"+waiyu+"','"+waiyudj+"','"+jikangzk+"','"+zaidu+"','"+address+"','"+phoneNum+"','"+email+"','"+homepage+"','"+text+"')";
Conn.Execute(Commandtext,0,0);
if(Conn.Errors.Count>0)
{
Response.Redirect("errormessage.asp?message=学生添加失败&toUrl=inf_input_student.asp");
}
else
{
Response.Redirect("errormessage.asp?message=学生添加成功&toUrl=inf_input_student.asp");
}
Conn.Close();
Conn=null;
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -