📄 showsub.asp
字号:
<HTML>
<HEAD>
<link rel="stylesheet" type="text/css" href="../jgwy.css">
<TITLE></TITLE>
</HEAD>
<BODY bgColor="#f7fdff">
<% catname = Request.QueryString("parent")%>
<CENTER>
<%=catname%><br>
<%
cat = Request.QueryString("CatID")
status = Request.QueryString("status")
Conn_String ="Provider=sqloledb;" & "Data Source=127.0.0.1;Initial Catalog=qiye_8;User Id=sa;Password=password;"
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open Conn_String
sql = "SELECT * From subcat where CatID='" & cat & "' order by SubcatID"
set rs = Conn.Execute (sql)
%>
</center>
<CENTER>
<table border="1" cellspacing=5>
<tr>
<%if status = "delete" then%>
<%
Do while NOT rs.EOF
ColNum = 1
Do while ColNum < 3
%>
<TD ALIGN=LEFT VALIGN=top ><font face="宋体" size=2><b><a href="showlink.asp?CatID=<%=rs("subcatid")%>&status=<%=status%>&subname=<%=rs("subcatname")%>&parentname=<%=catname%>"><%=rs("subcatname")%> </a></b></font>
<%
sSQL = "SELECT count(url) FROM link2 where category='" & rs("subcatid") & "'"
Set RScount = Conn.Execute(sSQL)
rcount = RScount(0)
Response.Write ("(" & rcount & ")")
%>
</TD>
<%
if NOT rs.EOF then
rs.MoveNext
end if
ColNum = ColNum + 1
if NOT rs.EOF then
%>
<TD ALIGN=LEFT VALIGN=top ><font face="宋体" size=2><b><a href="showlink.asp?CatID=<%=rs("subcatid")%>&status=<%=status%>&subname=<%=rs("subcatname")%>&parentname=<%=catname%>"><%=rs("subcatname")%> </a></b></font>
<%
sSQL = "SELECT count(url) FROM link2 where category='" & rs("subcatid") & "'"
Set RScount = Conn.Execute(sSQL)
rcount = RScount(0)
Response.Write ("(" & rcount & ")")
%>
</TD>
<%
end if
ColNum = ColNum + 1
Loop
%>
</TR>
<%
if NOT rs.EOF then
rs.MoveNext
end if
Loop
else
%>
<%
Do while NOT rs.EOF
ColNum = 1
Do while ColNum < 3
%>
<TD ALIGN=LEFT VALIGN=top ><font face="宋体" size=2><b><a href="showlink.asp?CatID=<%=rs("subcatid")%>&subname=<%=rs("subcatname")%>&parentname=<%=catname%>"><%=rs("subcatname")%> </a></b></font>
<%
sSQL = "SELECT count(url) FROM link2 where category='" & rs("subcatid") & "'"
Set RScount = Conn.Execute(sSQL)
rcount = RScount(0)
Response.Write ("(" & rcount & ")")
%>
</TD>
<%
if NOT rs.EOF then
rs.MoveNext
end if
ColNum = ColNum + 1
if NOT rs.EOF then
%>
<TD ALIGN=LEFT VALIGN=top ><font face="宋体" size=2><b><a href="showlink.asp?CatID=<%=rs("subcatid")%>&subname=<%=rs("subcatname")%>&parentname=<%=catname%>"><%=rs("subcatname")%> </a></b></font>
<%
sSQL = "SELECT count(url) FROM link2 where category='" & rs("subcatid") & "'"
Set RScount = Conn.Execute(sSQL)
rcount = RScount(0)
Response.Write ("(" & rcount & ")")
%>
</TD>
<%
end if
ColNum = ColNum + 1
Loop
%>
</TR>
<%
if NOT rs.EOF then
rs.MoveNext
end if
Loop
end if
%>
</TABLE>
<% rs.close
Conn.Close
set Conn = nothing
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -