left.jsp

网上服装店 能让用户在该网站上对物品进行上传购买等操作。该设计为原版

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%@ page import="com.bwm.db.Condb"%>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body {
	margin-right: 0px;
	margin-bottom: 0px;
}
-->
</style></head>
</script>
<link href="css/style.css" rel="stylesheet">
<script language="javascript">
<!--
	function check1(){
		if(form1.ware.value==""){
			alert("请输入搜索的商品名称");
			form1.ware.focus();
			return false;
			history.back();
		}
	}
-->
</script>
<script language="javascript">
<!--
	function checked1(){
		if(form2.username.value==""){
			alert("请输入你的的用户名");
			form2.username.focus();
			return false;
			history.back();
		}
		if(form2.password.value==""){
			alert("请输入你的密码");
			form2.password.focus();
			return false;
			history.back();
		}
	}
-->
</script>

<table width="172" height="187" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="172" valign="top">
	
	<table border="0" cellpadding="0" cellspacing="0" width="171">
        <tr>
          <td height="55" valign="bottom"><img name="productleft_01" src="image/left2_01.gif" width="171" height="45" border="0" alt=""></td>
        </tr>
        <tr>
          <td><table align="left" border="0" cellpadding="0" cellspacing="0" width="171">
              <tr>
                <td width="14" background="image/productleft_02.gif">&nbsp;</td>
                <td width="152">
				<%
		Condb con=new Condb();
		//String str=session.getAttribute(username);
		if(session.getAttribute("username")==null){
	%>
				<table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFCC00" background="">
    
      <form action="user/ucon.jsp" name="form2" method="post">
        <tr>         
          <td width="46" height="24" align="left" valign="middle"> &nbsp;用户:</td>
          <td width="106"><input name="username" type="text" class="wenbenkuang" size="12"></td>
        </tr>
        <tr>          
          <td height="24" align="left"> &nbsp;密码:</td>
          <td><input name="password" type="password" class="wenbenkuang" size="12"></td>
        </tr>
        <tr align="center">
          <td height="24" colspan="2">
		  <input name="login" type="submit" class="btn_grey" value="登录" onClick="return checked1()">
          <input name="login" type="submit" class="btn_grey" value="注册">
            </td>
        </tr>
      </form>
      <tr align="center">
        <td height="32" colspan="2"><a href="user/pass.jsp" >从这里找回密码</a></td>
      </tr>
    </table>
				
				<%
		}else{
		%>
      <table width="100%" height="" border="0" cellpadding="0" cellspacing="0">
        <tr>
		<td height="20">&nbsp;您好，欢迎<a href="uedit.jsp"><%= session.getAttribute("username") %></a>光临！</td>
		</tr>
		<tr>
		<td height="20">&nbsp;·<a href="user/logout.jsp">安全退出！</a></td>
		</tr>
		<tr>
          <td align="left" valign="top" background=""><marquee direction="up" height="60" scrollamount="1"><center>
          <%
		  	String temm="select * from tb_Affiche order by Dattime Desc";
			ResultSet rrs=con.executeQuery(temm);
			int nums=0;
			String affiche="";
			while(rrs.next()){
				nums++;
				if(nums==2){
					break;
				}
				affiche=rrs.getString(1);
			}
			out.println(affiche);
		
		  %></center></marquee>
            </td>
		</tr>
      </table>
	  <%
		}
	%> 
				</td>
                <td width="15" background="image/productleft_04.gif">&nbsp;</td>
              </tr>
          </table></td>
        </tr>
        <tr>
          <td><img name="productleft_05" src="image/productleft_05.gif" width="171" height="19" border="0" alt=""></td>
        </tr>
      </table>
	
	  
	</td>
	</tr>
	<tr><td>
      <table border="0" cellpadding="0" cellspacing="0" width="171">
        <tr>
          <td height="55" valign="bottom"><img name="productleft_01" src="image/clickleft_01.gif" width="171" height="45" border="0" alt=""></td>
        </tr>
        <tr>
          <td><table align="left" border="0" cellpadding="0" cellspacing="0" width="171">
              <tr>
                <td width="14" background="image/productleft_02.gif">&nbsp;</td>
                <td width="149">
				<table width="100%">
				<%
			String sq="select Warename,sum(Wsum)as num from tb_Shop group by all Warename order by num desc";
			ResultSet rst=con.executeQuery(sq);
			int sum=0;
			while(rst!=null && rst.next()){
				String wn=rst.getString(1);
				sum++;
				if(sum==11){
					break;
				}
		%>
        <tr>
          <td height="21" align="left" background=""><font color="#0000CC"><a href="user/look.jsp?buy1=<%=wn%>">·<%=wn%></a></font></td>
        </tr>
        <%
		}
		%>
				</table> </td>
                <td width="15" background="image/productleft_04.gif">&nbsp;</td>
              </tr>
          </table>
		  </td>
        </tr>
        <tr>
          <td><img name="productleft_05" src="image/productleft_05.gif" width="171" height="19" border="0" alt=""></td>
        </tr>
      </table>
    </td>
	</tr>
	<tr>
	<td>
	<table border="0" cellpadding="0" cellspacing="0" width="171">
        <tr>
          <td height="55" valign="bottom"><img name="productleft_01" src="image/left3_01.gif" width="171" height="45" border="0" alt=""></td>
        </tr>
        <tr>
          <td><table align="left" border="0" cellpadding="0" cellspacing="0" width="171">
              <tr>
                <td width="14" background="image/productleft_02.gif"></td>
                <td width="149">
				 <table width="100%" >        
       				 <%
		String str="select * from tb_link";
		int coun=0;
		ResultSet rss=con.executeQuery(str);
		while(rss!=null && rss.next()){
			coun++;
			if(coun==8){
				break;
			}
			String linkname=rss.getString(1);
			String linkdress=rss.getString(2);
		%>
        <tr>
          <td height="21" align="left" ><a href="<%=linkdress%>" target="_blank">·<%=linkname%></a></td>
        </tr>
        <%
		}con.close();
		%>
    			</table> 
				</td>
                <td width="15" background="image/productleft_04.gif">&nbsp;</td>
              </tr>
          </table></td>
        </tr>
        <tr>
          <td><img name="productleft_05" src="image/productleft_05.gif" width="171" height="19" border="0" alt=""></td>
        </tr>
      </table>
	</td>
	</tr>

</table>