📄 __index.java
字号:
try { // error page try block response.setContentType("text/html; charset=GBK"); out.print("\r\n"); out.print("\r\n"); out.print("\r\n"); //[ /index.jsp; Line: 4] try{ //[ /index.jsp; Line: 5] //数据库连接 //[ /index.jsp; Line: 6] Class.forName("oracle.jdbc.driver.OracleDriver"); //[ /index.jsp; Line: 7] String strUrl = "jdbc:oracle:thin:@slight:1521:LOCAL"; //[ /index.jsp; Line: 8] String strUser = "eshop"; //[ /index.jsp; Line: 9] String strPassword = "eshop"; //[ /index.jsp; Line: 10] Connection con = DriverManager.getConnection(strUrl, strUser, strPassword); //[ /index.jsp; Line: 11] Statement st = con.createStatement(); //[ /index.jsp; Line: 12] //[ /index.jsp; Line: 13] //最近注册商品 //[ /index.jsp; Line: 14] String sql = "select * from product order by regtime desc"; //[ /index.jsp; Line: 15] ResultSet rs = st.executeQuery(sql); //[ /index.jsp; Line: 16] //[ /index.jsp; Line: 17] //[ /index.jsp; Line: 18] out.print("\r\n<html>\r\n\r\n<head>\r\n<script>\r\n function openbag(id) { window.open(\"eshop.jsp?cpbm=\"+id,\"\",\"height=400,width=630,left=200,top=0,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no\");}\r\n</script>\r\n<script language=\"javascript\">\r\n<!--\r\nfunction winopen(url)\r\n {\r\n window.open(url,\"search\",\"toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=1,resizable=yes,width=640,height=450,top=200,left=100\");\r\n }\r\n\r\nfunction MM_openBrWindow(theURL,winName,features) { //v2.0\r\n window.open(theURL,winName,features);\r\n}\r\n//-->\r\n</script>\r\n<title>\r\n网上商城\r\n</title>\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"style.css\">\r\n</head>\r\n<body leftmargin=\"0\" topmargin=\"0\">\r\n<table cellSpacing=\"0\" cellPadding=\"0\" width=\"764\" align=\"center\" border=\"0\" height=\"90\" bgcolor=\"#336699\">\r\n <tbody>\r\n <tr>\r\n <td width=\"100%\" height=\"1\"> <img src=\"images/logo_old.gif\" width=\"760\" height=\"80\" border=\"0\" usemap=\"#Map\">\r\n <center>\r\n </center></td>\r\n </tr>\r\n </tbody>\r\n</table"); out.print(">\r\n<map name=\"Map\">\r\n <area shape=\"rect\" coords=\"280,14,736,72\" href=\"http://www.cefirst.com/version2.01/product/esystem/default.asp\" target=\"_blank\">\r\n</map>\r\n<div align=\"center\">\r\n <table border=\"0\" width=\"764\" cellspacing=\"0\" cellpadding=\"0\" height=\"60\">\r\n <center>\r\n <tr>\r\n <td width=\"153\" valign=\"top\" bgcolor=\"#336699\" height=\"60\" rowspan=\"4\">\r\n <div align=\"center\">\r\n <table>\r\n <tr>\r\n <td width=\"160\" height=\"20\"> </td>\r\n </tr>\r\n <tr>\r\n <td width=\"160\" bgcolor=\"#000033\" height=\"1\"><spacer type=\"block\" height=\"1\"> </td>\r\n </tr>\r\n <tr>\r\n <td width=\"160\" bgcolor=\"#a0a0a0\" height=\"1\"><spacer type=\"block\" height=\"1\"> </td>\r\n </tr>\r\n <tr>\r\n <td width=\"160\" bgcolor=\"#b0b0b0\" height=\"1\"><spacer type=\"block\" height=\"1\"> </td>\r\n </tr>\r\n <tr>\r\n <td width=\"160\" bgcolor=\"#c0c0c0\" height=\"1\"><sp"); out.print("acer type=\"block\" height=\"1\"> </td>\r\n </tr>\r\n <tr>\r\n <td width=\"160\" bgcolor=\"#d0d0d0\" height=\"1\"><spacer type=\"block\" height=\"1\"> </td>\r\n </tr>\r\n <tr>\r\n <td width=\"160\" bgcolor=\"#F0F1EF\" height=\"80\"> <div align=\"center\">\r\n <table cellspacing=\"0\" cellpadding=\"0\" width=\"86%\" align=\"center\" background border=\"0\">\r\n <tbody>\r\n <tr>\r\n <td>\r\n "); { /* include block for 'news/rollnews.jsp' */ //[ /index.jsp; Line: 87] String __thePage = //[ /index.jsp; Line: 87] //[ /index.jsp; Line: 87] "news/rollnews.jsp"; //[ /index.jsp; Line: 87] pageContext.include(__thePage); //[ /index.jsp; Line: 87] out.flush(); //[ /index.jsp; Line: 87] } /* end include block for 'news/rollnews.jsp' */ //[ /index.jsp; Line: 87] out.print("\r\n</td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </div></td>\r\n </tr>\r\n <tr>\r\n <td width=\"160\" bgcolor=\"#000000\" height=\"1\"><spacer type=\"block\" height=\"1\"> </td>\r\n </tr>\r\n <tr>\r\n <td width=\"160\" bgcolor=\"#c0c0c0\" height=\"1\"><spacer type=\"block\" height=\"1\"> </td>\r\n </tr>\r\n <tr>\r\n <td width=\"160\" bgcolor=\"#b0b0b0\" height=\"1\"><spacer type=\"block\" height=\"1\"> </td>\r\n </tr>\r\n <tr>\r\n <td width=\"160\" bgcolor=\"#a0a0a0\" height=\"1\"><spacer type=\"block\" height=\"1\"> </td>\r\n </tr>\r\n <tr>\r\n <td width=\"160\" bgcolor=\"#000000\" height=\"1\"><spacer type=\"block\" height=\"1\"> </td>\r\n </tr>\r\n <tr>\r\n <td align=\"middle\" width=\"160\"> <p> </p></td>\r\n </tr>\r\n </table>\r\n <table class=\"main\" ce"); out.print("llspacing=\"0\" cellpadding=\"2\" width=\"153\" border=\"0\" height=\"67\">\r\n <tbody>\r\n <tr>\r\n <td valign=\"top\" align=\"middle\" width=\"152\" height=\"63\">\r\n<form language=\"javascript\" name=\"FORM1\" onSubmit=\"return FORM1_onsubmit()\" action=\"orderloginsb.jsp\" method=\"post\">\r\n <p style=\"word-spacing: 0; margin-top: 0; margin-bottom: 0\"><font color=\"#B0E8F8\">\r\n<!--webbot bot=\"HTMLMarkup\" startspan -->\r\n <script language=javascript id=clientEventHandlersJS>\r\n//函数名：chksafe\r\n//功能介绍：检查是否含有\"\'\",\'\\\\\',\"/\"\r\n//参数说明：要检查的字符串\r\n//返回值：0：是 1：不是\r\nfunction chksafe(a)\r\n{\r\n\treturn 1;\r\n/*\tfibdn = new Array (\"\'\" ,\"\\\\\", \"、\", \",\", \";\", \"/\");\r\n\ti=fibdn.length;\r\n\tj=a.length;\r\n\tfor (ii=0;ii<i;ii++)\r\n\t{\tfor (jj=0;jj<j;jj++)\r\n\t\t{\ttemp1=a.charAt(jj);\r\n\t\t\ttemp2=fibdn[ii];\r\n\t\t\tif (tem\';p1==temp2)\r\n\t\t\t{\treturn 0; }\r\n\t\t}\r\n\t}\r\n\treturn 1;\r\n*/\r\n}\r\n\r\n//函数名：chkspc\r\n//功能介绍：检查是否含有空格\r\n//参数说明：要检查的字符串\r\n//返回值：0：是 1：不是\r\nfunction chkspc(a)\r\n{\r\n\tvar i=a.length;\r\n\tvar j = 0;\r\n\tvar k ="); out.print(" 0;\r\n\twhile (k<i)\r\n\t{\r\n\t\tif (a.charAt(k) != \" \")\r\n\t\t\tj = j+1;\r\n\t\tk = k+1;\r\n\t}\r\n\tif (j==0)\r\n\t{\r\n\t\treturn 0;\r\n\t}\r\n\r\n\tif (i!=j)\r\n\t{ return 2; }\r\n\telse\r\n\t{\r\n\t\treturn 1;\r\n\t}\r\n}\r\n//函数名：fucCheckLength\r\n//功能介绍：检查字符串的长度\r\n//参数说明：要检查的字符串\r\n//返回值：长度值\r\nfunction fucCheckLength(strTemp)\r\n{\r\n\tvar i,sum;\r\n\tsum=0;\r\n\tfor(i=0;i<strTemp.length;i++)\r\n\t{\r\n\t\tif ((strTemp.charCodeAt(i)>=0) && (strTemp.charCodeAt(i)<=255))\r\n\t\t\tsum=sum+1;\r\n\t\telse\r\n\t\t\tsum=sum+2;\r\n\t}\r\n\treturn sum;\r\n}\r\n\r\n\r\n</script>\r\n <script language=javascript>\r\n\r\nfunction chkitem(str)\r\n{\r\n\tvar strSource =\"0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_\";\r\n var ch;\r\n var i;\r\n var temp;\r\n\r\n for (i=0;i<=(str.length-1);i++)\r\n {\r\n\r\n ch = str.charAt(i);\r\n temp = strSource.indexOf(ch);\r\n if (temp==-1)\r\n {\r\n return 0;\r\n }\r\n }\r\n if (strSource.indexOf(ch)==-1)\r\n {\r\n return 0;\r\n }\r\n else\r\n {\r\n return 1;\r\n }\r\n\r\n\r\n}\r\n\r\nfunction FORM1_onsubmit()\r\n{\r\n\tif (chkitem(document.FORM1.uid.value)==0)\r\n\t{\r\n\t\talert(\"请输入"); out.print("正确的会员帐号。\");\r\n\t\tdocument.FORM1.uid.focus();\r\n\t\treturn false;\r\n\t}\r\n\tif ((document.FORM1.uid.vlaue==\'\') || (chkspc(document.FORM1.uid.value)==0)|| (chkspc(document.FORM1.uid.value)==2))\r\n\t{\r\n\t\talert(\"请将会员帐号填写完整,且不能使用空格！\");\r\n\t\tdocument.FORM1.uid.focus();\r\n\t\treturn false;\r\n\t}\r\n\tif (chkitem(document.FORM1.pwd.value)==0)\r\n\t{\r\n\t\talert(\"请将填写密码！\");\r\n\t\tdocument.FORM1.pwd.focus();\r\n\t\treturn false;\r\n\t}\r\n\r\n\tif ( fucCheckLength(document.FORM1.uid.value) != document.FORM1.uid.value.length )\r\n\t{\r\n\t\talert(\"会员帐号请不要使用中文！\");\r\n\t\tdocument.FORM1.uid.focus();\r\n\t\treturn false;\r\n\t}\r\n\tif (fucCheckLength(document.FORM1.uid.value) <4 )\r\n\t{\r\n\t\talert(\"会员帐号必须至少4位\");\r\n\t\tdocument.FORM1.uid.focus();\r\n\t\treturn false;\r\n\t}\r\n\r\n}\r\n</script>\r\n <!--webbot bot=\"HTMLMarkup\" endspan -->\r\n 帐号\r\n <input maxlength=\"16\" size=\"14\" name=\"uid\">\r\n </font> </p>\r\n <p style=\"word-spacing: 0; margin-top: 0; margin-bottom: 0\"><font color=\"#B0E8F8\">密码\r\n "); out.print(" <input maxlength=\"16\" size=\"14\" name=\"pwd\" type=\"password\">\r\n </font> </p>\r\n <p style=\"word-spacing: 0; margin-top: 0; margin-bottom: 0\">\r\n <font color=\"#B0E8F8\"> <br>\r\n <input type=\"submit\" size=\"3\" value=\"登录\" name=\"Submit2\">\r\n <input type=\"button\" value=\"注册会员\" name=\"B1\" onClick=\"window.location.href=\'reguser.htm\';\">\r\n </font> </p>\r\n </form></td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n <table border=\"0\" width=\"90%\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr>\r\n <td width=\"100%\"> <div align=\"center\">\r\n <table height=\"10\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" border=\"0\">\r\n <tbody>\r\n <tr>\r\n <td width=\"100%\"> <font color=\"#B0E8F8\">\r\n"); //[ /index.jsp; Line: 280] //一级分类 //[ /index.jsp; Line: 281] sql = "select * from class_1"; //[ /index.jsp; Line: 282] ResultSet rs1 = st.executeQuery(sql); //[ /index.jsp; Line: 283] String strClass1Name = ""; //[ /index.jsp; Line: 284] while (rs1.next()){ //[ /index.jsp; Line: 285] sql = "select * from class_2 where class_1_name = '" + rs1.getString("class_1_name") + "'"; //[ /index.jsp; Line: 286] strClass1Name = rs1.getString("Class_1_Name"); //[ /index.jsp; Line: 287] //[ /index.jsp; Line: 288] ResultSet rs2 = st.executeQuery(sql); //[ /index.jsp; Line: 289] out.print("\r\n</font> <div align=\"center\">\r\n<table border=\"0\" cellspacing=\"0\" width=\"100%\" height=\"1\" bordercolorlight=\"#C0C0C0\" cellpadding=\"0\" bordercolordark=\"#336699\">\r\n <tr>\r\n <td height=\"1\" width=\"100%\"> <table border=\"0\" width=\"100%\" bgcolor=\"#0099CC\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr>\r\n <td height=\"22\" bgcolor=\"#6094C8\"> <p align=\"center\"><font color=\"#F7F7E7\"><b>\r\n "); out.print(String.valueOf(strClass1Name)); //[ /index.jsp; Line: 297] out.print("</b>\r\n</font></td>\r\n </tr>\r\n </table></td>\r\n</tr>\r\n"); //[ /index.jsp; Line: 302] int j = 1; //[ /index.jsp; Line: 303] while(rs2.next()){ //[ /index.jsp; Line: 304] out.print("\r\n <td width=\"139\" height=\"22\" bgcolor=\"#B1CBE4\">\r\n<p align=\"center\"><a href=\"splb.jsp?spdl="); out.print(String.valueOf(rs2.getString("Class_1_Name"))); //[ /index.jsp; Line: 307] out.print("&spxl="); out.print(String.valueOf(rs2.getString("Class_2_Name"))); //[ /index.jsp; Line: 307] out.print("\"><font color=\"#000000\">"); out.print(String.valueOf(rs2.getString("Class_2_Name"))); //[ /index.jsp; Line: 307] out.print("</font></a>\r\n </td>\r\n </tr>\r\n <tr>\r\n "); //[ /index.jsp; Line: 311] j=j+1; //[ /index.jsp; Line: 312] } //[ /index.jsp; Line: 313] rs2.close(); //[ /index.jsp; Line: 314] //[ /index.jsp; Line: 315] //[ /index.jsp; Line: 315] out.print("\r\n </tr>\r\n </table>\r\n </div>\r\n <font color=\"#B0E8F8\">\r\n"); //[ /index.jsp; Line: 320] } //[ /index.jsp; Line: 321] rs1.close(); //[ /index.jsp; Line: 322] out.print("\r\n </font> </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </div></td>\r\n </tr>\r\n </table>\r\n <br>\r\n </div></td>\r\n <td width=\"610\" valign=\"top\" colspan=\"2\" height=\"16\" bgcolor=\"#336699\" align=\"center\">\r\n <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">\r\n <tr align=\"center\">\r\n <td width=\"25\"><img src=\"images/left.gif\"></td>\r\n <td width=\"86\" background=\"images/bgguide.gif\"><a href=\"index.asp\" class=\"guide\">首 页</a></td>\r\n <td background=\"images/bgguide.gif\"><img src=\"images/guide.gif\"></td>\r\n <td width=\"86\" background=\"images/bgguide.gif\"><a href=\"zxsp.asp\" class=\"guide\">最新商品</a></td>\r\n <td background=\"images/bgguide.gif\"><img src=\"images/guide.gif\"></td>\r\n <td width=\"86\" background=\"images/bgguide.gif\"><a href=\"reguser.htm\" class=\"guide\">会员注册</a></td>\r\n "); out.print(" <td background=\"images/bgguide.gif\"><img src=\"images/guide.gif\"></td>\r\n <td width=\"86\" background=\"images/bgguide.gif\"><a href=\"javascript:openbag()\">察看购物车</a></td>\r\n <td background=\"images/bgguide.gif\"><img src=\"images/guide.gif\"></td>\r\n <td width=\"86\" background=\"images/bgguide.gif\">购物帮助</td>\r\n <td width=\"25\"><img src=\"images/right.gif\"></td>\r\n </tr>\r\n </table></td>\r\n </tr>\r\n </center>\r\n <tr>\r\n <td width=\"610\" valign=\"top\" colspan=\"2\" height=\"25\"> <table border=\"0\" width=\"100%\" height=\"1\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr>\r\n <center>\r\n <td width=\"50%\" height=\"1\"> <form method=\"POST\" action=\"orderofind.asp\" target=\"_blank\">\r\n <p style=\"word-spacing: 0; margin-top: 0; margin-bottom: 0\" align=\"center\">订单查询\r\n <input name=\"Form_Id\" type=\"text\" value=\"订单号\" size=\"8\">\r\n <input type=\"submit\" value=\"查询\" name=\"djB1\" class=\"a\">\r\n "); out.print(" </form></td>\r\n </center>\r\n <td width=\"50%\" height=\"1\"> <form method=\"POST\" action=\"spss.asp\" target=\"_blank\">\r\n <p style=\"word-spacing: 0; margin-top: 0; margin-bottom: 0\"> 商品查询\r\n <input type=\"text\" name=\"Product_Name\" size=\"10\" class=\"a\" style=\"font-size: 14px\">\r\n <select name=\"Product_Class\" size=\"1\" tabindex=\"0\" class=\"a\" style=\"font-size: 14px\">\r\n <option value=\"礼品\">礼品</option>\r\n <option value=\"影视\">影视</option>\r\n <option value=\"化妆\">化妆</option>\r\n <option value=\"互联网\">互联网</option>\r\n </select>\r\n <input type=\"image\" height=\"20\" cache width=\"52\" src=\"images/go.gif\" align=\"absMiddle\" value=\"GO\" border=\"0\" name=\"I55\">\r\n </p>\r\n </form></td>\r\n </tr>\r\n </table></td>\r\n </tr>\r\n <center>\r\n <tr>\r\n <td width=\"100%\" valign=\"top\" height=\"10\"> <div align=\"center\">\r\n"); out.print(" <center>\r\n <table cellspacing=\"0\" cellpadding=\"0\" width=\"417\" bgcolor=\"#f0f1ef\" border=\"0\">\r\n <tbody>\r\n <tr>\r\n <td valign=\"top\" width=\"10\" rowspan=\"2\"><img height=\"26\" src=\"images/enet_lt.gif\" width=\"10\"></td>\r\n <td width=\"505\" bgcolor=\"#10a6be\" height=\"1\"><spacer width=\"1\" type=\"block\"></td>\r\n <td valign=\"top\" width=\"10\" rowspan=\"2\"><img src=\"images/enet_rt.gif\"></td>\r\n </tr>\r\n <tr height=\"25\">\r\n <td> <table cellspacing=\"3\" cellpadding=\"0\" width=\"100%\" border=\"0\">\r\n <tbody>\r\n <tr>\r\n <td align=\"middle\" width=\"10\"></td>\r\n <td width=\"475\"><img height=\"10\" src=\"images/arrow_1.gif\" width=\"13\"> 商城动态</td>\r\n </tr>\r\n </tbody>\r\n </table></td>\r\n </tr>\r\n </"); out.print("tbody>\r\n </table>\r\n </center>\r\n </div>\r\n <div align=\"center\">\r\n <center>\r\n <table border=\"0\" width=\"417\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr>\r\n <td width=\"1\" bgcolor=\"#10A6BE\"> </td>\r\n <td width=\"415\" bgcolor=\"#F0F1EF\"><script src=\"news/news.asp\"></script>\r\n </td>\r\n <td width=\"1\" bgcolor=\"#10A6BE\"> </td>\r\n </tr>\r\n </table>\r\n </center>\r\n </div>\r\n <div align=\"center\">\r\n <center>\r\n <table cellspacing=\"0\" cellpadding=\"0\" width=\"417\" bgcolor=\"#f0f1ef\" border=\"0\">\r\n <tbody>\r\n <tr>\r\n <td valign=\"top\" width=\"10\" rowspan=\"2\"><img height=\"26\" src=\"images/enet_bl.gif\" width=\"10\"></td>\r\n <td width=\"505\" height=\"19\"> <table cellspacing=\"3\" cellpadding=\"0\" width=\"100%\" border=\"0\">\r\n <tbody>\r\n "); out.print(" <tr>\r\n <td align=\"right\"> <p style=\"word-spacing: 0; margin-top: 0; margin-bottom: 0\" align=\"right\">以往新闻>>>></p></td>\r\n </tr>\r\n </tbody>\r\n </table></td>\r\n <td valign=\"top\" width=\"10\" rowspan=\"2\"><img height=\"26\" src=\"images/enet_br.gif\" width=\"10\"></td>\r\n </tr>\r\n <tr height=\"1\">\r\n <td width=\"505\" bgcolor=\"#10a6be\" height=\"1\"><spacer width=\"1\" type=\"block\"></td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n <br>\r\n </center>\r\n </div></td>\r\n <td width=\"161\" valign=\"top\" height=\"10\" align=\"right\"> <table cellspacing=\"0\" cellpadding=\"0\" width=\"150\" border=\"0\">\r\n <tbody>\r\n <tr>\r\n <td valign=\"top\" width=\"4\" bgcolor=\"#336699\" rowspan=\"2\"><img height=\"18\" src=\"images/tl_img.gif\" width=\"4\" border=\"0\"></td>\r\n "); out.print(" <td bgcolor=\"#000000\" height=\"1\"><img height=\"1\" src=\"images/stretch.gif\" width=\"142\" border=\"0\"></td>\r\n <td valign=\"top\" width=\"4\" bgcolor=\"#336699\" rowspan=\"2\"><img height=\"18\" src=\"images/tr_img.gif\" width=\"4\" border=\"0\"></td>\r\n </tr>\r\n <tr>\r\n <td height=\"16\" valign=\"bottom\" bgcolor=\"#336699\"> <div align=\"left\"><font class=\"portletTitle\" color=\"#ffffff\"> 新品速递</font><font class=\"portletTitle\" color=\"#ffffff\" size=\"1\"><br>\r\n </font> </div></td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n <table cellspacing=\"0\" cellpadding=\"0\" width=\"150\" border=\"0\">\r\n <tbody>\r\n <tr>\r\n <td width=\"1\" bgcolor=\"#000000\"><img src=\"images/stretch.gif\" width=\"1\" border=\"0\"></td>\r\n <td valign=\"top\" bgcolor=\"#f7f7e7\"><img height=\"1\" src=\"images/stretch.gif\" width=\"146\" border=\"0\"><br>\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" hei"); out.print("ght=\"1\">\r\n"); //[ /index.jsp; Line: 455] while (rs.next()){ //[ /index.jsp; Line: 456]⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -