departmentsave.asp

来自「《动态网页设计基础教程》,胡杰,科学出版社」· ASP 代码 · 共 57 行

ASP
57
字号
<html>

<head>
<link rel="stylesheet" href="comCSS.css">
<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">
<title>管理员信息注册</title>
<meta name="Microsoft Border" content="t, default">
</head>

<body><!--msnavigation--><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td>

<p align="left"> </p>

</td></tr><!--msnavigation--></table><!--msnavigation--><table dir="ltr" border="0" cellpadding="0" cellspacing="0" width="100%"><tr><!--msnavigation--><td valign="top">
<!--#include file="adoconn.asp"-->
<%
 
 Certificate()  
D1=request.form("D1")
t1=request.form("T1")
t2=request.form("T2")

Adoconnection()

if Session("EditFlag")="INSERT" then
   sql="INSERT INTO Departments(DepartmentID,Department,College) "
   sql=sql & "VALUES('" & t1 & "','" & t2 & "','" & D1 & "')"  
else
   sql = "Update Departments Set DepartmentID='" & t1 & "',Department='" & t2 & "',College='" & D1 & "'"
   sql = sql & " Where DepartmentID='" & session("DepartmentID") & "'" 
   Session("EditFlag")="INSERT"     
end if

ADOconn.BeginTrans
ADOconn.Execute sql

if err.number <> 0 then
   ADOconn.rollbacktrans
else
   ADOconn.CommitTrans
end if
ADOconn.close
Set ADOconn=nothing
Response.write "保存成功!            "

%>
<a href="javascript:history.back(1)">返回</a>

<!--msnavigation--></td></tr><!--msnavigation--></table></body>

</html>


⌨️ 快捷键说明

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