📄 addteacher2.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 TEAM
Dim UID1
Dim PWD1
Dim UID2
Dim PWD2
TEAM = Request.Form("textfield1")
UID1 = Request.Form("textfield2")
PWD1 = Request.Form("textfield3")
UID2 = Request.Form("textfield4")
PWD2 = Request.Form("textfield5")
Dim conn
Set conn=Server.CreateObject("ADODB.RecordSet")
conn.ActiveConnection = "DSN=hw;User ID=sa"
conn.Source = "select * from dbo.teacher where tea_group='"&TEAM&"'"
conn.CursorType = 0
conn.LockType = 1
conn.Open()
If not(conn.eof or conn.bof) Then
conn.Close()
Set conn = Nothing
response.write"<p class='notetext'>添加失败</p><p>小组 "&TEAM&" 已经被注册<br>请使用其它小组编号。</p><a href='javascript:history.back()'> <img src='../image/cc.jpg' width='11' height='11' border='0' /> 点击此处返回首页</a>"
Else
Set conn = Nothing
Dim conn2
Set conn2=Server.CreateObject("ADODB.RecordSet")
conn2.ActiveConnection = "DSN=hw;User ID=sa"
conn2.Source = "dbo.teacher"
conn2.CursorType = 1
conn2.LockType = 3
conn2.Open()
conn2.addnew
conn2("tea_name") = UID1
conn2("tea_pass") = PWD1
conn2("tea_lv") = "2"
conn2("tea_group") = TEAM
conn2.update
conn2.Close()
Set conn3 = Nothing
Dim conn3
Set conn3=Server.CreateObject("ADODB.RecordSet")
conn3.ActiveConnection = "DSN=hw;User ID=sa"
conn3.Source = "dbo.teacher"
conn3.CursorType = 1
conn3.LockType = 3
conn3.Open()
conn3.addnew
conn3("tea_name") = UID2
conn3("tea_pass") = PWD2
conn3("tea_lv") = "1"
conn3("tea_group") = TEAM
conn3.update
conn3.Close()
Set conn2 = Nothing
response.write"<p>添加成功</p><p>教师 "&UID1&" 和 "&UID2&" 添加成功</p><a href='list.asp?list=5'> <img src='../image/cc.jpg' width='11' height='11' border='0' /> 点击刷新注册教师列表</a>"
End If
%>
</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 + -