📄 admin_news.asp

📁 发布整站源码可以再开发~ 本人实用中效果嗷嗷滴~
💻 ASP
字号:
<!--#include file="config.asp"-->
<!--#include file="conn.asp"-->
<!--#include file="code.asp"-->
<%'检查管理员是否登录AdminName = ReplaceBadChar(Trim(Request.Cookies(webkey)("AdminName")))AdminPassword = ReplaceBadChar(Trim(Request.Cookies(webkey)("AdminPassword")))RndPassword = ReplaceBadChar(Trim(Request.Cookies(webkey)("RndPassword")))If AdminName = "" Or AdminPassword = "" Or RndPassword = "" Then	Response.Redirect "Admin_login.asp"End If%>
<%
if not isempty(request("page")) then
		currentPage=cint(request("page"))
	else
		currentPage=1
	end if
set rs = server.createobject("adodb.recordset")
%>
<html>
<head>
<meta NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
<meta HTTP-EQUIV="Content-Type" content="text/html; charset=gb2312">
<LINK href="image/style.css" rel=stylesheet>
<title><%=webname%></title>
</head>
<script>
function chkid()
{
document.form3316.action="admin_del.asp";
document.form3316.submit()
}
function CheckAll(form)  {
  for (var i=0;i<form.elements.length;i++)    {
    var e = form.elements[i];
    if (e.name != 'chkall')       e.checked = form.chkall.checked; 
   }
  }
</script>
<script language=javascript>
function ConfirmDel()
{
   if(confirm("确定要删除此公告吗？\n删除后不可恢复哦！"))
     return true;
   else
     return false;
}
</script>
<body leftMargin=0 bgcolor="#EFEFEF" topMargin=15>
<table width="90%"  border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#666666">
  <tr>
    <td bgcolor="#FFFFFF">&nbsp;&nbsp;&nbsp;<a href="admin_News.asp">所有公告</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="admin_News_add.asp">发布公告</a></td>
  </tr>
</table>
<br>
  <table width="90%"  border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#666666">
    <tr align="center" bgcolor="#EFEFEF">
      <td width="4%"><b>ID</b></td>
      <td width="25%"><b>公告标题</b></td>
      <td width="45%"><b>公告内容</b></td>
      <td width="16%"><b>发布时间</b></td>
      <td><b>操作</b></td>
    </tr>
<% 
sql="select * from News order by addtime desc" 
rs.open sql,conn,1,1 
if rs.eof and rs.bof then 
	response.write "<p align='center'><font color=red>当前没有发布任何公告~！</font></p>" 
else 
	totalPut=rs.recordcount 
	if currentpage<1 then 
 		currentpage=1 
	end if 
	if (currentpage-1)*MaxPerPage>totalput then 
		if (totalPut mod MaxPerPage)=0 then 
  			currentpage= totalPut \ MaxPerPage 
		else 
			currentpage= totalPut \ MaxPerPage + 1 
		end if 
	end if 
	if currentPage=1 then 
		showContent 
		showpage totalput,MaxPerPage,"admin_News.asp" 
	else 
 		if (currentPage-1)*MaxPerPage<totalPut then 
			rs.move  (currentPage-1)*MaxPerPage 
			showContent 
 			showpage totalput,MaxPerPage,"admin_News.asp" 
  		else 
	  		currentPage=1 
  			showContent 
  			showpage totalput,MaxPerPage,"admin_News.asp" 
		end if 
	end if 
	rs.close 
end if 
	
sub showContent 
dim i 
i=0
do while not rs.eof
%>
      <tr bgcolor="#FFFFFF" onmouseover=javascript:this.bgColor='#EFEFEF' onmouseout=javascript:this.bgColor='#FFFFFF'>
        <td align="center"><%=rs("id")%></td>
        <td><a href="admin_News_edit.asp?id=<%=rs("id")%>" title="<%=rs("title")%>"><%=left(rs("title"),15)%></a></td>
        <td><%=left(rs("content"),28)%></td>
        <td><%=rs("addtime")%></td>
        <td align="center"><%if rs("top")=false then response.write "<a href=admin_News_top.asp?id="&rs("id")&"&act=top>固</a>" else response.write "<a href=admin_News_top.asp?id="&rs("id")&"&act=utop><font color=red>解</font></a>" end if%> <a href=admin_News_edit.asp?id=<%=rs("id")%>><font color="#008000">编</font></a> <a href="admin_News_save.asp?id=<%=rs("id")%>&options=del"  onClick="return ConfirmDel();">删</a></td>
      </tr>
      <% 
i=i+1
if i>=MaxPerPage then exit do
	rs.movenext 
loop
end sub
%>
</table>
<%
	function showpage(totalnumber,maxperpage,filename)
  	dim n
  	if totalnumber mod maxperpage=0 then
  		n= totalnumber \ maxperpage
  	else
  		n= totalnumber \ maxperpage+1
  	end if
  	response.write "<tr bgcolor=#FFFFFF><form method=Post action="&filename&"?menu="&menu&"><td colspan=8 align=right>"

  	if CurrentPage<2 then
 		response.write "共"&totalnumber&"条记录&nbsp;首页 上页&nbsp;"
  	else
 		response.write "共"&totalnumber&"条记录&nbsp;<a href="&filename&"?page=1&menu="&menu&">首页</a>&nbsp;"
 		response.write "<a href="&filename&"?page="&CurrentPage-1&"&menu="&menu&">上页</a>&nbsp;"
  	end if

  	if n-currentpage<1 then
 		response.write "下页 尾页"
  	else
 		response.write "<a href="&filename&"?page="&(CurrentPage+1)&"&menu="&menu&">"
 		response.write "下页</a> <a href="&filename&"?page="&n&"&menu="&menu&">尾页</a>"
  	end if
	response.write "&nbsp;页次：<strong><font color=red>"&CurrentPage&"</font>/"&n&"</strong>页 "
 	response.write "&nbsp;<b>"&maxperpage&"</b>条记录/页 "
	response.write "转：<select name='page' size=1 onchange=javascript:submit()>"
	for i = 1 to n
		response.write "<option value="&i&" "
			if cint(Page)=cint(i) then
				response.wirte "selected "
			end if
		response.write ">第"&i&"页</option>"
	next
	response.write "</select></td></form></tr>"
end function
set rs=nothing
conn.close
set conn=nothing
%>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -