listgonggao.asp

信息管理系统 管理页面:admin/index.asp 用户和密码都是admin

<!--#include file=conn.asp-->
<!--#include file=cookies.asp-->
<link rel="stylesheet" type="text/css" href="../1.CSS">
<%
	dim sql
	dim rs
	dim biaoti
	dim neirong,Allrecord
	set rs=server.createobject("adodb.recordset")
	sql="select * from [gonggao] order by id"
	rs.open sql,conn,1,1
	Allrecord=rs.Recordcount
%>

<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="97%" 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="#808000" width="86%" height="26">
      <tr>
        <td width="80%" height="26" bgcolor="#FFB546">
        <p align="center"><b><font size="3">网站公告管理</font></b></td>
      </tr>
      <tr>
        <td width="80%" valign="top" height="20">
        <b><font size="4">记录总数</font></b>:<font color="#FFFF00"><span style="background-color: #800000"><%=Allrecord%></span></font><font color="#FFFFFF"><b><font color="#384249" size="3">[</font></b><a href="addgonggao.asp"><u><font color="#FF0000" size="3">增加公告</font></u></a><b><font color="#384249" size="3">]</font></b></font><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="#FFF9EE">
            <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="#FFF9EE"><A href="javascript:win=open('../gonggao.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="6%" style="border-bottom-style: solid; border-bottom-width: 1" height="24" bgcolor="#FFF9EE">
            <a href="editgonggao.asp?id=<%=rs("id")%>"><font color="#FF0000">修改</font></a></td>
            <td width="22%" style="border-bottom-style: solid; border-bottom-width: 1" height="24" bgcolor="#FFF9EE">
            <a onclick='{if(confirm("您确定删除吗?此操作将不能恢复!")){return true;}return false;}' href="delgonggao.asp?id=<%=rs("id")%>">
            <font color="#FF0000">删除</font></a></td>
          </tr>
     <%
     rs.movenext
	 loop
	 %>
        </table>
        </td>
      </tr>
    </table>
      </center>
    </div>
    </td>
  </tr>
</table>
<p align="center">
    　</p>

<%
	rs.close
	conn.close
	set rs=nothing
	set conn=nothing
%>