rulesave.asp

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

ASP
60
字号
<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 4.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 border="0" cellpadding="0" cellspacing="0" width="100%"><tr><!--msnavigation--><td valign="top">
<!--#INCLUDE FILE="ADOCONN.ASP"-->
<%

Certificate()
t0=request.form("T0")
t1=request.form("T1")
t2=request.form("S1")
t3=request.form("T2")
t4=request.form("T3")
t5=request.form("R1")
t6=Session("Termyear")
t7=Session("Term")

if Session("EditFlag")="INSERT" then
   sql="INSERT INTO TestRules(CategoryID,Category,Content,Score,Weight,Kind,Yeartoyear,Term) "
   sql=sql & "VALUES('" & t0 & "','" & t1 & "','" & t2 & "'," & cstr(t3) & "," & cstr(t4) & ",'" & t5 & "','" & t6 & "','" & t7 & "')"  
else
   sql="Update TestRules Set CategoryID='" & t0 & "', Category='" & t1 & "',Content='" & t2 & "',Score=" & cstr(t3) & ",Weight=" & cstr(t4) & ",Kind='" & t5 & "',Yeartoyear='" & t6 & "',Term='" & t7 & "'" 
   sql=sql & " Where Category='" & Session("Category") & "'"
   Session("EditFlag")="INSERT"
end if

Adoconnection()

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 + -
显示快捷键?