index_articleclass_index.asp

基于ＡＳＰ的教育网站

<%
Dim RsArticleClass
Dim RsArticleClass_numRows

Set RsArticleClass = Server.CreateObject("ADODB.Recordset")
RsArticleClass.ActiveConnection = MM_connDB_STRING
RsArticleClass.Source = "SELECT * FROM tArticleClass ORDER BY fOrderID ASC"
RsArticleClass.CursorType = 0
RsArticleClass.CursorLocation = 2
RsArticleClass.LockType = 1
RsArticleClass.Open()

RsArticleClass_numRows = 0
%>
<%
'Dim Repeat1__numRows
'Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
RsArticleClass_numRows = RsArticleClass_numRows + Repeat1__numRows
%>

<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
  <% 
While ((Repeat1__numRows <> 0) AND (NOT RsArticleClass.EOF)) 
%>
    <tr>
      <TD vAlign=top><TABLE cellSpacing=0 cellPadding=0 width=99% border=0>
          <TR>
            <TD width="16"><IMG height=41 src="images/index1_1.gif" width=16></TD>
            <TD width=270 background=images/index1_2.gif 
                      height=41><div align="left"><IMG src="images/d5.gif">&nbsp;<%=(RsArticleClass.Fields.Item("fClassName").Value)%></div></TD>
            <TD width="411" background=images/index1_5.gif><div align="left"><IMG 
                        height=41  src="images/index1_4.gif" 
                        width=30></div></TD>
            <TD width=15><IMG height=41  
                        src="images/index1_7.gif" width=14></TD>
          </TR>
          <TR>
            <TD background=images/index1_8.gif></TD>
            <TD vAlign=top background=images/index1_9.gif colSpan=2><%
Dim RsArticleContent__MMColParam
RsArticleContent__MMColParam = RsArticleClass("fID_ArticleClass")
If (Request("MM_EmptyValue") <> "") Then 
  RsArticleContent__MMColParam = Request("MM_EmptyValue")
End If
%>
              <%
Dim RsArticleContent
Dim RsArticleContent_numRows

Set RsArticleContent = Server.CreateObject("ADODB.Recordset")
RsArticleContent.ActiveConnection = MM_connDB_STRING
RsArticleContent.Source = "SELECT * FROM tArticleContent WHERE fID_ArticleClass = " + Replace(RsArticleContent__MMColParam, "'", "''") + " ORDER BY fID_ArticleContent DESC"
RsArticleContent.CursorType = 0
RsArticleContent.CursorLocation = 2
RsArticleContent.LockType = 1
RsArticleContent.Open()

RsArticleContent_numRows = 0
%>
              <%
Dim Repeat2__numRows
Dim Repeat2__index

Repeat2__numRows = 10
Repeat2__index = 0
RsArticleContent_numRows = RsArticleContent_numRows + Repeat2__numRows
%>
              <TABLE  cellSpacing=0 cellPadding=0 width="100%"  border=0>
                <% 
While ((Repeat2__numRows <> 0) AND (NOT RsArticleContent.EOF)) 
%>
                  <TR>
                    <TD height="16" vAlign=bottom bgcolor="#F2F4FD"><div align="left"> &nbsp; &nbsp;<IMG height=8 src="images/dd.gif" width=8 border=0>&nbsp;<A HREF="index_Article_Content.asp?fID_ArticleContent=<%= RsArticleContent.Fields.Item("fID_ArticleContent").Value %>" target="_blank" title="<%=(RsArticleContent.Fields.Item("fTitle").Value)%>
作者：<%=(RsArticleContent.Fields.Item("fAuthor").Value)%>
时间：<%=(RsArticleContent.Fields.Item("fUpdateTime").Value)%>" >
                        <% If len(RsArticleContent.Fields.Item("fTitle").Value)<42 Then %>
                        <%=(RsArticleContent.Fields.Item("fTitle").Value)%>
                        <% Else %>
                        <%=mid((RsArticleContent.Fields.Item("fTitle").Value),1,42)%>…
                        <% End If %>
                        </A> (<%=(RsArticleContent.Fields.Item("fHits").Value)%>)<BR>
                    </div></TD>
                  </TR>
                  <% 
  Repeat2__index=Repeat2__index+1
  Repeat2__numRows=Repeat2__numRows-1
  RsArticleContent.MoveNext()
Wend
%>
                <TR>
                  <TD vAlign=bottom width=488><div align=right><A HREF="index_Article_Class.asp?fID_ArticleClass=<%= RsArticleClass("fID_ArticleClass") %>" target="_blank"><IMG height=17   src="images/more.gif" width=35  border=0></A>&nbsp;</div></TD>
                </TR>
              </TABLE>
              <%
RsArticleContent.Close()
Set RsArticleContent = Nothing
%>
            </TD>
            <TD width=15 background=images/index1_10.gif 
                      height=100></TD>
          </TR>
          <TR>
            <TD><IMG height=18  
                        src="images/index1_11.gif" width=16></TD>
            <TD background=images/index1_12.gif 
                      colSpan=2></TD>
            <TD width=15><IMG height=18  
                        src="images/index1_13.gif" 
                  width=14></TD>
          </TR>
        </TABLE></TD>
    </tr>
    <% 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  RsArticleClass.MoveNext()
Wend
%>
</TABLE>
<%
RsArticleClass.Close()
Set RsArticleClass = Nothing
%>