brand_action.asp

自己做的鞋业网站代码

<!--#include file="conn.asp"--> 
<%  

set rs = server.CreateObject("adodb.recordset")

action = request("action")
brandid = request("brandid")
brand = request("brand")   
if action = "add" then

	sql="select * from sort"
	rs.open sql,conn,3,3
	rs.addnew
	rs("number")=brandid
	rs("sort_name")=brand
	rs.Update
	rs.close 
	msg = "New record input success!"
elseif action = "edit" then  
	sql="select * from sort where number='"&brandid&"'"
	rs.open sql,conn,3,3
	rs("sort_name")=brand
	rs.Update
	rs.close 
	msg = "Alter record success!" 
elseif action="del" then  
	sql="update hw set tuijian=0 where sort_name in(select sort_name from sort where number='"&brandid&"')" 
	conn.execute(sql)
	sql="delete from sort where number='"&brandid&"'" 
	conn.execute(sql)
	 
	msg="One brand has deleted."	
else

	if result = 0 then
		if action = "edit" then
			msg = "Alter success"
		elseif action = "del" then
			msg = "Delete success"
		end if 
	end if
end if
 

set rs=nothing 

if err.number <> 0  then
	msg = "Fail,errorcode:" & err.number
end if
%>

<script language="javascript">
	window.alert("<%=msg%>");
	window.opener.parent.left.location.reload();
	self.close();
</script>