gg.asp

自做的购物网站

<%
if session("admin_name")="" then response.end
%>
<!--#include file="conn.asp"--> 
<!--#include file="css.asp"-->
<%
dim sql, rs
Set rs= Server.CreateObject("ADODB.Recordset") 
sql="select title,id,msg from pub  order by id desc " 
rs.open sql,conn,1,1 
%>
<title>公告管理</title>
<center>
  <TABLE cellSpacing=1 cellPadding=0 width="540" align=center bgColor=#999999 
border=0>
    <TBODY> 
    <TR> 
        <TD width="735" background=images/pics/tile_back.gif id=maintitleback> 
          <TABLE cellSpacing=0 cellPadding=3 width="100%" border=0>
            <TBODY>
              <TR> 
                
            <TD width="10"><IMG height=8 src="images/pics/nav_m.gif" width=8 
            border=0></TD>
                
            <TD height="30" valign="bottom" id=maintitle>新闻管理 -&gt; <strong>公告管理</strong></TD>
              </TR>
            </TBODY>
          </TABLE></TD>
      </TR>
      <TR> 
        <TD id=mainbg> <TABLE cellSpacing=1 cellPadding=4 width="100%" border=0 height="125">
            <% do while not rs.eof %>
            <TBODY>
              <TR> 
                
            <TD width="100" height="30" noWrap 
          background=images/pics/tile_sub.gif id=titlemedium> 
              <div align="center"><font color="#FFFFFF">公告分类</font></div>
            </TD>
                
            <TD width="200" height="30" noWrap 
          background=images/pics/tile_sub.gif id=titlemedium> 
              <div align="center"><%=rs("title")%></div>
            </TD>
                
            <TD height="30" colspan="2" align=middle noWrap 
          background=images/pics/tile_sub.gif id=titlemedium> 
              <div align="center"><a href="ggdel.asp?id=<%=rs("id")%>"><img src="images/pics/delete.gif" width="45" height="20" border="0"></a></div>
            </TD>
              </TR>
              <TR> 
                <TD bgColor=#ffffff height="30"><div align="center">公告内容</div></TD>
                <TD height="30" colspan="3" align=middle bgColor=#ffffff><div align="left"><font color=#333333><%=rs("msg")%> 
                    </font></div></TD>
              </TR>
              <TR> 
                <TD height="30" colspan="4" bgColor=#ffffff><div align="center"><img src="../IMAGES/pics/seperator.gif" width="359" height="1"></div></TD>
              </TR>
              <TR> 
                <TD id=mainfoot 
colSpan=4 height="20"> 
              <div align="center"><font color="#FF0000">警告:必须保留最少一条公告信息,否则会出错!</font></div>
            </TD>
              </TR>
            </TBODY>
            <% rs.movenext
        loop
        %>
          </TABLE></TD>
      </TR>
    </TBODY>
  </TABLE>
  <br>
  <form method="post" action="gg2.asp">
    <TABLE cellSpacing=1 cellPadding=0 width="540" align=center bgColor=#999999 
border=0>
      <TBODY> 
      <TR> 
          <TD width="735" background=images/pics/tile_back.gif id=maintitleback> 
            <TABLE cellSpacing=0 cellPadding=3 width="100%" border=0>
              <TBODY>
                <TR> 
                  
              <TD width="10"><IMG height=8 src="images/pics/nav_m.gif" width=8 
            border=0></TD>
                  
              <TD height="30" valign="bottom" id=maintitle>新闻管理 -&gt; <strong>公告管理</strong></TD>
                </TR>
              </TBODY>
            </TABLE></TD>
        </TR>
        <TR> 
          <TD id=mainbg> <TABLE cellSpacing=1 cellPadding=4 width="100%" border=0 height="125">
              <TBODY>
                <TR> 
                  
              <TD width="100" height="30" noWrap 
          background=images/pics/tile_sub.gif id=titlemedium>
                <div align="center"><font color="#FFFFFF">主题</font></div>
              </TD>
                  
              <TD height="30" noWrap 
          background=images/pics/tile_sub.gif id=titlemedium> 
                <div align="left"> 
                      
                  <input name="title" type="text" id="title" size="35">
                </div>
              </TD>
                </TR>
                <TR> 
                  <TD bgColor=#ffffff height="30"><div align="center"><font color="#FF0000">内容</font></div></TD>
                  <TD height="30" align=middle bgColor=#ffffff><div align="left"><font color=#333333> 
                      
                  <textarea name="msg" cols="50" rows="6" wrap="VIRTUAL"></textarea>
                      </font></div></TD>
                </TR>
                <TR> 
                  <TD height="30" colspan="2" bgColor=#ffffff><div align="center"><img src="../IMAGES/pics/seperator.gif" width="359" height="1"></div></TD>
                </TR>
                <TR> 
                  <TD id=mainfoot 
colSpan=2 height="20"> <div align="center"> 
                      <table width="30%" border="0" align="center" cellpadding="0" cellspacing="0">
                        <tr> 
                          <td height="25"><div align="center"> 
                              <input name=submit2 type=image 
      src="../IMAGES/pics/ok.gif" alt=进入 
      align=absMiddle width="45" height="20" cache tppabs="">
                            </div></td>
                          <td><div align="center"> 
                              <input type="reset" value="全部重写" name="B22" class=input>
                            </div></td>
                        </tr>
                      </table>
                    </div></TD>
                </TR>
              </TBODY>
            </TABLE></TD>
        </TR>
      </TBODY>
    </TABLE>
  </form>
  </center>
</body>
</html>