scmanage.asp

网络商城系统

<!--#include file="session.asp"-->
<!--#include file="conn.asp"-->
<%dim action,id
action=request.querystring("action")
id=request.queryString("id")
select case action
'//添加
case "add" 
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from smallclass",conn,1,3
rs.AddNew
rs("scname")=trim(request("scadd"))
rs("bcid")=id
rs.Update
rs.Close
set rs=nothing
response.Redirect "bigclass.asp"
'//重命名
case "rename"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from smallclass where scid="&id,conn,1,3
rs("scname")=trim(request("scname"))
rs.Update
rs.Close
set rs=nothing
response.Redirect "bigclass.asp"
'//删除
case "del"
conn.execute "delete from smallclass where scid="&id
conn.execute "delete from goods where sclassid="&id
response.Redirect "bigclass.asp"
end select
%>