?? middle_jsp.java
字號:
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\"> 用戶:</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\"> 密碼:</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\"> 您好，歡迎<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\"> ?<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\"> </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\"> </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\"> </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\"> </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");
out.write(" <td width=\"626\" valign=\"top\">");
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 width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" background=\"\"> \r\n");
out.write("\t\t<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/cplist_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<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" background=\"\"> \r\n");
out.write(" ");
//Condb con=new Condb();
String sql="";
ResultSet rs=null;
sql="select * from tb_Ware order by Dattime";
rs=con.executeQuery(sql);
int pagesize=8;
int rowcount=0;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -