uedit_jsp.java

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

      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("\t</td> \r\n");
      out.write("    <td width=\"626\" valign=\"top\">\r\n");
      out.write("\t");
      out.write("\r\n");
      out.write("<table width=\"100%\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#FFFFFF\" bordercolorlight=\"#FCBE3F\" bordercolordark=\"#FFFFFF\" background=\"\"> \r\n");
      out.write("\t\t<tr>  \t\r\n");
      out.write("\t\t<form name=\"form3\" method=\"post\" action=\"user/forward.jsp\">   \r\n");
      out.write("          <td width=\"65%\" height=\"28\" align=\"center\" valign=\"middle\">商品搜索:\r\n");
      out.write("            <select name=\"wtype\" class=\"wenbenkuang\">\r\n");
      out.write("              <option>上衣</option>\r\n");
      out.write("              <option>裤子</option>\r\n");
      out.write("              <option>女裙</option>\r\n");
      out.write("              <option>内衣</option>\r\n");
      out.write("              <option>其它</option>\r\n");
      out.write("            </select>\r\n");
      out.write("          <input name=\"shop\" type=\"text\" class=\"txt_grey\">\r\n");
      out.write("          <input name=\"Submit\" type=\"submit\" class=\"btn_grey\" value=\"搜索\" onClick=\"return check()\">\r\n");
      out.write("          <input name=\"Submit2\" type=\"reset\" class=\"btn_grey\" value=\"重置\"></td> \r\n");
      out.write("\t\t  </form>  \r\n");
      out.write("          <td width=\"35%\" align=\"center\" valign=\"middle\" class=\"bgcolor\" id=\"time\"><script>ShowTime(time);</script></td>\r\n");
      out.write("        </tr>\t\r\n");
      out.write("      </table>");
      out.write("\r\n");
      out.write("      <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"625\" height=\"\" align=\"center\"   >\r\n");
      out.write("      <tr>\r\n");
      out.write("        <td><img name=\"cplist_01_01\" src=\"image/usercenter_01.gif\" width=\"625\" height=\"69\" border=\"0\" alt=\"\" /></td>\r\n");
      out.write("      </tr>\r\n");
      out.write("      <tr>\r\n");
      out.write("        <td width=\"625\" background=\"image/usercenter_02.gif\">\r\n");
      out.write("\t\t");
      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n");

