__index.java

网上购物系统 使用structs access 实现

                    out.print("\r\n<tr>\r\n  <td width=\"100%\" align=\"center\" height=\"11\">\r\n <p style=\"word-spacing: 0; margin-top: 0; margin-bottom: 0\" align=\"left\">\r\n<img height=\"14\" src=\"images/point002.GIF\" width=\"14\">\r\n<a href=\"javascript:winopen(\'spjj.jsp?ProductNO=");
                    out.print(String.valueOf(rs.getLong("Product_No")));  //[ /index.jsp; Line: 462]
                    out.print("\')\">");
                    out.print(String.valueOf(rs.getString("Product_name")));  //[ /index.jsp; Line: 462]
                    out.print("</a></p></td>\r\n</tr>\r\n");
                    //[ /index.jsp; Line: 464]
                } //[ /index.jsp; Line: 465]
                rs.close(); //[ /index.jsp; Line: 466]
                out.print("\r\n                  </table></td>\r\n                <!-- this is the shade  the right of the Portlet -->\r\n                <td width=\"1\" bgcolor=\"#000000\"><img src=\"images/stretch.gif\" width=\"1\" border=\"0\"></td>\r\n                <td width=\"1\" bgcolor=\"#9a9c9a\"><img src=\"images/stretch.gif\" width=\"1\" border=\"0\"></td>\r\n                <td width=\"1\" bgcolor=\"#b3b4b3\"><img src=\"images/stretch.gif\" width=\"1\" border=\"0\"></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 valign=\"top\" width=\"4\" rowspan=\"4\"><img height=\"6\" src=\"images/bl_img.gif\" width=\"4\" border=\"0\"></td>\r\n                <td bgcolor=\"#f7f7e7\" height=\"3\"><img height=\"1\" src=\"images/stretch.gif\" width=\"142\" border=\"0\"></td>\r\n                <td valign=\"top\" width=\"4\" rowspan=\"4\"><img height=\"6\" src=\"images/br_img.gif\" width=\"4\" border=\"0\"></td>\r\n              </tr>\r\n              <tr>\r\n                ");
                out.print("<td width=\"1\" bgcolor=\"#000000\"><img height=\"1\" src=\"images/stretch.gif\" width=\"1\" border=\"0\"></td>\r\n              </tr>\r\n              <tr>\r\n                <td width=\"1\" bgcolor=\"#9a9c9a\"><img height=\"1\" src=\"images/stretch.gif\" width=\"1\" border=\"0\"></td>\r\n              </tr>\r\n              <tr>\r\n                <td width=\"1\" bgcolor=\"#b3b4b3\"><img height=\"1\" src=\"images/stretch.gif\" width=\"1\" border=\"0\"></td>\r\n              </tr>\r\n            </tbody>\r\n          </table></td>\r\n      </tr>\r\n      <tr>\r\n        <td width=\"100%\" valign=\"top\" height=\"95\"> <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_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\" row");
                out.print("span=\"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\">　<font class=\"105v\">热卖商品</font>\r\n");
                //[ /index.jsp; Line: 511]
                sql = "select * from product where rownum<7 order by look_count desc "; //[ /index.jsp; Line: 512]
                ResultSet rshot = st.executeQuery(sql); //[ /index.jsp; Line: 513]
                out.print("\r\n                            </td>\r\n                          </tr>\r\n                        </tbody>\r\n                      </table></td>\r\n                  </tr>\r\n                </tbody>\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\" border=\"0\">\r\n                <tbody>\r\n                  <tr>\r\n                    <td width=\"100%\"> <table cellspacing=\"1\" width=\"100%\" border=\"0\" height=\"51\" bgcolor=\"#10A6BE\">\r\n                        <tbody>\r\n                          <tr valign=\"top\">\r\n                            <td class=\"default\" height=\"41\" width=\"100%\" bgcolor=\"#FFFFFF\">\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" height=\"98\">\r\n");
                //[ /index.jsp; Line: 534]
                int k = 1; //[ /index.jsp; Line: 535]
                out.print("\r\n<tr>\r\n");
                //[ /index.jsp; Line: 538]
                while (rshot.next()){ //[ /index.jsp; Line: 539]
                    out.print("\r\n<td>\r\n<p style=\"word-spacing: 0; margin-top: 0; margin-bottom: 0\">\r\n<img border=\"0\" src=\"");
                    out.print(String.valueOf(rshot.getString("p_pic")));  //[ /index.jsp; Line: 543]
                    out.print("\">\r\n<p style=\"word-spacing: 0; margin-top: 0; margin-bottom: 0\"><a href=\"javascript:winopen(\'spjj.jsp?ProductNO=");
                    out.print(String.valueOf(rshot.getLong("Product_No")));  //[ /index.jsp; Line: 544]
                    out.print("\')\"><b>");
                    out.print(String.valueOf(rshot.getString("Product_Name")));  //[ /index.jsp; Line: 544]
                    out.print("</b></a></p>\r\n            <p style=\"word-spacing: 0; margin-top: 0; margin-bottom: 0\">市场价：&yen;\r\n              <strike>");
                    out.print(String.valueOf(rshot.getDouble("P_OldPrice")));  //[ /index.jsp; Line: 546]
                    out.print("</strike><br>\r\n              会员价：&yen; <font color=\"#FF0000\">");
                    out.print(String.valueOf(rshot.getDouble("P_NewPrice")));  //[ /index.jsp; Line: 547]
                    out.print("</font><br>\r\n              <a href=\"javascript:winopen(\'spjj.jsp?ProductNO=");
                    out.print(String.valueOf(rshot.getLong("Product_No")));  //[ /index.jsp; Line: 548]
                    out.print("\')\">[详细介绍]</a></p>\r\n <p style=\"word-spacing: 0; margin-top: 0; margin-bottom: 0\"><a href=\"javascript:openbag(");
                    out.print(String.valueOf(rshot.getString("Product_Id")));  //[ /index.jsp; Line: 549]
                    out.print(")\"><img border=\"0\" src=\"images/mybuy.gif\"></a></p>\r\n            <hr size=\"1\" color=\"#808000\" width=\"80%\">\r\n          </td>\r\n          ");
                    //[ /index.jsp; Line: 552]
                    if ((double)k/3 == k/3){ //[ /index.jsp; Line: 553]
                        //[ /index.jsp; Line: 554]
                        //[ /index.jsp; Line: 554]
                        out.print("\r\n        </tr>\r\n        <tr>\r\n\r\n          ");
                        //[ /index.jsp; Line: 558]
                    } //[ /index.jsp; Line: 559]
                    k=k+1; //[ /index.jsp; Line: 560]
                } //[ /index.jsp; Line: 561]
                rshot.close(); //[ /index.jsp; Line: 562]
                con.close(); //[ /index.jsp; Line: 563]
                //[ /index.jsp; Line: 564]
                //[ /index.jsp; Line: 564]
                out.print("\r\n                                </tr>\r\n                              </table></td>\r\n                          </tr>\r\n                        </tbody>\r\n                      </table></td>\r\n                  </tr>\r\n                </tbody>\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                          <tr>\r\n                            <td align=\"right\"> 谢谢你光临我们的商店 </td>\r\n                          </tr>\r\n                        </tbody>\r\n                      </table></td>\r\n                    <td valign=\"top\" width=\"10\" row");
                out.print("span=\"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=\"95\" align=\"right\"> <table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\r\n            <tr>\r\n              <td width=\"100%\">&nbsp;</td>\r\n            </tr>\r\n          </table>\r\n          <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                <td bgcolor=\"#000000\" height=\"1\"><img height=\"1\" src=\"images/stretch.gif\" width=\"142\" border=\"0\"></td>\r\n                <td valign=\"top\" width=\"4\" b");
                out.print("gcolor=\"#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\">&nbsp;在线调查</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\">\r\n                  <table class=\"main\" cellspacing=\"0\" cellpadding=\"2\" width=\"100%\" border=\"0\">\r\n                    <tbody>\r\n                      <tr>\r\n                        <td valign=\"top\" align=\"middle\" width=\"152\" height=\"6\">\r\n      ");
                out.print("              ");
                { /* include block for 'showvote.jsp' */ //[ /index.jsp; Line: 625]
                    String __thePage =  //[ /index.jsp; Line: 625]
                    //[ /index.jsp; Line: 625]
                    "showvote.jsp"; //[ /index.jsp; Line: 625]
                    pageContext.include(__thePage); //[ /index.jsp; Line: 625]
                    out.flush(); //[ /index.jsp; Line: 625]
                } /* end include block for 'showvote.jsp' */ //[ /index.jsp; Line: 625]
                out.print("\r\n                        </td>\r\n                      </tr>\r\n                    </tbody>\r\n                  </table></td>\r\n                <!-- this is the shade  the right of the Portlet -->\r\n                <td width=\"1\" bgcolor=\"#000000\"><img src=\"images/stretch.gif\" width=\"1\" border=\"0\"></td>\r\n                <td width=\"1\" bgcolor=\"#9a9c9a\"><img src=\"images/stretch.gif\" width=\"1\" border=\"0\"></td>\r\n                <td width=\"1\" bgcolor=\"#b3b4b3\"><img src=\"images/stretch.gif\" width=\"1\" border=\"0\"></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 valign=\"top\" width=\"4\" rowspan=\"4\"><img src=\"images/bl_img.gif\" border=\"0\"></td>\r\n                <td bgcolor=\"#f7f7e7\" height=\"3\"><img height=\"1\" src=\"images/stretch.gif\" width=\"142\" border=\"0\"></td>\r\n                <td valign=\"top\" width=\"4\" rowspan=\"4\"><img height=\"6\" src=\"images/br_img.gif\" width=\"4\" border");
                out.print("=\"0\"></td>\r\n              </tr>\r\n              <tr>\r\n                <td width=\"1\" bgcolor=\"#000000\"><img height=\"1\" src=\"images/stretch.gif\" width=\"1\" border=\"0\"></td>\r\n              </tr>\r\n              <tr>\r\n                <td width=\"1\" bgcolor=\"#9a9c9a\"><img height=\"1\" src=\"images/stretch.gif\" width=\"1\" border=\"0\"></td>\r\n              </tr>\r\n            </tbody>\r\n          </table>\r\n          <br>\r\n\r\n          <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                <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");
                out.print("=\"#336699\"> <div align=\"left\"><font class=\"portletTitle\" color=\"#ffffff\">&nbsp;邮件订阅</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\">\r\n                  <table class=\"main\" cellspacing=\"0\" cellpadding=\"2\" width=\"100%\" border=\"0\">\r\n                    <tbody>\r\n                      <tr>\r\n\t\t\t\t\t   <form method=\"POST\" action=\"\" target=\"_blank\">\r\n                        <td valign=\"top\" align=\"middle\" width=\"152\" height=\"6\">\r\n\r\n  <p align=\"center\"><input type=\"text\" name=\"fsemail\" size=\"16\"></p>\r\n  <p align=\"center\"><input type=\"submit\" value=\"订阅\" name=\"B1\" disabled>\r");
                out.print("\n  <input type=\"submit\" value=\"退订\" name=\"td\" disabled></p>\r\n\r\n\r\n                        </td>\r\n\t\t\t\t\t\t</form>\r\n                      </tr>\r\n                    </tbody>\r\n                  </table></td>\r\n                <!-- this is the shade  the right of the Portlet -->\r\n                <td width=\"1\" bgcolor=\"#000000\"><img src=\"images/stretch.gif\" width=\"1\" border=\"0\"></td>\r\n                <td width=\"1\" bgcolor=\"#9a9c9a\"><img src=\"images/stretch.gif\" width=\"1\" border=\"0\"></td>\r\n                <td width=\"1\" bgcolor=\"#b3b4b3\"><img src=\"images/stretch.gif\" width=\"1\" border=\"0\"></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 valign=\"top\" width=\"4\" rowspan=\"4\"><img src=\"images/bl_img.gif\" border=\"0\"></td>\r\n                <td bgcolor=\"#f7f7e7\" height=\"3\"><img height=\"1\" src=\"images/stretch.gif\" width=\"142\" border=\"0\"></td>\r\n                <td valign=\"top\" w");
                out.print("idth=\"4\" rowspan=\"4\"><img height=\"6\" src=\"images/br_img.gif\" width=\"4\" border=\"0\"></td>\r\n              </tr>\r\n              <tr>\r\n                <td width=\"1\" bgcolor=\"#000000\"><img height=\"1\" src=\"images/stretch.gif\" width=\"1\" border=\"0\"></td>\r\n              </tr>\r\n              <tr>\r\n                <td width=\"1\" bgcolor=\"#9a9c9a\"><img height=\"1\" src=\"images/stretch.gif\" width=\"1\" border=\"0\"></td>\r\n              </tr>\r\n            </tbody>\r\n          </table>\r\n          <br> <br> </td>\r\n      </tr>\r\n    </center>\r\n  </table>\r\n  </center>\r\n  </div>\r\n\r\n<table align=\"center\" border=\"0\" cellPadding=\"4\" cellSpacing=\"0\" width=\"764\" bgcolor=\"#FFFFFF\">\r\n  <tbody>\r\n    <tr>\r\n      <td align=\"right\" class=\"unnamed1\"><hr size=\"1\" color=\"#000000\"></td>\r\n    </tr>\r\n    <tr>\r\n      <td align=\"right\" class=\"unnamed1\"> <p align=\"center\" style=\"word-spacing: 0; margin-top: 0; margin-bottom: 0\">Copyright\r\n          &copy;亮中计算机技术服务有限公司 2004 </p>\r\n        </td>\r\n    </tr>\r\n  </tbody>\r\n</table>\r\n</body>\r\n\r\n</html>\r\n");
                //[ /index.jsp; Line: 732]
            }catch(Exception e){ //[ /index.jsp; Line: 733]
                e.printStackTrace(); //[ /index.jsp; Line: 734]
            } //[ /index.jsp; Line: 735]
            out.print("\r\n");
        } catch (Throwable __ee) {
            while (out != null && out != _originalOut) out = pageContext.popBody();
            ((weblogic.servlet.jsp.PageContextImpl)pageContext).handlePageException((Throwable)__ee);
        }
        
        
        //before final close brace...
    }
    
    
}