index_article.asp

ASP源码

<%sub index_article()
openarticle
sql="select top "&indexarticle&" art_id,cat_id,art_title,art_date,art_count from art order by art_date DESC"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<div align="center">
  <center>
<table width="98%" border="0" cellspacing="0" bgcolor="#EFEFEF" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0">
  <tr> 
    <td width="43%" bgcolor="#FFFFFF" style="border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1" bordercolor="#808080">
    <font color="#808080">
    <img src="images/pic000/hengtiaoXT.jpg" width="17" height="17" border="0" align="absbottom"><span style="font-size: 9pt"> 
    : :最新文章: :</span></font></td>
    <td width="57%" class="diaryhead" height="23" bgcolor="#EFEFEF" style="border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1" bordercolor="#808080"> 
      <font color="#808080">
      <img border="0" src="images/pic000/hengtiao1.jpg"></font></td>
  </tr>
</table>
  </center>
</div>
<div align="center">
  <center>
<table width="98%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" style="border-collapse: collapse" bordercolor="#111111">
  <tr> 
    <td height="8" bgcolor="#FFFFFF"></td>
  </tr>
</table>
  </center>
</div>
<div align="center">
  <center>
<table width="98%" border="0" cellspacing="0" cellpadding="3" height="22" style="border-collapse: collapse" bordercolor="#111111">
  <%do while not rs.eof
sql="select cat_id,cat_name from a_cat where cat_id="&rs("cat_id")
set rscat=server.createobject("adodb.recordset")
rscat.open sql,conn,1,1%><font color="#666666"> </font>
  <tr> 
    <td bgcolor="#FFFFFF" class="chinese" width="6%" align="center">
    <font color="#666666">
    <img src="images/pic000/shouyeXT1.gif" align="middle"> </font> 
    </td>
    <td bgcolor="#FFFFFF" class="chinese" width="96%" height="22"><a href="showart.asp?art_id=<%=rs("art_id")%>&cat_id=<%=rs("cat_id")%>" title="<%=rs("art_title")%>,发表于<%=rs("art_date")%>,已经被阅读<%=rs("art_count")%>次。" target="_blank"><%=rs("art_title")%></a><font color="#666666">
    </font><font color="#666666">&nbsp;<span style="font-size: 9pt">[</span></font><span style="font-size: 9pt"><a href="article.asp?cat_id=<%=rscat("cat_id")%>" target="_blank"><font color="#666666"><%=rscat("cat_name")%></font></a></span><font color="#666666"><span style="font-size: 9pt">]</span><span style="font-size: 6pt"> 
    (<%=rs("art_date")%>)</span></font></td>
  </tr>
  <tr> 
    <td height="1" colspan="2" background="images/dotlineh.gif" bgcolor="#FFFFFF"></td>
  </tr>
  <%
rscat.close
set rscat=nothing
rs.movenext
loop
if rs.eof and rs.bof then
%><font color="#666666"> </font>
  <tr bgcolor="#E7E3E7"> 
    <td class="chinese" colspan="2" bgcolor="#FFFFFF"><font color="#666666">暂时没有文章！</font></td>
  </tr>
  <%end if%><font color="#666666"> </font>
</table>
  </center>
</div>
<div align="center">
  <center>
<table width="98%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" height="5" style="border-collapse: collapse" bordercolor="#111111">
  <tr> 
    <td align="right" class="chinese" height="1" bgcolor="#FFFFFF"> <a href="article.asp">
    <font color="#666666"><img src="images/more1.gif" width="50" height="17" border="0" alt="More"></font></a><font color="#666666">
    </font> 
    </td>
  </tr>
</table>

  </center>
</div>


<%
rs.close
set rs=nothing
end sub
%>