ps.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 ps  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="122" height="30" noWrap 
          background=images/pics/tile_sub.gif id=titlemedium><div align="center"><font color="#FFFFFF">配送分类</font></div></TD>
                <TD width="244" height="30" noWrap 
          background=images/pics/tile_sub.gif id=titlemedium><div align="center"><font color="#FFFFFF"><%=rs("title")%></font></div></TD>
                
            <TD height="30" colspan="2" align=middle noWrap 
          background=images/pics/tile_sub.gif id=titlemedium> 
              <div align="center"><a href="psdel.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"><font color="#000000">配送内容</font></div></TD>
                <TD height="30" colspan="3" align=middle bgColor=#ffffff><div align="center"><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="ps2.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="130" 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" 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>
  <p>&nbsp;</p></center>
</body>
</html>