Condb con2=new Condb();
if(session.getAttribute("username")==null){

      out.write("\r\n");
      out.write("<script language=\"javascript\">\r\n");
      out.write("\talert(\"你必须先登录后才能修改个人资料\");\r\n");
      out.write("\thistory.back();\r\n");
      out.write("</script>\r\n");
	
}else{
	String sql2="select * from tb_User where Username='"+session.getAttribute("username")+"'";
	ResultSet rs2=con2.executeQuery(sql2);
	if(rs2.next()){
	String id=rs2.getString(1);

      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("<table width=\"562\"   border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
      out.write("   <form action=\"user/ucheck.jsp\" method=\"post\" name=\"form1\">\r\n");
      out.write("  <tr>\r\n");
      out.write("      <td height=\"46\" colspan=\"5\" align=\"center\" background=\"\" bgcolor=\"#EFE9BB\">修改用户信息</td>\r\n");
      out.write("    </tr>\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td width=\"144\" rowspan=\"8\" align=\"center\" background=\"images/images/usereg_2.gif\"  style=\"background-repeat:no-repeat\">&nbsp;</td>\r\n");
      out.write("    <td height=\"23\" align=\"right\" class=\"bgcolor\">用户名:</td>\r\n");
      out.write("    <td height=\"23\" align=\"left\"><input name=\"username\" type=\"text\" class=\"txt_grey\" value=\"");
      out.print(rs2.getString(2));
      out.write("\" size=\"32\"  readonly=\"yes\"></td>    \r\n");
      out.write("  </tr>\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td width=\"89\" height=\"23\" align=\"right\" class=\"bgcolor\">真实姓名:</td>\r\n");
      out.write("    <td width=\"329\" height=\"23\" align=\"left\"><input name=\"Rname\" type=\"text\" class=\"txt_grey\" value=\"");
      out.print(rs2.getString(3));
      out.write("\" size=\"32\" /></td>\r\n");
      out.write("  </tr>\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td height=\"23\" align=\"right\" class=\"bgcolor\">密码:</td>\r\n");
      out.write("    <td height=\"23\" align=\"left\"><input name=\"password\" type=\"password\" class=\"txt_grey\" value=\"");
      out.print(rs2.getString(4));
      out.write("\" size=\"32\"></td>\r\n");
      out.write("    </tr>  \r\n");
      out.write("  <tr>\r\n");
      out.write("    <td height=\"23\" align=\"right\" class=\"bgcolor\">Email:</td>\r\n");
      out.write("    <td height=\"23\" align=\"left\"><input name=\"email\" type=\"text\" class=\"txt_grey\" value=\"");
      out.print(rs2.getString(5));
      out.write("\" size=\"32\"></td>\r\n");
      out.write("    </tr>\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td height=\"21\" align=\"right\" class=\"bgcolor\">地址:</td>\r\n");
      out.write("    <td height=\"21\" align=\"left\"><textarea name=\"address\" cols=\"30\" rows=\"4\" class=\"txt_grey\">");
      out.print(rs2.getString(6));
      out.write("</textarea></td>\r\n");
      out.write("  </tr>\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td height=\"23\" align=\"right\" class=\"bgcolor\">联系电话:</td>\r\n");
      out.write("    <td height=\"23\" align=\"left\"><input name=\"photo\" type=\"text\" class=\"txt_grey\" value=\"");
      out.print(rs2.getString(7));
      out.write("\" size=\"32\"></td>\r\n");
      out.write("  </tr>\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td height=\"23\" align=\"right\" class=\"bgcolor\">找回密码问题:</td>\r\n");
      out.write("    <td height=\"23\" align=\"left\"><input name=\"pass\" type=\"text\" class=\"txt_grey\" value=\"");
      out.print(rs2.getString(8));
      out.write("\" size=\"32\"></td>\r\n");
      out.write("    </tr>\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td height=\"23\" align=\"right\" class=\"bgcolor\">问题答案:</td>\r\n");
      out.write("    <td height=\"23\" align=\"left\"><input name=\"question\" type=\"text\" class=\"txt_grey\" value=\"");
      out.print(rs2.getString(9));
      out.write("\" size=\"32\"></td>\r\n");
      out.write("    </tr>\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td height=\"40\" colspan=\"4\" align=\"center\"background=\"\"><input name=\"Submit\" type=\"submit\" class=\"btn_grey\"  value=\"修改\">\r\n");
      out.write("    <input name=\"Submit2\" type=\"reset\" class=\"btn_grey\" value=\"重置\">");
 session.setAttribute("userid",id); 
      out.write("\r\n");
      out.write("          <a href=\"index.jsp\">返回首页</a></td>\r\n");
      out.write("  </tr>\r\n");
      out.write("  ");

	}
	}con2.close();
	
      out.write("\r\n");
      out.write("  </form>\r\n");
      out.write("</table>\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("\t\t</td>\r\n");
      out.write("      </tr>\r\n");
      out.write("      <tr>\r\n");
      out.write("        <td><img name=\"usercenter_03\" src=\"image/usercenter_03.gif\" width=\"625\" height=\"4\" border=\"0\" alt=\"\"></td>\r\n");
      out.write("      </tr>\r\n");
      out.write("</table>\r\n");
      out.write("\t</td> \r\n");
      out.write("  </tr> \r\n");
      out.write("</table> \r\n");
      out.write("<br/>\r\n");
      out.write("\r\n");
      out.write("<style type=\"text/css\">\r\n");
      out.write("<!--\r\n");
      out.write(".tit {font-size: 14px;\r\n");
      out.write("}\r\n");
      out.write(".style1 {color: #000000}\r\n");
      out.write(".style3 {font-size: 14px; font-weight: bold; }\r\n");
      out.write("-->\r\n");
      out.write("</style>\r\n");
      out.write("<table width=\"800\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td height=\"30\"  align=\"center\" bgcolor=\"#f7f7f7\"><img src=\"image/pic3.gif\" align=\"absmiddle\" />  <a href=\"index.jsp\">站点首页</a> | <a href=\"about.jsp\">关于我们</a> | <a href=\"\">付款方式</a> | <a href=\"\">购物流程</a> | <a href=\"\">交易条款</a> | <a href=\"\">常见问题</a> | <a href=\"\">法律版权</a> | <a href=\"\">运输说明</a> |  <a href=\"\">售后服务</a> | <a href=\"\">送货方式</a> | <a href=\"\">新闻中心</a> | <a href=\"\">用户留言</a>\r\n");
      out.write("    </td>\r\n");
      out.write("  </tr>\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td align=\"right\">联系QQ：267027873  329876120<br/>\r\n");
      out.write("            客服信箱：&nbsp;&nbsp;热线：<br />\r\n");
      out.write("            公司地址：&nbsp;&nbsp;邮编：<br />\r\n");
      out.write("          Copyright&copy;&nbsp;&nbsp;&nbsp;<b></b><br/>         \r\n");
      out.write("    <span class=\"style3\"><a href=\"admin/login.htm\">后台管理登录入口</td>\r\n");
      out.write("  </tr>\r\n");
      out.write("</table>\r\n");
      out.write("\r\n");
      out.write(" \r\n");
      out.write("</body>\r\n");
      out.write("</html>");
    } catch (Throwable t) {
      if (!(t instanceof SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          out.clearBuffer();
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
      }
    } finally {
      if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }
}