?? saylist.asp
字號:
<!--#include file="security.asp"-->
<%
dim DBPath,objDB
Set objDB = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("../isi/xlist.asp")
objDB.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
Dim Title,SQLStr,RS,PageNO,PageSize,AllCount,MaxPage,i
Set rs = Server.CreateObject("ADODB.RecordSet")
%>
<html>
<head>
<link rel="stylesheet" href="../inc/style.css">
</head>
<body>
<br><br>
<center>
<table border="0" cellpadding="0" cellspacing="0" width="100%" background="images/bg2.gif">
<tr>
<td width="100%" align="center">
<table border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" width="100%">
<tr bgcolor="#dddddd">
<td><b>對方ID</b></td>
<td><b>內容</b></td>
<td><b>公告</b></td>
<td><b>發布時間</b></td>
<td><b>刪除</b></td>
</tr>
<%
If Not IsEmpty(Request("PageNO")) Then
PageNO=cint(Request("PageNO"))
Else
PageNO=1
End If
SQLStr = "Select * From Adminsay Order By ID DESC"
PageSize =12
rs.PageSize =PageSize
rs.Open SQLStr,objDB,1,3
AllCount = rs.RecordCount
MaxPage = rs.PageCount
If rs.RecordCount > 0 Then
rs.MoveFirst
rs.AbsolutePage = PageNO
End If
i=0
DO While Not rs.EOF and i<PageSize
%>
<tr bgcolor="#FFFFFF">
<td><a href="adminread.asp?user_id=<%=rs("user_id")%>" target="_blank"><%=rs("user_id")%></a></td>
<td><%=rs("contents")%></td>
<td>
<%if rs("ToAll")=True then%>
是
<% end if %>
</td>
<td><%=rs("PutTime")%></td>
<td><a href="Delsaying.asp?ID=<%=rs("id")%>">刪除</a></td>
</tr>
<% i=i+1
rs.MoveNext
Loop
rs.Close
%>
</table>
<table border="0" cellpadding="0" width="100%" cellspacing="0" height="30">
<tr>
<td>共 <font color=red><b><%=AllCount%></b></font> 個通知 頁次: <font color=red><b><%=PageNO%></b></font> / <b><%=MaxPage%></b> 頁</td>
<td align=right>
<a href="AdminSayto.asp" class="a03">發布新通知</a>
<%if PageNO-1>0 then %>
<A href=VoteList.asp?pageNO=1&ID=<%=Request.QueryString ("ID")%>>首頁</a> <A href=VoteList.asp?pageNO=<%=pageNO-1%>&ID=<%=Request.QueryString ("ID")%>>上一頁</a>
<%
else
%>首頁 上一頁<%
end if %>
<%
if PageNo+1<=MaxPage then
%>
<A href=VoteList.asp?pageNO=<%=pageNO+1%>&ID=<%=Request.QueryString ("ID")%>>下一頁</a> <A href=VoteList.asp?pageNO=<%=MaxPage%>&ID=<%=Request.QueryString ("ID")%>>末頁</a>
<%
else
%>
下一頁 末頁
<%
end if
objDB.Close
Set RS = Nothing
Set objDB = Nothing
%>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td background="images/hline.gif" height="1"></td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -