📄 classmana1.asp
字号:
<%@ CODEPAGE = "936" %>
<!--#include file="users.asp" -->
<!--#include file="jl.asp" -->
<%
dim sql
dim rs
dim cmdTemp
select case request.form("options")
case "rename"
on error resume next
Set cmdTemp = Server.CreateObject("ADODB.Command")
set rs=server.createobject("adodb.recordset")
cmdTemp.CommandText = "SELECT * FROM class where classid=" & request.form("subject")
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = conn
rs.Open cmdTemp, , 1, 3
if err.Number<>0 then
err.clear
response.write " 数 据 库 操 作 失 败 ! "
else
rs("class") = request.form("reTitle")
rs.Update
rs.Close
set rs=nothing
set cmdTemp=nothing
finished
end if
case "del"
Rem 删除栏目
sql="delete from class where classid=" & request.form("subject")
conn.execute sql
Rem 删除相关栏目下子栏目
sql="delete from Nclass where classid=" & request.form("subject")
conn.execute sql
Rem 删除相关栏目对应程序
sql="delete from download where classid=" & request.form("subject")
conn.execute sql
if err.Number<>0 then
err.clear
response.write " 数 据 库 操 作 失 败 ! "
else
finished
end if
case "new"
on error resume next
Set cmdTemp = Server.CreateObject("ADODB.Command")
set rs=server.createobject("adodb.recordset")
cmdTemp.CommandText = "SELECT * FROM class where (classid IS NULL)"
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = conn
rs.Open cmdTemp, , 1, 3
if err.Number<>0 then
err.clear
response.write " 数 据 库 操 作 失 败 ! "
else
rs.AddNew
rs("class") = request.form("newTitle")
rs.Update
rs.Close
set rs=nothing
set cmdTemp=nothing
finished
end if
end select
sub finished()
%>
<html>
<head>
<title>修改成功</title>
<meta http-equiv="refresh" content='0; URL=classmana.asp'>
</head>
<body>
<p align="center"><b>类别修改成功！</b></p>
<%
end sub
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -