📄 inf_modify_student_result.asp

📁 一个修改过的ASP学籍管理系统,用javascript+ado写的

💻 ASP

字号:

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<%
var NUM;
var NAME;
var SEX;
var BOTHDAY;
var RATION;
var POLITY;
var COLLAGE;
var PROFESSION;
var CLASS;
var CLASSNUM;
var PLANT;
var ORDER;
var INTIME;
var GRADE;
var FOREGIN;
var FOREGINGRADE;
var HEALTH;
var READING;
var ADDRESS;
var TELEPHONE;
var EMAIL;
var PERSONALPAGE;
var TEXT;
var StudentRs;
var Commandtext;
NUM=Request.Form("Num");
NAME=Request.Form("Name");
SEX=Request.Form("Sex");
BOTHDAY=Request.Form("Bothyear")+"-"+Request.Form("Bothmonth")+"-"+Request.Form("Bothday");
RATION=Request.Form("Ration");
POLITY=Request.Form("Polity");
COLLAGE=Request.Form("Collage");
PROFESSION=Request.Form("Profession");
CLASS=Request.Form("Class");
CLASSNUM=Request.Form("Classnum");
PLANT=Request.Form("Plant");
ORDER=Request.Form("Order");
INTIME=Request.Form("Intime");
GRADE=Request.Form("Grade");
FOREGIN=Request.Form("Foregin");
FOREGINGRADE=Request.Form("Foregingrade");
HEALTH=Request.Form("Health");
READING=Request.Form("Reading");
ADDRESS=Request.Form("Address");
TELEPHONE=Request.Form("Telephone");
EMAIL=Request.Form("Email");
PERSONALPAGE=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="UPDATE student SET studentNo='"+NUM+"',name='"+NAME+"',sex='"+SEX+"',birthday='"+BOTHDAY+"',minzu='"+RATION+"',zhengzhimm='"+POLITY+"',collegeId='"+COLLAGE+"',professionId='"+PROFESSION+"',classId='"+CLASS+"',peiyangfs='"+PLANT+"',xuezhi='"+ORDER+"',ruxuenianfen='"+INTIME+"',xueli='"+GRADE+"',waiyu='"+FOREGIN+"',waiyushuiping='"+FOREGINGRADE+"',shentizz='"+HEALTH+"',zaiduqk='"+READING+"',address='"+ADDRESS+"',phoneNum='"+TELEPHONE+"',email='"+EMAIL+"',homepage='"+PERSONALPAGE+"',huojiangqk='"+TEXT+"' WHERE studentNo="+NUM;
	   Conn.Execute(Commandtext,0,0);
	   if(Conn.Errors.Count>0)
         {
             Response.Write("<div align=center><font size='6' color='#ff0000'>系统发生"+Conn.Errors.Count+"个错误！</font></div>");
         }
       else
        {
             Response.Write("<div align=center><font size='6' color='#ff0000'>修改成功！</font></div>");
        }

Conn.Close();
Conn=null;
%> 
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -