Web实验报告
班级：信管1172 学号：11671231 姓名：姚思敏
功能说明
（一）用户端
一、主页
二、注册
三、登录
四、浏览手机
五、查询手机查看购物车
<%@ page contentType="text/html;charset=GB2312" %><%@ page import="mybean.data.DataByPage" %><%@ page import="com.sun.rowset.*" %><jsp:useBean id="dataBean" class="mybean.data.DataByPage" scope="session"/><head><%@ include file="head.txt" %></head><html><body bgcolor=#B15BFF><center><br/>当前显示的内容是：<table border=2><tr><th>手机标识号</th><th>手机名称</th><th>手机制造商</th><th>手机价格</th><th>查看详情</th><td><font color=blue>添加到购物车</font></td></tr><jsp:setProperty name="dataBean" property="pageSize" param="pageSize"/><jsp:setProperty name="dataBean" property="currentPage" param="currentPage"/><% CachedRowSetImpl rowSet=dataBean.getRowSet();if(rowSet==null) {out.print("没有查询到结果，无法浏览");return; }rowSet.last(); int totalRecord=rowSet.getRow();out.println("全部记录数"+totalRecord); //全部记录数int pageSize=dataBean.getPageSize(); //每页显示的记录数int totalPages = dataBean.getTotalPages();if(totalRecord%pageSize==0)totalPages = totalRecord/pageSize;//总页数elsetotalPages = totalRecord/pageSize+1;dataBean.setPageSize(pageSize);dataBean.setTotalPages(totalPages);if(totalPages>=1) {if(dataBean.getCurrentPage()<1)dataBean.setCurrentPage(dataBean.getTotalPages());if(dataBean.getCurrentPage()>dataBean.getTotalPages())dataBean.setCurrentPage(1);int index=(dataBean.getCurrentPage()-1)*pageSize+1;rowSet.absolute(index); //查询位置移动到currentPage页起始位置boolean boo=true;for(int i=1;i<=pageSize&&boo;i++) { String number=rowSet.getString(1);String name=rowSet.getString(2);String maker=rowSet.getString(3);String price=rowSet.getString(4);String goods ="("+number+","+name+","+maker+","+price+")#"+price;//便于购物车计算价格,尾缀上"#价格值"goods = goods.replaceAll("\\p{Blank}","");String button="<form action='putGoodsServlet' method = 'post'>"+"<input type ='hidden' name='java' value= "+goods+">"+"<input type ='submit' value='放入购物车' ></form>";String detail="<form action='showDetail.jsp' method = 'post'>"+"<input type ='hidden' name='xijie' value= "+number+">"+"<input type ='submit' value='查看细节' ></form>";out.print("<tr>");out.print("<td>"+number+"</td>");out.print("<td>"+name+"</td>");out.print("<td>"+maker+"</td>");out.print("<td>"+price+"</td>");out.print("<td>"+detail+"</td>");out.print("<td>"+button+"</td>");out.print("</tr>");boo=rowSet.next();}}%></table><br/>每页最多显示<jsp:getProperty name="dataBean" property="pageSize"/>条信息<br/>当前显示第<font color=blue><jsp:getProperty name="dataBean" property="currentPage"/></font>页,共有<font color=blue><jsp:getProperty name="dataBean" property="totalPages"/></font>页。<table><tr><td><form action="" method=post><input type=hidden name="currentPage" value="<%=dataBean.getCurrentPage()-1 %>"><input type=submit name="g" value="上一页"></form></td><td><form action="" method=post><input type=hidden name="currentPage" value="<%=dataBean.getCurrentPage()+1 %>"><input type=submit name="g" value="下一页"></form></td></tr><tr><td> <form action="" method=post>每页显示<input type=text name="pageSize" value =2 size=3>条记录<input type=submit name="g" value="确定"></form></td><td> <form action="" method=post>输入页码：<input type=text name="currentPage" size=2 ><input type=submit name="g" value="提交"></form></td></tr></table></center></body></html><%@ page contentType="text/html;charset=GB2312" %><div align="center"><h2>“智多星”智能手机销售网</h2><table cellSpacing="1" cellPadding="1" width="660" align="center" border="0" ><tr valign="bottom"><td><a href="inputRegisterMess.jsp"><font size=2>注册</font></a></td><td><a href="login.jsp"><font size=2>登录</font></a></td><td><a href="lookMobile.jsp"><font size=2>浏览手机</font></a></td><td><a href="searchMobile.jsp"><font size=2>查询手机</font></a></td><td><a href="lookShoppingCar.jsp"><font size=2>查看购物车</font></a></td><td><a href="lookOrderForm.jsp"><font size=2>查看订单</font></a></td><td><a href="exitServlet"><font size=2>退出</font></a></td><td><a href="index.jsp"><font size=2>主页</font></a></td></tr></table></div><%@ page language="java" import="java.util.*" pageEncoding="GB2312"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><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" %><jsp:useBean id="userBean" class="mybean.data.Register" scope="request"/><head><%@ include file="head.txt" %></head><title>注册页面</title><html><body bgcolor=pink><font size=2><div align="center"><form action="registerServlet" method="post" name=form><table>用户名由字母、数字、下划线构成，*注释的项必须填写。<tr><td>*用户名称:</td><td><Input type=text name="logname" ></td><td>*用户密码:</td><td><Input type=password name="password"></td></tr><tr><td>*重复密码:</td><td><Input type=password name="again_password"></td><td>联系电话:</td><td><Input type=text name="phone"></td></tr><tr><td>邮寄地址:</td><td><Input type=text name="address"></td><td>真实姓名:</td><td><Input type=text name="realname"></td><td><Input type=submit name="g" value="提交"></td> </tr></table></form></div ><div align="center"><p> 注册反馈：<jsp:getProperty name="userBean" property="backNews" /> <table border=3><tr><td>会员名称:</td><td><jsp:getProperty name="userBean" property="logname"/></td></tr><tr><td>姓名:</td><td><jsp:getProperty name="userBean" property="realname"/></td></tr><tr><td>地址:</td><td><jsp:getProperty name="userBean" property="address"/></td></tr><tr><td>电话:</td><td><jsp:getProperty name="userBean" property="phone"/></td></tr></table></div ></body></html><%@ page contentType="text/html;charset=GB2312" %><jsp:useBean id="loginBean" class="mybean.data.Login" scope="session"/><html><head><%@ include file="head.txt" %></head><body bgcolor=pink><font size=2><div align="center"><table border=2><tr> <th>登录</th></tr><form action="loginServlet" Method="post"><tr><td>登录名称:<Input type=text name="logname"></td></tr><tr><td>输入密码:<Input type=password name="password"></td></tr></table><Input type=submit name="g" value="提交"></form></div ><div align="center" >登录反馈信息:<br><jsp:getProperty name="loginBean" property="backNews"/><br>登录名称:<br><jsp:getProperty name="loginBean" property="logname"/><div ></font></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=123&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" %><jsp:useBean id="loginBean" class="mybean.data.Login" scope="session"/><%@ page import="java.sql.*" %><HTML><HEAD><%@ include file="head.txt" %></HEAD><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="123";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>
