saveanclass.asp

来自「简单整站程序」· ASP 代码 · 共 42 行

<!--#include virtual="/include/check.asp"-->
<% CheckAdminIsLogin("信息管理") %>
<!--#include virtual="/include/conn.asp"-->

<%dim action,anclassid
anclassid=request.QueryString("id")
action=request.querystring("action")
select case action
'//添加新数据
case "add" 
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from anclass",conn,1,3
rs.AddNew
rs("classname")=trim(request("anclass2"))
rs("anclassidorder")=int(request("anclassidorder2"))
rs("anweb")=trim(request("nweb"))
rs.Update
rs.Close
set rs=nothing
response.Redirect "anclass.asp"
'//修改数据
case "edit"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from anclass where anclassid="&anclassid,conn,1,3
rs("classname")=trim(request("anclass"))
rs("anclassidorder")=int(request("anclassidorder"))
rs("anweb")=trim(request("anweb"))
rs.Update
rs.Close
set rs=nothing
response.Redirect "anclass.asp"
'//删除数据 和他关联的数据也删除
case "del"
conn.execute ("delete from anclass where anclassid="&anclassid)
conn.execute ("delete from nclass where anclassid="&anclassid)
conn.execute ("delete from Product where classid="&anclassid)
response.Redirect "anclass.asp"
end select
%>