📄 change.asp

📁 本系统基于WEB
💻 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 conn
Set conn=Server.CreateObject("ADODB.RecordSet")
conn.ActiveConnection = "DSN=hw;User ID=sa"
conn.Source = "select * from dbo.teacher where tea_id='"&ID&"'"
conn.CursorType = 0
conn.LockType = 1
conn.Open()
%>
正在修改 <% Response.Write(conn("tea_name")) %> 的信息
<form id="form1" name="form1" method="post" action="change2.asp?type=teacher&id=<% Response.Write(id) %>">
  <label>编号：
  <input class="input_kuang" onmouseover="this.style.background='#D6DFF7';" onfocus="this.select(); " onmouseout="this.style.background='#FFFFFF'" name="textfield1" type="text"  value="<% Response.Write ID %>" readonly />
  </label>
  此项不能修改<br>
  <label>姓名：
  <input class="input_kuang" onmouseover="this.style.background='#D6DFF7';" onfocus="this.select(); " onmouseout="this.style.background='#FFFFFF'" name="textfield2" type="text" value="<% Response.Write(conn("tea_name")) %>" maxlength="4" />
  </label>
  * 输入姓名，四个汉字之内 <br>
  <label>电话：
  <input class="input_kuang" onmouseover="this.style.background='#D6DFF7';" onfocus="this.select(); " onmouseout="this.style.background='#FFFFFF'" name="textfield3" type="text" value="<% Response.Write(conn("tea_tel")) %>" maxlength="20" />
  </label>
  至多20个字符<br>
  <label>邮件：
  <input class="input_kuang" onmouseover="this.style.background='#D6DFF7';" onfocus="this.select(); " onmouseout="this.style.background='#FFFFFF'" name="textfield4" type="text" value="<% Response.Write(conn("tea_email")) %>" maxlength="20" />
  </label>
  至多20个字符<br>
  <label>密码：
  <input class="input_kuang" onmouseover="this.style.background='#D6DFF7';" onfocus="this.select(); " onmouseout="this.style.background='#FFFFFF'" name="textfield5"  type="text" value="<% Response.Write(conn("tea_pass")) %>" />
  </label>
  * 密码不可留空<br>
