排序方式解決“上下主題”問題（三）

2019-11-18 20:33:06

字體：大中小

來源：轉載

供稿：網友

顯示：（排序)main.asp

--------部分，未經優化處理-------

<%
Const adOpenStatic = 3
Const adLockPessimistic = 2
Set conn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.Recordset")
DBPath=Server.MapPath("../fpdb/massege.mdb")
conn.Open "DRIVER={Microsoft access Driver (*.mdb)};dbq="& DBPath
SQLcmd="Select * From MASSEGE Order By A_OrderID Desc"
RS.Open SQLcmd,conn,adOpenStatic,adLockPessimistic
page = CLng(Request("txtpage"))
RS.PageSize = 30
If Page < 1 Then Page = 1
If page > RS.PageCount Then page = RS.PageCount
RS.AbsolutePage = page
%>
<form action="main.asp" method="get">
<table align="center" border="0" cellspacing="0" cellpadding="0">
<tr>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><a href="speak.asp" target="rbottom"><font color="#0000FF">發言</font></a></td>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><a href="main.asp"><font color="#0000FF">刷新</font></a></td>
<td height="1" style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><font color="#0000FF">留言筆數:<%=RS.RecordCount%></font></td>
<td height="1" style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><font color="#0000FF">總頁數:<%=RS.PageCount%></font></td>
<td height="1" style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><font color="#0000FF">目前頁次:<%=page%></font></td>
<td valign="top" align="left" height="1" style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><font color="#0000FF">轉到<input type="text" name="txtpage" size="2" style="font-size: 8pt; border-style: dotted; border-width: 1">頁</font></td>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00">
<font color="#0000FF">
<%
If page <> 1 Then
Response.Write"<a href=main.asp?txtpage=1>第一頁</a>"%></font></td>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00">
<font color="#0000FF">
<%Response.Write"<a href=main.asp?txtpage="&(page - 1)&">上一頁</a>"%></font></td>
<%
End If
If page <>RS.PageCount Then%><td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00">
<font color="#0000FF">
<%Response.Write"<a href=main.asp?txtpage="&(page + 1)&">下一頁</a>" %></font></td>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><font color="#0000FF"><%Response.Write"<a href=main.asp?txtpage="&RS.PageCount&">最后一頁</a>"
End If
%></font></td>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><a href="pob_massege.asp"><font color="#0000FF">精華</font></a></td>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><a href="baoqian.htm"><font color="#0000FF">檢索</font></a></td>
<%
If application("Ukingliu")="kingliu" Then
aaa="on"
Else
aaa="off"
End If
%>
<td style="border-left: 1 solid #FFFF00; border-right: 1 solid #FFFF00; border-bottom: 2 solid #FFFF00"><font color="#0000FF">本版斑竹：<a href="mailto:kingliuzk@chinaren.com">滄海為水</a><img src="../images/<%=aaa%>.gif" width="15" height="15"></font></td>
</tr>
</table>
</form>
<%For ipage = 1 To RS.PageSize%>
.
.
.
（縮進，省略）
face=RS("A_Face")
mmm=gif&""&face&".gif"
%>
<table align="center" border="0" cellspacing="1" width="750" bgcolor="#BEBEDC">
<tr>
<td style="border-bottom: 1 solid #FFFF00"><%=aaa%>
<ul>
<li><img src="../images/<%=mmm%>"><a href="massege.asp?txtID=<%=RS("A_ID")%>" target="rbottom"><%=Server.HTMLEncode(RS("A_Subject"))%></a>
<%
If RS("A_Text")="" Then
Response.Write"<無內容>"
End If
%>
{ID:<%=RS("A_ID")%>}【<%=RS("A_Name")%>ID:<%=RS("A_NID")%>】<<%=RS("A_Time")%>>『點擊：<%=RS("A_Times")%>』</td>
</tr>
</table>
<%
RS.MoveNext
If RS.EOF Then Exit For
Next
RS.Close
conn.Close

上一篇：建立一個廣告交換及跟蹤系統

下一篇：排序方式解決“上下主題”問題（二）