📄 adminpro.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="inc/sessionadmin.asp"-->
<%
ProName=Request.Form("ProName")
ProName1=Request.Form("ProName1")
ProName2=Request.Form("ProName2")
ProName3=Request.Form("ProName3")
IF ProName<>"" Then
SQL="Select * From specialty Where specialty='"& ProName &"'"
Set RS=Server.CreateObject("ADODB.Recordset")
RS.Open SQL,Connstr,3,2
IF RS.EOF Then
RS.Addnew
RS("specialty")=ProName
RS.Update
End IF
End IF
IF ProName1<>"" Then
IF ProName2<>"" Then
SQL="Select * From specialty Where specialty='"& ProName1 &"'"
Set RS=Server.CreateObject("ADODB.Recordset")
RS.Open SQL,Connstr,3,2
IF not RS.EOF Then
SQL="Select * From specialty Where specialty='"& RS("specialty") &"'"
Set RS1=Server.CreateObject("ADODB.Recordset")
RS1.Open SQL,Connstr,3,2
IF Not RS1.EOF Then
RS("specialty")=ProName2
RS.Update
END IF
End IF
End IF
End IF
IF ProName3<>"" Then
SQL="Delete * From specialty Where ID=" & Int(ProName3)
Set RS=Server.CreateObject("ADODB.Recordset")
RS.Open SQL,Connstr,3,2
SQL="Delete * From class Where specialty=" & Int(ProName3)
Set RS=Server.CreateObject("ADODB.Recordset")
RS.Open SQL,Connstr,3,2
SQL="Delete * From [user] Where speciality=" & Int(ProName3)
Set RS=Server.CreateObject("ADODB.Recordset")
RS.Open SQL,Connstr,3,2
End IF
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<!--#include file="inc/css.asp"-->
<title><%=WebSiteName%></title>
</head>
<body topmargin="0" background="images/bg.gif">
<!--#include file="admintop.asp"-->
<div align="center">
<center>
<table border="0" width="755" cellspacing="0" cellpadding="0">
<tr>
<td width="189" style="background-color: #FFFFFF; border-left: 1 solid #000000; border-top: 1 solid #000000; border-bottom: 1 solid #000000" valign="top">
<!--#include file="aleft.asp"-->
</td>
<td width="562" style="background-color: #FFFFFF; border: 1 solid #000000" valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" height="25" bgcolor="#EDEDED" style="border-bottom: 1 solid #000000;">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<p align="center">专业添加与管理</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" valign="top">
<div align="center">
<table border="0" width="90%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" height="8"></td>
</tr>
<center>
<tr>
<td width="100%" valign="bottom" style="background-color: #EDEDED; border-top: 1 solid #000000; border-bottom: 1 solid #000000;" height="20">专业添加与管理-->>专业添加</td>
</tr>
</center>
<tr>
<td width="100%" valign="middle" align="right">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<form action="" method="post">
<tr>
<td width="24%" valign="middle" align="right">
<p align="right" style="margin-top: 10; margin-bottom: 10">增加新的专业名称：</td>
<td width="44%">
<p style="margin-top: 10; margin-bottom: 10"><input type=text name="ProName" size=12 maxlength=12 style="background-attachment: scroll; background-repeat: repeat; font-size: 9pt; height: 18; width: 120; background-color: #FFFFFF; border: 1 solid #000000; background-position: none 0%"></td>
<td width="32%">
<p style="margin-top: 10; margin-bottom: 10"><INPUT type=submit value=' 添 加 ' name=Submit style="background-color: #DDDDDD; background-repeat: repeat; background-attachment: scroll; font-size: 9pt; height: 18; width: 85; border: 1px groove #000000; background-position: 0% 50%"></td>
</tr>
</form>
</table>
</td>
</tr>
<center>
<center>
<tr>
<td width="100%" valign="bottom" style="background-color: #EDEDED; border-top: 1 solid #000000; border-bottom: 1 solid #000000;" height="20">专业添加与管理-->>专业改名</td>
</tr>
</center>
</center>
<tr>
<td width="100%">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<form action="" method="post">
<tr>
<td width="6%">
<p style="margin-top: 10; margin-bottom: 10" align="right">将：</td>
<center>
<td width="22%">
<p style="margin-top: 5; margin-bottom: 5"><select size="1" name="ProName1" style="background-attachment: scroll; background-repeat: repeat; font-size: 9pt; height: 19; width: 108; background-color: #FFFFFF; border: 1 solid #000000; background-position: none 0%">
<%
SQL="Select * From specialty"
Set RS=Server.CreateObject("ADODB.Recordset")
RS.Open SQL,Connstr,1,1
Do While Not RS.EOF
%>
<option value="<%=RS("specialty")%>"><%=RS("specialty")%></option>
<%
RS.MoveNext
LooP
%>
</select></td>
<td width="10%">
<p style="margin-top: 10; margin-bottom: 10">改名为：</td>
<td width="30%">
<p style="margin-top: 10; margin-bottom: 10"><input type=text name="ProName2" size=12 maxlength=12 style="background-attachment: scroll; background-repeat: repeat; font-size: 9pt; height: 18; width: 96; background-color: #FFFFFF; border: 1 solid #000000; background-position: none 0%"></td>
<td width="32%">
<p style="margin-top: 10; margin-bottom: 10"><INPUT type=submit value=' 修 改 ' name=Submit style="background-color: #DDDDDD; background-repeat: repeat; background-attachment: scroll; font-size: 9pt; height: 18; width: 85; border: 1px groove #000000; background-position: 0% 50%">
</td>
</tr>
</table>
</center>
</td>
</tr>
</form>
<center>
</center>
<center>
<tr>
<td width="100%" valign="bottom" style="background-color: #EDEDED; border-top: 1 solid #000000; border-bottom: 1 solid #000000;" height="20">专业添加与管理-->>专业割除</td>
</tr>
</center>
<tr>
<td width="100%" height="8">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<form action="" method="post">
<tr>
<td width="6%">
<p style="margin-top: 10; margin-bottom: 10" align="right">将：</td>
<td width="22%">
<p style="margin-top: 10; margin-bottom: 10"><select size="1" name="ProName3" style="background-attachment: scroll; background-repeat: repeat; font-size: 9pt; height: 19; width: 108; background-color: #FFFFFF; border: 1 solid #000000; background-position: none 0%">
<%
SQL="Select * From specialty"
Set RS=Server.CreateObject("ADODB.Recordset")
RS.Open SQL,Connstr,1,1
Do While Not RS.EOF
%>
<option value="<%=RS("ID")%>"><%=RS("specialty")%></option>
<%
RS.MoveNext
LooP
%>
</select></td>
<td width="40%">
<p style="margin-top: 10; margin-bottom: 10">从专业中割除。</td>
<td width="32%">
<p style="margin-top: 10; margin-bottom: 10"><INPUT type=submit value=' 割 除 ' name=Submit style="background-color: #DDDDDD; background-repeat: repeat; background-attachment: scroll; font-size: 9pt; height: 18; width: 85; border: 1px groove #000000; background-position: 0% 50%">
</td>
</tr>
</form>
</table>
</td>
</tr>
<tr>
<td width="100%" height="8">
<p>
</td>
</tr>
<center>
</table>
</center>
</div>
</td>
</tr>
<tr>
<td width="100%" valign="top" height="8">
<p>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -