📄 updatasource_four.asp
字号:
<!--#include file ="../include.asp"-->
<%
StartPage "修改题目确认首页",2
%>
<!--
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<link rel="stylesheet" type="text/css" href="../default.css">
<BODY leftmargin=150 rightmargin=150 topmargin=30>
<IMG src="../images/title.JPG" border=0>
<hr>
<br>
-->
<table border="1" cellpadding="0" cellspacing="0" style="BORDER-COLLAPSE: collapse" bordercolor="lightskyblue" width="90%" align=center>
<tr>
<td height=20 bgcolor=LightSkyBlue></td>
</tr>
<tr>
<td align=center>
<table border=0 width="90%">
<tr>
<td colspan=2></td>
</tr>
<tr>
<td align=center colspan=2>
<font size=7 color=LightSkyBlue>管理员修改题目页</font>
</td>
</tr>
<tr>
<td align=left width="30%"><b><font size=4 color=LightSkyBlue>修改流程</font></b></td>
<td></td>
</tr>
<tr>
<td align=center><b><font size=4 color=LightSkyBlue>选择科目名</font></b></td>
<td align=center></td>
</tr>
<tr>
<td align=center><b><font size=4 color=LightSkyBlue>选择题目名</font></b></td>
<td align=center>
<%
TableName = Request.Form ("TableName")
UpDateNo = Request.Form ("No")
Descrip = Request.Form ("Descrip")
Allgoal = Request.Form ("AllSource")
Smallgoal = Request.Form ("SmallSource")
Object = Request.Form("Object")
set conn = Server.CreateObject ("adodb.connection")
conn.Open "NetExamine","sa",""
set userconn = Server.CreateObject ("adodb.recordset")
sqlstr = "update " + TableName + " set 题目描述 = '" +Descrip+"',题目总分 = " +Allgoal+",小题得分 = "+Smallgoal+" where 索引号 = " + UpDateNo
userconn.Open sqlstr,conn
Response.Write "<b><font size = 4 color = lightskyblue>您的修改已经成功,请返回功能主页</font></b>"
Response.Write "<br><a href = AdminFunction.asp>返回</a>"
set userconn = nothing
conn.Close ()
set conn = nothing
%>
</td>
</tr>
<tr>
<td align=center><b><font size=4 color=LightSkyBlue>填写修改项</font></b></td>
<td align=center></td>
</tr>
<tr>
<td align=center><b><font size=4 color=LightSkyBlue>修改确定</font></b></td>
<td align=center></td>
</tr>
<tr>
<td colspan=2>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height=20 bgcolor=LightSkyBlue></td>
</tr>
</table>
<%
'TableName = Request.Form ("TableName")
'UpDateNo = Request.Form ("No")
'Descrip = Request.Form ("Descrip")
'Allgoal = Request.Form ("AllSource")
'Smallgoal = Request.Form ("SmallSource")
'Object = Request.Form("Object")
'set conn = Server.CreateObject ("adodb.connection")
'conn.Open "NetExamine","sa",""
'set userconn = Server.CreateObject ("adodb.recordset")
'sqlstr = "update " + TableName + " set 题目描述 = '" +Descrip+"',题目总分 = " +Allgoal+",小题得分 = "+Smallgoal+" where 索引号 = " + UpDateNo
'Response.Write (sqlstr)
'Response.End ()
'userconn.Open sqlstr,conn
'userconn.Close()
'conn.Close ()
'Response.Write "<b><font size = 6 color = lightskyblue>您的修改已经成功,请返回功能主页</font></b>"
'Response.Write "<br><a href = AdminFunction.asp>返回</a>"
%>
<!--
<br>
<hr>
<center>
<font size=2>
欢迎来到本网站,最佳分辨率:800×600
<br>如果有困难请与我联系:FD_FYY@hotmail.com
</font>
</center>
</BODY>
</HTML>
-->
<%
EndPage
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -