?? index_jsp.java
字號(hào):
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\"> </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\"> 用戶:</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=\"注冊(cè)\">\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");
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -