📄 classinfo.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="Cookies.asp"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<META name=VI60_defaultClientScript content=VBScript>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
.style1 {color: #0000FF}
.style4 {font-size: 14px}
-->
</style>
</head>
<%
if request("xingxing")="del1" then
call del1()
response.end
end if
if request("xingxing")="del" then
call del()
response.end
end if
%>
<%
dim class1_id,class1
class1_id=request.QueryString("class1_id")
Set class1=Server.CreateObject("ADODB.Recordset")
sql="select * from class1 where class1_id=" & class1_id
class1.open sql,conn,1,1
set class2 = Server.CreateObject("ADODB.Recordset")
%>
<body>
<h1 align="center" class="style1">分类信息</h1>
<div align="center">
<table width="685" height="211" border="1">
<tr>
<th width="213" height="66" scope="col"><font color="#FF0000">一级分类：</font></th>
<th width="240" scope="col">
<form action="editclass1.asp?class1_id=<%=class1_id%>" method="post" name="classform" >
<p>名称:<input type="text" name="class1" width="60" height="18" value="<%=class1("class1")%>">
<input name="edit" type="submit" value="修改" ></p>
<p> 排序:<input name="taxis" type="text" width="60" height="18" value="<%=class1("taxis") %>">
<a href="classinfo.asp?xingxing=del1&&class1_id=<%=class1_id%>"><span class="style4"> 删除</span></a> </p>
</form></th>
<th width="253" scope="col"> </th>
</tr>
<%
sql="select * from class2 where class1="&class1_id & " order by taxis desc"
class2.open sql,conn,1
do while not class2.eof
%>
<tr>
<th height="139" scope="row"><%if not class2.eof then%> ID：<%=class2("class2_id")%>
<form action="editclass2.asp?class2_id=<%=class2("class2_id")%>&class1_id=<%=class1_id%>" method="post" name="classform" >
<p align="left">
名称：<input type="text" name="class2" width="60" height="18" value="<%=class2("class2")%>"> <input name="edit" type="submit" value="修改" >
</p>
<div align="left">排序：
<input name="taxis" type="text" width="60" height="18" value="<%=class2("taxis") %>">
<a href="classinfo.asp?xingxing=del&class2_id=<%=class2("class2_id")%>&class1_id=<%=class1_id%>"><span class="style4">删除</span></a><span class="style4"></span></div>
</form>
<% class2.movenext
end if
%></th>
<th height="139" scope="row"><%if not class2.eof then%> ID：<%=class2("class2_id")%>
<form action="editclass2.asp?class2_id=<%=class2("class2_id")%>&class1_id=<%=class1_id%>" method="post" name="classform" >
<p align="left">
名称:<input type="text" name="class2" width="60" height="18" value="<%=class2("class2")%>"> <input name="edit" type="submit" value="修改" ></p>
<div align="left">排序:
<input name="taxis" type="text" width="60" height="18" value="<%=class2("taxis") %>">
<a href="classinfo.asp?xingxing=del&class2_id=<%=class2("class2_id")%>&class1_id=<%=class1_id%>"><span class="style4">
删除</span></a></div>
</form>
<% class2.movenext
end if
%></th>
<th height="139" scope="row"><%if not class2.eof then%> ID：<%=class2("class2_id")%>
<form action="editclass2.asp?class2_id=<%=class2("class2_id")%>&class1_id=<%=class1_id%>" method="post" name="classform" >
<p align="left">
名称：<input type="text" name="class2" width="80" height="18" value="<%=class2("class2")%>">
<input name="edit" type="submit" value="修改" >
</p>
<div align="left">排序：
<input name="taxis" type="text" width="80" height="18" value="<%=class2("taxis") %>">
<a href="classinfo.asp?xingxing=del&class2_id=<%=class2("class2_id")%>&class1_id=<%=class1_id%>"><span class="style4">删除</span></a></div>
</form>
<% class2.movenext
end if
%></th>
</tr>
<%
loop
%>
</table>
<%
class1.close
set class1=nothing
class2.close
set class2=nothing
closedb
%>
</div>
</body>
</html>
<%
sub del
class2_id=request("class2_id")
class1_id=request("class1_id")
sql="delete from class2 where class2_id=" & class2_id
conn.execute(sql)
sql="delete from goods where class2="& class2_id
conn.execute(sql)
sql="delete from info where class2="& class2_id
conn.execute(sql)
response.write "<li>删除二级分类成功！"
response.write "<meta http-equiv=refresh content="&"2;URL=classinfo.asp?class1_id="& class1_id &">"
end sub
sub del1
end sub
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -