index_jsp.java

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

      out.write("-->\r\n");
      out.write("</script>\r\n");
      out.write("\r\n");
      out.write("<table width=\"172\" height=\"187\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td width=\"172\" valign=\"top\">\r\n");
      out.write("\t\r\n");
      out.write("\t<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"171\">\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"55\" valign=\"bottom\"><img name=\"productleft_01\" src=\"image/left2_01.gif\" width=\"171\" height=\"45\" border=\"0\" alt=\"\"></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td><table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"171\">\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td width=\"14\" background=\"image/productleft_02.gif\">&nbsp;</td>\r\n");
      out.write("                <td width=\"152\">\r\n");
      out.write("\t\t\t\t");

		Condb con=new Condb();
		//String str=session.getAttribute(username);
		if(session.getAttribute("username")==null){
	
      out.write("\r\n");
      out.write("\t\t\t\t<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#FFCC00\" background=\"\">\r\n");
      out.write("    \r\n");
      out.write("      <form action=\"user/ucon.jsp\" name=\"form2\" method=\"post\">\r\n");
      out.write("        <tr>         \r\n");
      out.write("          <td width=\"46\" height=\"24\" align=\"left\" valign=\"middle\"> &nbsp;用户:</td>\r\n");
      out.write("          <td width=\"106\"><input name=\"username\" type=\"text\" class=\"wenbenkuang\" size=\"12\"></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>          \r\n");
      out.write("          <td height=\"24\" align=\"left\"> &nbsp;密码:</td>\r\n");
      out.write("          <td><input name=\"password\" type=\"password\" class=\"wenbenkuang\" size=\"12\"></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr align=\"center\">\r\n");
      out.write("          <td height=\"24\" colspan=\"2\">\r\n");
      out.write("\t\t  <input name=\"login\" type=\"submit\" class=\"btn_grey\" value=\"登录\" onClick=\"return checked1()\">\r\n");
      out.write("          <input name=\"login\" type=\"submit\" class=\"btn_grey\" value=\"注册\">\r\n");
      out.write("            </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("      </form>\r\n");
      out.write("      <tr align=\"center\">\r\n");
      out.write("        <td height=\"32\" colspan=\"2\"><a href=\"user/pass.jsp\" >从这里找回密码</a></td>\r\n");
      out.write("      </tr>\r\n");
      out.write("    </table>\r\n");
      out.write("\t\t\t\t\r\n");
      out.write("\t\t\t\t");

		}else{
		
      out.write("\r\n");
      out.write("      <table width=\"100%\" height=\"\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
      out.write("        <tr>\r\n");
      out.write("\t\t<td height=\"20\">&nbsp;您好，欢迎<a href=\"uedit.jsp\">");
      out.print( session.getAttribute("username") );
      out.write("</a>光临！</td>\r\n");
      out.write("\t\t</tr>\r\n");
      out.write("\t\t<tr>\r\n");
      out.write("\t\t<td height=\"20\">&nbsp;・<a href=\"user/logout.jsp\">安全退出！</a></td>\r\n");
      out.write("\t\t</tr>\r\n");
      out.write("\t\t<tr>\r\n");
      out.write("          <td align=\"left\" valign=\"top\" background=\"\"><marquee direction=\"up\" height=\"60\" scrollamount=\"1\"><center>\r\n");
      out.write("          ");

		  	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);
		
		  
      out.write("</center></marquee>\r\n");
      out.write("            </td>\r\n");
      out.write("\t\t</tr>\r\n");
      out.write("      </table>\r\n");
      out.write("\t  ");

		}
	
      out.write(" \r\n");
      out.write("\t\t\t\t</td>\r\n");
      out.write("                <td width=\"15\" background=\"image/productleft_04.gif\">&nbsp;</td>\r\n");
      out.write("              </tr>\r\n");
      out.write("          </table></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td><img name=\"productleft_05\" src=\"image/productleft_05.gif\" width=\"171\" height=\"19\" border=\"0\" alt=\"\"></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("      </table>\r\n");
      out.write("\t\r\n");
      out.write("\t  \r\n");
      out.write("\t</td>\r\n");
      out.write("\t</tr>\r\n");
      out.write("\t<tr><td>\r\n");
      out.write("      <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"171\">\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"55\" valign=\"bottom\"><img name=\"productleft_01\" src=\"image/clickleft_01.gif\" width=\"171\" height=\"45\" border=\"0\" alt=\"\"></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td><table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"171\">\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td width=\"14\" background=\"image/productleft_02.gif\">&nbsp;</td>\r\n");
      out.write("                <td width=\"149\">\r\n");
      out.write("\t\t\t\t<table width=\"100%\">\r\n");
      out.write("\t\t\t\t");

			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;
				}
		
      out.write("\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"21\" align=\"left\" background=\"\"><font color=\"#0000CC\"><a href=\"user/look.jsp?buy1=");
      out.print(wn);
      out.write('"');
      out.write('>');
      out.write('・');
      out.print(wn);
      out.write("</a></font></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        ");

		}
		
      out.write("\r\n");
      out.write("\t\t\t\t</table> </td>\r\n");
      out.write("                <td width=\"15\" background=\"image/productleft_04.gif\">&nbsp;</td>\r\n");
      out.write("              </tr>\r\n");
      out.write("          </table>\r\n");
      out.write("\t\t  </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td><img name=\"productleft_05\" src=\"image/productleft_05.gif\" width=\"171\" height=\"19\" border=\"0\" alt=\"\"></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("      </table>\r\n");
      out.write("    </td>\r\n");
      out.write("\t</tr>\r\n");
      out.write("\t<tr>\r\n");
      out.write("\t<td>\r\n");
      out.write("\t<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"171\">\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"55\" valign=\"bottom\"><img name=\"productleft_01\" src=\"image/left3_01.gif\" width=\"171\" height=\"45\" border=\"0\" alt=\"\"></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td><table align=\"left\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"171\">\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td width=\"14\" background=\"image/productleft_02.gif\"></td>\r\n");
      out.write("                <td width=\"149\">\r\n");
      out.write("\t\t\t\t <table width=\"100%\" >        \r\n");
      out.write("       \t\t\t\t ");

		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);
		
      out.write("\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"21\" align=\"left\" ><a href=\"");
      out.print(linkdress);
      out.write("\" target=\"_blank\">・");
      out.print(linkname);
      out.write("</a></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        ");

		}con.close();
		
      out.write("\r\n");
      out.write("    \t\t\t</table> \r\n");
      out.write("\t\t\t\t</td>\r\n");
      out.write("                <td width=\"15\" background=\"image/productleft_04.gif\">&nbsp;</td>\r\n");
      out.write("              </tr>\r\n");
      out.write("          </table></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td><img name=\"productleft_05\" src=\"image/productleft_05.gif\" width=\"171\" height=\"19\" border=\"0\" alt=\"\"></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("      </table>\r\n");
      out.write("\t</td>\r\n");
      out.write("\t</tr>\r\n");
      out.write("\r\n");
      out.write("</table>\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("    </td>\r\n");