當前位置：
首頁 >
前端技术
> javascript
>内容正文
javascript
《JSP程序设计》手机销售网
生活随笔
收集整理的這篇文章主要介紹了
《JSP程序设计》手机销售网
小編覺得挺不錯的,現(xiàn)在分享給大家,幫大家做個參考.
Web實驗報告
班級：信管1172 ??學號：201711671231 ??姓名：姚思敏
?
?功能說明
（一）用戶端
一、主頁
二、注冊
?
三、登錄
?
四、瀏覽手機
?
- 五、查詢手機
?
- 查看購物車
?
<%@ 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/>當前顯示的內(nèi)容是：<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("全部記錄數(shù)"+totalRecord); //全部記錄數(shù)int pageSize=dataBean.getPageSize(); //每頁顯示的記錄數(shù)int totalPages = dataBean.getTotalPages();if(totalRecord%pageSize==0)totalPages = totalRecord/pageSize;//總頁數(shù)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='查看細節(jié)' ></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>“智多星”智能手機銷售網(wǎng)</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>歡迎光臨“智多星”智能手機銷售網(wǎng)</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>用戶名由字母、數(shù)字、下劃線構成，*注釋的項必須填寫。<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>聯(lián)系電話:</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>- ?
總結
以上是生活随笔為你收集整理的《JSP程序设计》手机销售网的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： 前端学习（2509）：脚手架开发
- 下一篇： hpbios刷新工具_刷新：不会破产的工