智能手机销售网

xiaoxiao2022-07-07 199

代码

<%@ page contentType="text/html;charset=GB2312" %> <HTML> <BODY> <HEAD><%@ include file="head.txt" %></HEAD> <title>首页</title> <CENTER> <h1><font Size=4 color=blue> 欢迎光临“智多星”智能手机销售网 </font></h1> <img src="image/welcome.jpg" width=500 height=400 ></img> </CENTER> </BODY></HTML>

<%@ page contentType="text/html;charset=GB2312" %> <title>按id查找手机</title> <HTML> <BODY bgcolor=#66FFAA><center> <BR>请输入要查询的手机的版本 <FORM action="findmobileServlet" method="post"> <tr><td>*手机版本:</td><td><Input type=text name="mobile_version" ></td> <td><Input type="submit" name="g" value="提交"></td></tr> </Form> </BODY></HTML>

<%@ page contentType="text/html;charset=GB2312" %> <%@ page import="java.sql.*" %> <HTML><HEAD><%@ include file="head.txt" %></HEAD> <BODY bgcolor=cyan><font size=2> <div align="center"> <h2>选择某类手机<br>分页显示这类手机</h2> <% try { Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} String uri="jdbc:mysql://127.0.0.1/mobileshop?"+ "user=root&password=111111&characterEncoding=gb2312"; Connection con; Statement sql; ResultSet rs; try { con=DriverManager.getConnection(uri); sql=con.createStatement(); //读取mobileClassify表，获得分类： rs=sql.executeQuery("SELECT * FROM mobileClassify"); out.print("<form action='queryServlet' method ='post'>") ; out.print("<select name='fenleiNumber'>") ; while(rs.next()){ int id = rs.getInt(1); String mobileCategory = rs.getString(2); out.print("<option value ="+id+">"+mobileCategory+"</option>"); } out.print("</select>"); out.print("<input type ='submit' value ='提交'>"); out.print("</form>"); con.close(); } catch(SQLException e){ out.print(e); } %> </div></font> </BODY></HTML>

<%@ page contentType="text/html;charset=GB2312" %> <%@ page import="java.sql.*" %> <jsp:useBean id="userBean" class="mybean.data.Classify" scope="request"/> <title>添加手机类型</title> <HTML> <BODY bgcolor=#66FFAA><center> <br>手机类型表部分信息 <% try { Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} String uri="jdbc:mysql://127.0.0.1/mobileshop?"+ "user=root&password=111111&characterEncoding=gb2312"; Connection con; Statement sql; ResultSet rs; try { con=DriverManager.getConnection(uri); sql=con.createStatement(); rs=sql.executeQuery("SELECT * FROM mobileclassify"); out.print("<table border=2>"); out.print("<tr>"); out.print("<th width=100>"+"ID"); out.print("<th width=100>"+"手机类型"); out.print("</tr>"); while(rs.next()){ out.print("<tr>"); out.print("<td>"+rs.getString(1)+"</td>"); out.print("<td>"+rs.getString(2)+"</td>"); out.print("</tr>"); } out.print("</table>"); con.close(); } catch(SQLException e){ out.print(e); } %> </BODY></HTML>

<%@ page contentType="text/html;charset=GB2312" %> <%@ page import="java.sql.*" %> <jsp:useBean id="userBean" class="mybean.data.Mobile" scope="request"/> <title>添加手机</title> <HTML> <BODY bgcolor=#66FFAA><center> <br>手机表信息 <% try { Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} String uri="jdbc:mysql://127.0.0.1/mobileshop?"+ "user=root&password=111111&characterEncoding=gb2312"; Connection con; Statement sql; ResultSet rs; try { con=DriverManager.getConnection(uri); sql=con.createStatement(); rs=sql.executeQuery("SELECT * FROM mobileform"); out.print("<table border=2>"); out.print("<tr>"); out.print("<th width=100>"+"版本"); out.print("<th width=100>"+"手机名"); out.print("<th width=100>"+"公司"); out.print("<th width=100>"+"价格"); out.print("<th width=100>"+"信息"); out.print("<th width=100>"+"图片"); out.print("<th width=100>"+"ID"); out.print("</tr>"); while(rs.next()){ out.print("<tr>"); out.print("<td>"+rs.getString(1)+"</td>"); out.print("<td>"+rs.getString(2)+"</td>"); out.print("<td>"+rs.getString(3)+"</td>"); out.print("<td>"+rs.getString(4)+"</td>"); out.print("<td>"+rs.getString(5)+"</td>"); out.print("<td>"+rs.getString(6)+"</td>"); out.print("<td>"+rs.getString(7)+"</td>"); out.print("</tr>"); } out.print("</table>"); con.close(); } catch(SQLException e){ out.print(e); } %> </BODY></HTML>

<BODY bgcolor=#66FFAA><center> <BR>订单表的信息 <% try { Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} String uri="jdbc:mysql://127.0.0.1/mobileshop?"+ "user=root&password=111111&characterEncoding=gb2312"; Connection con; Statement sql; ResultSet rs; try { con=DriverManager.getConnection(uri); sql=con.createStatement(); rs=sql.executeQuery("SELECT * FROM orderform"); out.print("<table border=2>"); out.print("<tr>"); out.print("<th width=100>"+"ID"); out.print("<th width=100>"+"登录名"); out.print("<th width=100>"+"信息"); out.print("<th width=100>"+"总价钱"); out.print("</tr>"); while(rs.next()){ out.print("<tr>"); out.print("<td>"+rs.getString(1)+"</td>"); out.print("<td>"+rs.getString(2)+"</td>"); out.print("<td>"+rs.getString(3)+"</td>"); out.print("<td>"+rs.getString(4)+"</td>"); out.print("</tr>"); } out.print("</table>"); con.close(); } catch(SQLException e){ out.print(e); } %> </BODY></HTML>

<div align="center"> <% if(loginBean==null){ response.sendRedirect("login.jsp");//重定向到登录页面 } else { boolean b =loginBean.getLogname()==null|| loginBean.getLogname().length()==0; if(b) response.sendRedirect("login.jsp");//重定向到登录页面 } Connection con; Statement sql; ResultSet rs; try{ Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} try { String uri= "jdbc:mysql://127.0.0.1/mobileshop"; String user="root"; String password="111111"; con=DriverManager.getConnection(uri,user,password); sql=con.createStatement(); String cdn= "SELECT id,mess,sum FROM orderform where logname= '"+loginBean.getLogname()+"'"; rs=sql.executeQuery(cdn); out.print("<table border=2>"); out.print("<tr>"); out.print("<th width=100>"+"订单号"); out.print("<th width=100>"+"信息"); out.print("<th width=100>"+"价格"); out.print("</TR>"); while(rs.next()){ out.print("<tr>"); out.print("<td >"+rs.getString(1)+"</td>"); out.print("<td >"+rs.getString(2)+"</td>"); out.print("<td >"+rs.getString(3)+"</td>"); out.print("</tr>") ; } out.print("</table>"); con.close(); } catch(SQLException e){ out.print(e); } %> </div"> </BODY></HTML>

<%@ page contentType="text/html;charset=GB2312" %> <%@ page import="mybean.data.Login" %> <%@ page import="java.util.*;" %> <jsp:useBean id="loginBean" class="mybean.data.Login" scope="session"/> <HTML><HEAD><%@ include file="head.txt" %></HEAD> <BODY bgcolor=yellow><font size=2> <div align="center"> <% if(loginBean==null){ response.sendRedirect("login.jsp");//重定向到登录页面 } else { boolean b =loginBean.getLogname()==null|| loginBean.getLogname().length()==0; if(b) response.sendRedirect("login.jsp");//重定向到登录页面 } LinkedList car =loginBean.getCar(); if(car==null) out.print("<h2> 购物车没有物品.</h2>"); else { Iterator<String> iterator=car.iterator(); StringBuffer buyGoods = new StringBuffer(); int n=0; double priceSum =0; out.print("购物车中的物品：<table border=2>"); while(iterator.hasNext()) { String goods=iterator.next(); String showGoods=""; n++; //购车车物品的后缀是“#价格数字"，比如“iPhone手机价格3989 #3989” int index=goods.lastIndexOf("#"); if(index!=-1){ priceSum+=Double.parseDouble(goods.substring(index+1)); showGoods = goods.substring(0,index); } buyGoods.append(n+":"+showGoods); String del="<form action='deleteServlet' method = 'post'>"+ "<input type ='hidden' name='delete' value= "+goods+">"+ "<input type ='submit' value='删除' ></form>"; out.print("<tr><td>"+showGoods+"</td>"); out.print("<td>"+del+"</td></tr>"); } out.print("</table>"); String orderForm = "<form action='buyServlet' method='post'>"+ " <input type ='hidden' name='buy' value= "+buyGoods+" >"+ " <input type ='hidden' name='price' value= "+priceSum+" >"+ "<input type ='submit' value='生成订单'></form>"; out.print(orderForm); } %> </div></font> </BODY></HTML>

最新回复(0)