代码
<%@ 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>