admin_notice.asp

这是一个非常好的留言版程序

<!--#include file="char.asp"--> 
<!--#include file="conn.asp"-->
<%
	dim sql
	dim rs
	dim biaoti
	dim neirong,Allrecord
	set rs=server.createobject("adodb.recordset")
	sql="select * from [notice] order by data"
	rs.open sql,conn,1,1
	Allrecord=rs.Recordcount
%>

<style type="text/css">
<!--
body {
	background-color: #dadae9;
}
.style1 {
	color: #FFFFFF;
	font-weight: bold;
	font-size: 12px;
}
.style2 {font-size: 12px}
-->
</style><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="71">
  <tr>
    <td width="100%" valign="top" height="71">
    <div align="center">
      <center>
    <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#ADAED6" width="100%" height="26">
      <tr>
        <td width="80%" height="28" bgcolor="#BDBEDE">
        <p class="style1">&nbsp;网站公告管理</td>
      </tr>
      <tr>
        <td width="80%" valign="top" height="20">
          <span class="style2"><span class="style1">&nbsp;</span>记录总数：<font color="#FFFF00"><span style="background-color: #800000"><%=Allrecord%></span></font><font color="#FFFFFF"><b><font color="#384249">[</font></b><a href="addnotice.ASP"><u><font color="#FF0000">增加公告</font></u></a><b><font color="#384249">]</font></b></font><font color="#FFFFFF"><b><font color="#384249"></font></b></font></span>
          <table border="0" cellspacing="1" width="100%" height="24">
     <%do while not rs.eof%>
          <tr>
            <td width="6%" height="24" style="border-bottom-style: solid; border-bottom-width: 1" bgcolor="#FFFFFF">
            <p align="center"><b><font color="#808080"><%=rs("id")%></font></b></td>
            <td width="62%" height="24" style="border-bottom-style: solid; border-bottom-width: 1" bgcolor="#FAFAFA"><A href="javascript:win=open('../notice.ASP?id=<%=rs("id")%>','offer','width=560,height=450,status=no,menubar=yes,scrollbars=yes,top=0,left=0'); win.focus()"><FONT color=#000000><%=rs("biaoti")%></FONT></A></td>
            <td width="10%" style="border-bottom-style: solid; border-bottom-width: 1" height="24" bgcolor="#FFFFFF">
              <div align="center"><a href="edit_notice.ASP?id=<%=rs("id")%>"><font color="#FF0000">修改</font></a></div></td>
            <td width="10%" style="border-bottom-style: solid; border-bottom-width: 1" height="24" bgcolor="#FAFAFA">
              <div align="center"><a onclick='{if(confirm("您确定删除吗?此操作将不能恢复!")){return true;}return false;}' href="delnotice.ASP?id=<%=rs("id")%>">
                <font color="#FF0000">删除</font></a></div></td>
          </tr>
     <%
     rs.movenext
	 loop
	 %>
        </table>
        </td>
      </tr>
    </table>
      </center>
    </div>
    </td>
  </tr>
</table>
<%
	rs.close
	conn.close
	set rs=nothing
	set conn=nothing
%>