📄 newsadmin.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<% option explicit%>
<%Response.Buffer=True%>
<!--#Include file="odbc_conn.asp"-->
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<table width="100%" border="1" cellspacing="0" cellpadding="0" align="left">
<tr>
<td colspan="6"><div align="center" class="style2">所有新闻显示</div></td>
</tr>
<tr>
<td width="5%"><div align="center">序号</div></td>
<td width="16%"><div align="center">所属类别</div></td>
<td width="43%"><div align="center">新闻标题</div></td>
<td width="20%"><div align="center">添加时间</div></td>
<td width="16%" colspan="2"><div align="center">操 作</div></td>
</tr>
<%
Dim sql
Dim rs
Dim t
t=1
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from News order by ID desc"
rs.Open Sql, conn, 1
If rs.Bof Or rs.Eof Then
Response.Write "<center>暂无数据!</center>"
else
Dim Page
Dim page_size ,EachPageSize
'EachPageSize=Clng(Request("EachPageSize"))
'page_size=Cint(EachPageSize)
page_size=10
rs.PageSize=page_size '设置每页多少条记录
'如果第一次打开，则page_no为1，否则由传回的参数决定
Page=Clng(Request("Page"))
if Request("Page")="" or Page <1 then
Page=1
elseif Page>rs.PageCount then
Page=rs.PageCount
end if
rs.AbsolutePage=Cint(Page) '设置当前显示第几页
do while not rs.Eof and page_size >0 '循环直到当前页结束或文件结尾
page_size =page_size-1
%>
<tr>
<td width="5%"><div align="center"><%=t%></div></td>
<%
Dim rss
Dim strsql
Dim strconn
Set strconn=Server.CreateObject("ADODB.Connection")
strconn.Open " Dbq=" & Server.Mappath("News.mdb") & "; Driver={Microsoft Access Driver (*.mdb)}"
strsql="select * from Category where CateID="&rs("CateID")
set rss=conn.execute(strsql)
if not rss.eof then
%>
<td width="15%"><div align="left"><%=rss("CateName") %></div></td>
<%
'else
end if
rss.close
set rss=nothing
set strconn=nothing%>
<td ><div align="left">
<% if trim(rs("AttPic"))="附图" then
%>
(附图)<%= rs("Title") %>
<% Else %>
<%= rs("Title") %>
<% End If %>
</div></td>
<td align="left"><%=rs("PostTime") %> </td>
<td ><a href="UpdateNewsForm.asp?ID=<%= rs("ID") %>" target="mainframe">修改</a></td>
<td ><a href="DeleteNews.asp?ID=<%= rs("ID") %>" target="mainframe">删除</a></td>
</tr>
<p>
<%
t=t+1
rs.movenext
loop
Response.Write "</table>"%>
</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<form name="form2" method="post" action="NewsAdmin.asp"> <center>
<%
if Page=1 then %><a href="NewsAdmin.asp?Page=1">第一页 </a>上一页
<a href="NewsAdmin.asp?Page=<%=(Page+1)%>">下一页</a>
<a href="NewsAdmin.asp?Page=<%=rs.PageCount%>">最后一页</a>
<% ElseIf Page=rs.PageCount then %>
<a href="NewsAdmin.asp?Page=1">第一页 </a>
<a href="NewsAdmin.asp?Page=<%=(Page-1)%>">上一页</a>
下一页
<a href="NewsAdmin.asp?Page=<%=rs.PageCount%>">最后一页</a>
<% Else %>
<a href="NewsAdmin.asp?Page=1">第一页 </a>
<a href="NewsAdmin.asp?Page=<%=(Page-1)%>">上一页</a>
<a href="NewsAdmin.asp?Page=<%=(Page+1)%>">下一页</a>
<a href="NewsAdmin.asp?Page=<%=rs.PageCount%>">最后一页</a>
<% end if
' end if%>
转到
<input type="text" name="Page" size="3">页
页次:<font color="Red"><%= Page %>/<%=rs.PageCount%>
<%
end if
%>
</font> <span class="style4">每页显示:</span>
<input name="EachPageSize" type="text" value="5" size="4"> 条
</center>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -