📄 change2.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>修改信息|毕业设计选题系统</title>
<link href="../css/Style.css" rel="stylesheet" type="text/css" />
</head>
<BODY leftMargin=0 topMargin=0 marginwidth="0">
<!--#include file=../top.asp-->
<!--#include file=top.asp-->
<div align="center"><td><table width="768" border="0" bgcolor="#FFFFFF"><tr><td><div align="left">
<%
Dim TYP
TYP = Request.QueryString("type")
Dim ID
ID = Request.QueryString("id")
If TYP = "teacher" Then
Dim UNM
Dim TEL
Dim EML
Dim PWD
UNM = Request.Form("textfield2")
TEL = Request.Form("textfield3")
EML = Request.Form("textfield4")
PWD = Request.Form("textfield5")
%>
<%
Dim conn
Set conn=Server.CreateObject("ADODB.RecordSet")
conn.ActiveConnection = "DSN=hw;User ID=sa"
conn.Source = "update dbo.teacher set tea_name='"&UNM&"',tea_tel='"&TEL&"',tea_email='"&EML&"',tea_pass='"&PWD&"' where tea_id='"&ID&"'"
conn.CursorType = 1
conn.LockType = 3
conn.Open()
%>
教师信息修改成功，<a href="list.asp?list=5"> <img src="../image/cc.jpg" width="11" height="11" border="0" /> 点击这里返回教师列表</a>
<%
End If
If TYP = "student" Then
Dim UNM
Dim SEX
Dim SPE
Dim CLA
Dim TEL
Dim EML
Dim QQ
Dim PWD
UNM = Request.Form("textfield2")
SEX = Request.Form("select1")
SPE = Request.Form("select2")
CLA = Request.Form("select3")
TEL = Request.Form("textfield3")
EML = Request.Form("textfield4")
QQ = Request.Form("textfield5")
PWD = Request.Form("textfield6")
%>
<%
Dim conn2
Set conn2=Server.CreateObject("ADODB.RecordSet")
conn2.ActiveConnection = "DSN=hw;User ID=sa"
conn2.Source = "update dbo.student set stu_name='"&UNM&"',stu_sex='"&SEX&"',stu_speciality='"&SPE&"',stu_class='"&CLA&"',stu_tel='"&TEL&"',stu_email='"&EML&"',stu_qq='"&QQ&"',stu_pass='"&PWD&"' where stu_id='"&id&"'"
conn2.CursorType = 1
conn2.LockType = 3
conn2.Open()
set conn2=Nothing
%>
学生信息修改成功，<a href="list.asp?list=6"> <img src="../image/cc.jpg" width="11" height="11" border="0" /> 点击这里返回学生列表</a>
</div></td></tr></table></td></div>
<!--#include file=botton.asp-->
<!--#include file=../botton.asp-->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -