📄 delreview1.asp
字号:
<!--#include file=conn.asp -->
<%
IF not(Session("KEY")="super" or Session("KEY")="input") THEN
response.redirect "login.asp"
response.end
END IF
PageShowSize = 10 '每页显示多少个页
MyPageSize = 16 '每页显示多少条新闻
If Not IsNumeric(Request("page")) Or IsEmpty(Request("page")) Or Request("page") <=0 Then
MyPage=1
Else
MyPage=Int(Abs(Request("page")))
End if
set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from ReView order by NewsID desc"
rs.Open rs.Source,conn,1,1
If Not rs.eof then
rs.PageSize = MyPageSize
MaxPages = rs.PageCount
rs.absolutepage = MyPage
total = rs.RecordCount
%>
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="copyright" content="惠州市信息产业局（bii.huizhou.gov.cn）">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href=style.css rel=stylesheet>
</head>
<body>
<br>
<table border="0" width="90%" align=center cellspacing="1" cellpadding="0" bgcolor="#000000">
<tr>
<td width="100%" bgcolor="#abb8d6" height="55" align="center"><b>删 除 评 论</b></td>
</tr>
<tr bgcolor="#FFFFFF">
<form method="POST" action="Delreview2_alert.asp" id=form1 name=form1>
<td colspan="2" bgcolor="#FFFFFF" align="center" valign="middle" height="60"><b>直接输入评论ID：</b>
<input type="text" name="ReviewID" size="20">
<input type="submit" value="下一步>>" id=submit1 name=submit1>
</td>
</form>
</tr>
<tr>
<td bgcolor=#abb8d6 align=center height=25>共 <%=total%> 条，当前第 <%=Mypage%>/<%=Maxpages%>
页，每页 <%=MyPageSize%> 条</td>
</tr>
<tr>
<td bgcolor=#abb8d6 align=center height=25>
<table width="100%" border="0" cellspacing="1" cellpadding="0" height="25">
<tr align="center" bgcolor="#FFFFFF">
<td width="6％">评论ID</td>
<td width="6％">新闻ID</td>
<td width="40％">内容提要</td>
<td width="12％">作 者</td>
<td width="22％">信 箱</td>
<td width="8％">日 期</td>
<td width="6%">执行</td>
</tr>
</table>
</td>
</tr>
<tr>
<td bgcolor=#ffffff>
<table border="0" cellspacing="1" width="100%" cellpadding="0" bgcolor="#abb8d6">
<%
for i=1 to rs.PageSize
if not rs.EOF then
content=trim(rs("content"))
DisplayContent=mid(Content,1,25)
%>
<form method="POST" action="DelReview2_alert.asp"><input type=hidden name="ReViewID" value="<%=rs("ReViewID")%>">
<tr bgcolor=ffffff align="center">
<td width="6%"><%=rs("ReViewID")%></td>
<td width="6%"><%=rs("NewsID")%></td>
<td width="40%" align="left"> <a href='../ReadView.asp?ReViewID=<%=rs("ReViewID")%>' target=_blank><%=DisplayContent%>...</a></td>
<td width="12%"><%=trim(rs("author"))%></td>
<td width="22%"><a href="mailto:<%=trim(rs("email"))%>"><%=trim(rs("email"))%></a></td>
<td width="8%"><%=Month(rs("UpdateTime")) %>-<%=Day(rs("UpdateTime")) %></td>
<td width="6%">
<input type=submit value="删除" style="border-style: double; border-color: #FF0000"></td>
</tr>
</form>
<%
rs.MoveNext
end if
next
%>
</table>
</td>
<tr>
<td colspan=2 bgcolor=#abb8d6 align=center height=25>共 <%=total%> 条，当前第 <%=Mypage%>/<%=Maxpages%>
页，每页 <%=MyPageSize%> 条
<%
if session("KEY")="super" then
url="DelReView1.asp?"
else
url="DelReView1.asp?BigClassName=" & Request("BigClassName") & "&"
end if
PageNextSize=int((MyPage-1)/PageShowSize)+1
Pagetpage=int((total-1)/rs.PageSize)+1
if PageNextSize >1 then
PagePrev=PageShowSize*(PageNextSize-1)
Response.write "<a class=black href='" & Url & "page=" & PagePrev & "' title='上" & PageShowSize & "页'>上一翻页</a> "
Response.write "<a class=black href='" & Url & "page=1' title='第1页'>页首</a> "
end if
if MyPage-1 > 0 then
Prev_Page = MyPage - 1
Response.write "<a class=black href='" & Url & "page=" & Prev_Page & "' title='第" & Prev_Page & "页'>上一页</a> "
end if
if Maxpages>=PageNextSize*PageShowSize then
PageSizeShow = PageShowSize
Else
PageSizeShow = Maxpages-PageShowSize*(PageNextSize-1)
End if
If PageSizeShow < 1 Then PageSizeShow = 1
for PageCounterSize=1 to PageSizeShow
PageLink = (PageCounterSize+PageNextSize*PageShowSize)-PageShowSize
if PageLink <> MyPage Then
Response.write "<a class=black href='" & Url & "page=" & PageLink & "'>[" & PageLink & "]</a> "
else
Response.Write "<B>["& PageLink &"]</B> "
end if
If PageLink = MaxPages Then Exit for
Next
if Mypage+1 <=Pagetpage then
Next_Page = MyPage + 1
Response.write "<a class=black href='" & Url & "page=" & Next_Page & "' title='第" & Next_Page & "页'>下一页</A>"
end if
if MaxPages > PageShowSize*PageNextSize then
PageNext = PageShowSize * PageNextSize + 1
Response.write " <A class=black href='" & Url & "page=" & Pagetpage & "' title='第"& Pagetpage &"页'>页尾</A>"
Response.write " <a class=black href='" & Url & "page=" & PageNext & "' title='下" & PageShowSize & "页'>下一翻页</a>"
End if
%>
</td>
</tr>
</table>
<br>
<%
else
%>
<p> </p>
<p> </p>
<p> </p>
<table border="0" width="450" align=center bgcolor="#000000" cellpadding="0" cellspacing="1">
<tr>
<td colspan=2 align="center" bgcolor="ffffff">
<p> </p>
<p>没有内容可选</p>
<p> </p>
</td>
</tr>
</table>
<%
End If
%>
</body>
</html>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -