📄 default.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="const.asp"-->
<!--#include file="inc_menu.asp"-->
<%
dim rs,sql, rs1
dim classid
dim classname
if request.querystring("classid")<>"" then
classid=int(request.querystring("classid"))
else
classid=0
end if
set rs = server.createobject("adodb.recordset")
set rs1=server.createobject("adodb.recordset")
sql="select * from Aclass where classID="&cstr(classid)
rs.open sql,conn,1,1
if not rs.eof then
classname=rs("class")
end if
rs.close
%>
<html>
<head>
<meta NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
<meta HTTP-EQUIV="Content-Type" content="text/html; charset=gb2312">
<meta name="keywords" content="动网先锋,http://www.aspsky.net">
<LINK href="style.css" rel=stylesheet>
<title><%=classname%>|<%=hosturl%></title>
</head>
<body>
<!--#include file="head.inc" -->
<TABLE class="border" cellSpacing=0 cellPadding=4 width="95%" border=0 align=center>
<TR>
<TD class="title">
<%
sql="select class,classid from Aclass"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "还没有任何栏目"
else
do while not rs.eof
%>| <a href="default.asp?classid=<%=rs("classid")%>"><%if cint(rs("classid"))=cint(classid) then%><font color=red><%=rs("class")%></font><%else%><%=rs("class")%><%end if%></a> |
<%
rs.movenext
loop
end if
rs.close
%>
</TD></TR>
<TR>
<TD class="title2">
<%
if classid>0 then
sql="select Nclass,Nclassid from ANclass where classID="&cstr(classid)
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "还没有任何栏目"
else
do while not rs.eof
%><a href="index.asp?classid=<%=classid%>&Nclassid=<%=rs("Nclassid")%>"><%=rs("Nclass")%></a>
<%
rs.movenext
loop
end if
rs.close
end if
%>
</TD></TR>
</table>
<br>
<div align="center">
<center>
<table border="0" width=95% align=center cellspacing="0" cellpadding="1" >
<tr>
<td valign="top" width="25%">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0 align=center>
<TBODY>
<TR>
<TD>
<TABLE class="border" cellSpacing=0 cellPadding=4 width="100%" border=0>
<TR>
<TD class="title" ><b>近期热门文章</b>
</TD></TR>
<TR>
<TD class="tdbg">
<font style=line-height:150%>
<%
function gotTopic(str,strlen)
dim l,t,c, i
l=len(str)
t=0
for i=1 to l
c=Abs(Asc(Mid(str,i,1)))
if c>255 then
t=t+2
else
t=t+1
end if
if t>=strlen then
gotTopic=left(str,i)&"..."
exit for
else
gotTopic=str&" "
end if
next
end function
if classid=0 then hotkind=1
select case hotkind
case "1" sql="SELECT top 10 * FROM article where DateDiff('d',dateandtime,Date())<="&DateNum&" order by hits desc,title"
case "2" sql="SELECT top 10 * FROM article where DateDiff('d',dateandtime,Date())<="&DateNum&" and classid="&classid&" order by hits desc,title"
end select
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.write "近期无更新文章"
else
do while not rs.eof
%>
<a href="list.asp?id=<%=rs("articleid")%>" title="<%=rs("title")%>" target=_top><%=gottopic(rs("title"),25)%></a>[<font color=red><%=rs("hits")%></font>]<br>
<% rs.movenext
loop
end if
rs.close
%>
</font>
</TD></TR>
</table>
</td>
</tr>
</tbody>
</table>
</td>
<td valign="top" width="2%">
</td>
<td width="71%" valign="top">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0 align=center>
<TBODY>
<TR>
<TD >
<TABLE class="border" cellSpacing=0 cellPadding=4 width="100%" border=0>
<TR>
<TD class="title"><B><%=classname%>最新文章</B>
</TD></TR>
<TR>
<TD class="tdbg">
<font style=line-height:150%>
<%
sql="select top 10 "
sql=sql&"article.nkey,article.articleid,article.title,article.dateandtime,article.hits,article.classid,article.Nclassid,ANclass.Nclass "
sql=sql&" from article,ANclass where article.Nclassid=ANclass.Nclassid"
if classid>0 then sql=sql&" and article.classid="&classid
sql=sql&" order by article.articleid desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
%>
没有更新任何文章
<%else%>
<%do while not rs.eof%>
[<a href='index.asp?classid=<%=rs("classid")%>&Nclassid=<%=rs("Nclassid")%>'><%=rs("Nclass")%></a>]
<a href="list.asp?id=<%=rs("articleid")%>" title=<%=left(rs("Nkey"),140)%>><%=rs("title")%></a>
(<%if rs("dateandtime")=date() then%><font color=red><%=month(rs("dateandtime"))%>月<%=day(rs("dateandtime"))%>日</font><%else%><font color='#999999'><%=month(rs("dateandtime"))%>月<%=day(rs("dateandtime"))%>日</font><%end if%>,<font color=green><%=rs("hits")%></font>)
<br>
<%
rs.movenext
loop
end if
rs.close
%>
</font>
</TD></TR>
</table>
</td>
</tr>
</tbody>
</table>
<br>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0 align=center>
<TBODY>
<TR>
<TD >
<TABLE class="border" cellSpacing=0 cellPadding=4 width="100%" border=0>
<TR>
<TD class="title"><B>栏目分类导航</B>
</TD></TR>
<TR>
<TD class="tdbg">
<font style=line-height:150%>
<%
sql="select class,classid from Aclass"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.write "没有任何分类"
else
do while not rs.eof
%>
<a href="default.asp?classid=<%=rs("classid")%>"><%=rs("class")%></a><br>
<%
sql="select Nclass,Nclassid,classid from ANclass where classid="&rs("classid")
rs1.open sql,conn,1,1
do while not rs1.eof
%><a href="index.asp?classid=<%=rs1("classid")%>&Nclassid=<%=rs1("Nclassid")%>"><%=rs1("Nclass")%></a>
<%
rs1.movenext
loop
rs1.close
%>
<br><br>
<%
rs.movenext
loop
end if
rs.close
conn.close
set conn=nothing
%>
</font>
</TD></TR>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</table>
</div>
<!--#include file="foot.inc" -->
<script src="http://www.21dx.com/count/count.asp?view=asp"></script>
</body>
</html> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -