ad.jsp

用JSP写的一个在线购物网站的代码

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<%
String admin=(String)session.getValue("admin");
if(admin=="" || admin==null)
{%>
<script language="javascript">
alert("请登陆后再执行管理操作");
self.location="index.jsp";
</script>
<%}else{
String sql="select * from admin where admin='"+admin+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="javascript">
alert("对不起，无此管理员帐号");
history.back();
</script>
<%}}%>
<style type="text/css">
<!-- @import url(../images/css.css); -->
</style>
<table width="502" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td height="25" bgcolor="3969A5"><div align="right"><font color="#FFFFFF">广告设置</font>　　　　　　　　　<a href="addad.jsp"><font color="#CCCCCC">添加新广告位</font></a></div></td>
    <td bgcolor="3969A5" width="30"></td>
  </tr>
</table>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#999999">
  <tr> 
    <td> <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr bgcolor="#FFFFFF"> 
          <td height="15"></td>
        </tr>
        <%
	    String sql="select * from adpic";
	    ResultSet rs=data.executeQuery(sql);
	    int id=0;
		String name="";
	    String pic="";
	    while(rs.next())
	    {
		id=rs.getInt("id");
		name=rs.getString("name");
    	pic=rs.getString("pic");	    
	    %>
		<tr>
		<td height="100" bgcolor="#FFFFFF"><div align="center"><a target="_blank" href="../ad/<%=pic%>"><img src="../ad/<%=pic%>" height="80" border="0"></a></div></td>
		</tr>
        <tr> 
          <td bgcolor="#FFFFFF"><div align="center"> 
              <form action="upad.jsp" method="post" enctype="multipart/form-data">
			  <input type="hidden" name="id" value="<%=id%>">
			  <input type="hidden" name="oldpic" value="<%=pic%>">
                <table width="96%" border="0" cellspacing="0" cellpadding="0">
                  <tr bgcolor="#FFFFFF"> 
                    <td width="230" height="20"><div align="center"><%=name%></div></td>
                    <td wdith="200"><div align="center"><input type="file" name="pic" size="20" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
                    <td width="50"><div align="center"><input name="submit" type="submit" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="修改"></div></td>
                  </tr>
                </table>
	  <tr bgcolor="#FFFFFF">
	  <td height="10"></td>
	  </tr>
	  <tr> 
       <td height="1" bgcolor="#E3E2E2" colspan="4"></td>
      </tr>
              </form>
              <%}%>
            </div></td>
        </tr>
      </table></td>
  </tr>
</table>
<table width="502" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td height="25" bgcolor="3969A5"></td>
  </tr>
</table>