<label>
等级：
<select name="select1">
    <option value="2" <%If (Not isNull(conn("tea_lv"))) Then If ("2" = CStr(conn("tea_lv"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>教授</option>
    <option value="1" <%If (Not isNull(conn("tea_lv"))) Then If ("1" = CStr(conn("tea_lv"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>讲师</option>
  </select>
<input type="submit" name="Submit1" value="提交" />
</label>
<label>
<input type="reset" name="Submit2" value="重置" />
</label>
</form>
<p class="notetext">注：带 * 号的项目必须填写</p>
<%
conn.Close()
Set conn = Nothing
End If
%>
<%
If TYP = "student" Then
Dim conn2
Set conn2=Server.CreateObject("ADODB.RecordSet")
conn2.ActiveConnection = "DSN=hw;User ID=sa"
conn2.Source = "select * from dbo.student where stu_id='"&ID&"'"
conn2.CursorType = 0
conn2.LockType = 1
conn2.Open()
%>
正在修改 <% Response.Write(conn2("stu_name")) %> 
的信息
<form id="form2" name="form2" method="post" action="change2.asp?type=student&id=<% Response.Write(id) %>" onSubmit="return Check()">
  <label>学号：
  <input class="input_kuang" onmouseover="this.style.background='#D6DFF7';" onfocus="this.select(); " onmouseout="this.style.background='#FFFFFF'" name="textfield1" type="text"  value="<% Response.Write(conn2("stu_id")) %>" readonly />
  </label>
  此项不能修改<br>
  <label>姓名：
  <input class="input_kuang" onmouseover="this.style.background='#D6DFF7';" onfocus="this.select(); " onmouseout="this.style.background='#FFFFFF'" name="textfield2" type="text" value="<% Response.Write(conn2("stu_name")) %>" maxlength="4" />
  </label>
  * 输入姓名，四个汉字之内 <br>
  <label>性别：
  <select name="select1">
    <option value="男" <%If (Not isNull(conn2("stu_sex"))) Then If ("男" = CStr(conn2("stu_sex"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>男</option>
    <option value="女" <%If (Not isNull(conn2("stu_sex"))) Then If ("女" = CStr(conn2("stu_sex"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>女</option>
  </select>
  </label><br>
  <label>专业：
  <select name="select2">
    <option value="电子商务" <%If (Not isNull(conn2("stu_speciality"))) Then If ("电子商务" = CStr(conn2("stu_speciality"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>电子商务</option>
    <option value="计科" <%If (Not isNull(conn2("stu_speciality"))) Then If ("计科" = CStr(conn2("stu_speciality"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>计科</option>
    <option value="光信" <%If (Not isNull(conn2("stu_speciality"))) Then If ("光信" = CStr(conn2("stu_speciality"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>光信</option>
    <option value="营销" <%If (Not isNull(conn2("stu_speciality"))) Then If ("营销" = CStr(conn2("stu_speciality"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>营销</option>
    <option value="电信" <%If (Not isNull(conn2("stu_speciality"))) Then If ("电信" = CStr(conn2("stu_speciality"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>电信</option>
  </select>
  </label><br>  
  <label>班级：
  <select name="select3">
    <option value="0501" <%If (Not isNull(conn2("stu_class"))) Then If ("一班" = CStr(conn2("stu_class"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>0501</option>
    <option value="0502" <%If (Not isNull(conn2("stu_class"))) Then If ("二班" = CStr(conn2("stu_class"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>0502</option>
    <option value="0503" <%If (Not isNull(conn2("stu_class"))) Then If ("三班" = CStr(conn2("stu_class"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>0503</option>
    <option value="0504" <%If (Not isNull(conn2("stu_class"))) Then If ("四班" = CStr(conn2("stu_class"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>0504</option>
    <option value="0505" <%If (Not isNull(conn2("stu_class"))) Then If ("五班" = CStr(conn2("stu_class"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>0505</option>
    <option value="0506" <%If (Not isNull(conn2("stu_class"))) Then If ("六班" = CStr(conn2("stu_class"))) Then Response.Write("selected=""selected""") : Response.Write("")%>>0506</option>
  </select>
  </label><br>
  <label>电话：
  <input class="input_kuang" onmouseover="this.style.background='#D6DFF7';" onfocus="this.select(); " onmouseout="this.style.background='#FFFFFF'" name="textfield3" type="text" value="<% Response.Write(conn2("stu_tel")) %>" maxlength="20" />
  </label>
  至多20个字符<br>
  <label>邮件：
  <input class="input_kuang" onmouseover="this.style.background='#D6DFF7';" onfocus="this.select(); " onmouseout="this.style.background='#FFFFFF'" name="textfield4" type="text" value="<% Response.Write(conn2("stu_email")) %>" maxlength="20" />
  </label>
  至多20个字符<br>
  <label>Q Q ：
  <input class="input_kuang" onmouseover="this.style.background='#D6DFF7';" onfocus="this.select(); " onmouseout="this.style.background='#FFFFFF'" name="textfield5" type="text" value="<% Response.Write(conn2("stu_qq")) %>" maxlength="9"/>
  </label>
  至多9个字符<br>
  <label>密码：
  <input class="input_kuang" onmouseover="this.style.background='#D6DFF7';" onfocus="this.select(); " onmouseout="this.style.background='#FFFFFF'" name="textfield6"  type="text" value="<% Response.Write(conn2("stu_pass")) %>"/>
  </label>
输入密码<br>
<label>
<input type="submit" name="Submit1" value="提交" />
</label>
<label>
<input type="reset" name="Submit2" value="重置" />
</label>
</form>
<p class="notetext">注：带 * 号的项目必须填写</p>
<%
conn2.Close()
Set conn2 = Nothing
End If
%>
</div></td></tr></table></td></div>
  <!--#include file=botton.asp-->
  <!--#include file=../botton.asp-->
</body>
</html>
💿 文件大小 4979 K
👤 上传用户 yubo0808140725
📂 所属分类教育系统应用
🏷️ 相关标签

#WEB
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -