JSP网上超市系统_JSP动态网页_JavaScript/JQuery

<%@page import="java.sql.*"%> <%@page import="java.io.*"%> <%@ page contentType="text/html;charset=gb2312" %> <jsp:useBean id="DBlink" class="connBean.DBCon"/> <%! String sqlstr; ResultSet rs; String id; String type; %> <% if (request.getParameter("id")!=null){ if (request.getParameter("id").equals("")){ id="0"; }else{ id=request.getParameter("id");} } if (request.getParameter("id").equals("1")){type="大众美食";} if (request.getParameter("id").equals("2")){type="体育用品";} if (request.getParameter("id").equals("3")){type="生活用品";} if (request.getParameter("id").equals("4")){type="文化用品";} if (request.getParameter("id").equals("5")){type="医疗用品";} if (request.getParameter("id").equals("6")){type="精美礼品";} if (request.getParameter("id").equals("7")){type="电子产品";} if (request.getParameter("id").equals("8")){type="办公用品";} %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>无标题文档</title> <style type="text/css">  </style></head> <body> <table width="992" height="958" border="3" cellpadding="0" cellspacing="0"> <tr> <th width="984" height="958" align="center" valign="top" bgcolor="#F5EFE7" scope="col"><table width="777" height="894" border="0" cellpadding="0" cellspacing="0"> <tr> <th height="894" align="left" valign="top" scope="col"><table width="986" height="109" border="3" cellpadding="0" cellspacing="0"> <tr> <th width="978" height="103" align="center" valign="middle" scope="col"> </th> </tr> </table> <table width="985" height="29" border="3" align="center" cellpadding="0" cellspacing="0"> <tr> <th width="979" height="23" align="center" valign="middle" scope="col"><form name="form1" method="post" action="select.jsp"> <p>商品查询 <input style="FONT-SIZE: 14px; WIDTH: 100px" type="text" name="user_name" size="2" class=input> <select name="select"> <option value="1">大众美食</option> <option value="2">体育用品</option> <option value="3">生活用品</option> <option value="4">文化用品</option> <option value="5">医疗用品</option> <option value="6">精美礼品</option> <option value="7">电子产品</option> <option value="8">办公用品</option> </select> <input type="submit" name="Submit" value="提交"> </p> </form></th> </tr> </table> <table width="987" height="32" border="3" cellpadding="0" cellspacing="0"> <tr> <th width="141" align="center" valign="middle" scope="row"><a href="index.jsp" rel='nofollow' onclick='return false;'>首页</a></th> <td width="141" align="center" valign="middle"><a href="newgoods.jsp" rel='nofollow' onclick='return false;'>最新商品</a></td> <td width="141" align="center" valign="middle"><a href="HotGoods.jsp" rel='nofollow' onclick='return false;'>热卖商品</a></td> <td width="141" align="center" valign="middle"><a href="购物帮助.htm" rel='nofollow' onclick='return false;'>购物帮助</a></td> <td width="141" align="center" valign="middle"><a href="ly.jsp" rel='nofollow' onclick='return false;'>会员留言</a></td> <td width="141" align="center" valign="middle"><a href="WantGoods.jsp" rel='nofollow' onclick='return false;'>预定缺货</a></td> <td width="141" align="center" valign="middle"><a href="MyGoods.jsp" rel='nofollow' onclick='return false;'>我的订单</a></td> </tr> </table> <table width="189" height="399" border="3" align="right" cellpadding="0" cellspacing="0"> <tr> <th height="393" align="left" valign="middle" scope="row"><table width="190" height="359" border="3" align="right" cellpadding="0" cellspacing="0"> <tr> <th width="182" height="15" align="center" valign="middle" scope="row">焦点新闻</th> </tr> <tr> <th height="338" align="left" valign="top" scope="row"><table width="182" height="335" border="2" cellpadding="0" cellspacing="0"> <tr> <th width="176" height="191" align="center" valign="top" scope="row"><p><a href="newsone.jsp" rel='nofollow' onclick='return false;'>1.网上购物方便又时尚消费者需注意的四件事</a></p> <p> <a href="newstwo.jsp" rel='nofollow' onclick='return false;'>2.十大中华经济英才评选揭晓 </a> </p> <p> <a href="newsthree.jsp" rel='nofollow' onclick='return false;'>3. 生意场九大经典骗术 </a></p> <p><a href="newsfour.htm" rel='nofollow' onclick='return false;'>4.<strong>家电IT巨头争锋消费电子 </strong></a> </p> </th> </tr> <tr> <th height="140" bgcolor="#F5EFE7" scope="row"> <MARQUEE scrollDelay=400 direction=up height=200 align="bottom"> <font size="-1"> </font> <font size="-1"><SPAN class=unnamed1>　　</SPAN><span class="style1">本站商品近期狂甩,顾客在这次活动中可以见到上古珍品瓷器和古代真品"清明上河图"以及在满汉全席中出现的美味佳肴,山珍海味应有尽有.这次活动的主要的目标是想要缩短广大人民群众和古玩珍品,山珍海味的距离.为这次活动本站经营者可以说是吐血大甩卖,广大群众一定要把握这次机会</span></font> </MARQUEE></th> </tr> </table></th> </tr> </table></th> </tr> </table> <table width="601" height="439" border="3" align="right" cellpadding="0" cellspacing="0"> <tr> <th width="593" height="56" scope="row"><applet code="ticker.class" width=400 height=28 rel='nofollow' onclick='return false;'> <param name=bgco value="0,20,0"> <param name=speed value="4"> <param name=msg value="欢迎光临本网站，这个跑马灯是一个很棒的JAVA Applets ！很棒吧！ "> <param name=txtco value="255,255,255"> </applet></th> </tr> <tr> <th height="377" align="left" valign="top" scope="row"><table width="598" height="376" border="0" cellpadding="0" cellspacing="0"> <tr> <th height="35" align="center" valign="middle" scope="row"><%=type%></th> </tr> <tr> <th height="341" align="center" valign="top" scope="row"><table width="98%" border="0"> <tr> <td width="20%"><div align="center">名称</div></td> <td width="20%"><div align="center">类别</div></td> <td width="20%"><div align="center">库存</div></td> <td width="20%"><div align="center">单价</div></td> <td width="20%"><div align="center">选择购买</div></td> </tr> </table> <% sqlstr="select * from tblgoods where typeid="+id; //out.print(sqlstr); //out.close(); DBlink.LinkDB(); rs=DBlink.select(sqlstr); while (rs.next()){ %> <table width="586" border="0"> <tr> <td width="20%"><div align="center"><%=rs.getString("name")%></div></td> <td width="20%"><div align="center"><%=type%></div></td> <td width="20%"><div align="center"><%=rs.getString("number")%></div></td> <td width="20%"><div align="center"><%=rs.getString("dj")%>/<%=rs.getString("dw")%></div></td> <