javaWeb書店管理系統(tǒng)
《javaWeb書店管理系統(tǒng)》由會(huì)員分享,可在線閱讀,更多相關(guān)《javaWeb書店管理系統(tǒng)(21頁珍藏版)》請(qǐng)?jiān)谘b配圖網(wǎng)上搜索。
1、一、實(shí)驗(yàn)?zāi)康?) 理解并掌握編碼與測(cè)試相關(guān)理論與方法;2) 進(jìn)一步熟悉利用編程語言實(shí)現(xiàn)系統(tǒng);3) 要求學(xué)生理解測(cè)試在軟件開發(fā)中的重要地位;4) 學(xué)生了解測(cè)試用例與測(cè)試報(bào)告的相關(guān)書寫規(guī)范。二、實(shí)驗(yàn)內(nèi)容與要求1) 根據(jù)系統(tǒng)的特點(diǎn),選取 javaWeb MVC 開發(fā)模型實(shí)現(xiàn)該系統(tǒng);2) 系統(tǒng)的編碼結(jié)構(gòu):邊界類: 1 個(gè) html (項(xiàng)目首頁), 13 個(gè) jsp (中間跳轉(zhuǎn)的頁面),一個(gè)css(界面美化功能),一個(gè)javascript (控制輸入合法性)??刂祁悾阂粋€(gè) servlet 類(連接邊界類和實(shí)體類)實(shí)體類:一個(gè) datebase類(連接數(shù)據(jù)庫),一個(gè)bookinfo類(書本的增刪檢查操作)
2、服務(wù)器采用 tomcat 。如下圖展示:3) 對(duì)系統(tǒng)進(jìn)行測(cè)試分析,并對(duì)系統(tǒng)功能實(shí)施測(cè)試,編寫測(cè)試用例,系統(tǒng)已經(jīng)實(shí)現(xiàn)可以讓手機(jī)電腦一起訪問并做操作;4) 撰寫實(shí)驗(yàn)報(bào)告,同時(shí)需要了解測(cè)試報(bào)告相應(yīng)的規(guī)范與寫法。1. 下面是一些界面的 展示(沒有全部展示):登錄頁面顧客首頁購買頁面訂單頁面查詢頁面查詢結(jié)果管理員頁面添加圖書頁面添加圖書信息不完整頁面三、完整開發(fā)代碼 (按照上面截圖部署即可實(shí)現(xiàn))Table.css:bodybackground: #ffffff;margin: 15;body,table,th,td,input,select,textareafont-family: Tahoma,Ver
3、dana,Arial,Helvetica,sans-serif;font-size: 12px;table.defaultborder: 1px solid #3366CC;border-collapse: collapse;width: 80%;table.default tdpadding: 2 5 2 5;height: 26px;text-align: center;border: 1px solid #ffffff;background-color: #f0f0f0;table.default tr.title tdfont-weight: bold;text-align: cent
4、er;background: #99CCFF;color: red;border: 1px solid #ffffff;white-space: nowrap;height: 26px;table.default th.itemfont-weight: bold;color: #333333;text-align: center;vertical-align: top;padding: 10px;font-size: 14px;xyh.css:body font-family: Arial, Helvetica, sans-serif;font-size:12px;color:#666666;
5、background:#fff;text-align:center;* margin:0;padding:0;a color:#1E7ACE;text-decoration:none; a:hover color:#000;text-decoration:underline;h3 font-size:14px;font-weight:bold;pre,p color:#1E7ACE;margin:4px;input, select,textarea padding:1px;margin:2px;font-size:11px;.buttompadding:1px 10px;font-size:1
6、2px;border:1px #1E7ACE solid;background:#D0F0FF;#formwrapper width:450px;margin:15px auto; padding:20px;text-align:left;border:1px solid #A4CDF2;fieldset padding:10px;margin-top:5px;border:1px solid #A4CDF2;background:#fff;fieldset legend color:#1E7ACE;font-weight:bold; padding:3px 20px 3px 20px;bor
7、der:1px solid #A4CDF2; background:#fff;fieldset label float:left;width:120px;text-align:right;padding:4px;margin:1px;fieldset div clear:left;margin-bottom:2px;.input width:120px;.enter text-align:center;.clear clear:both;Common.js:function isNum(num)for(i=0;i9|c0)return false;return true;function ch
8、eck()alert (no id!);return false;alert(no name!);return false;alert(no author!);return false;alert(no press!);return false;alert(no date!)return false;if(!isNum(form1.price)alert(price is wrong!)return false;if(!isNum(form1.account)alert(account is wring!)return false;Bookinfo.java:package bean;publ
9、ic class bookinfoprivate String id;private String name;private String author;private String press;private String date;private int price;private int account;public void setName(String name) this.name = name;public String getName() return name;public void setAuthor(String author) this.author = author;
10、public String getAuthor() return author;public void setDate(String date) this.date = date;public String getDate() return date;public void setPress(String press) this.press = press;public String getPress() return press;public void setId(String id) this.id = id;public String getId() return id;public v
11、oid setAccount(int acount) this.account = acount;public int getAccount() return account;public void setPrice(int price) this.price = price;public int getPrice() return price;public static ArrayList getbooklist() ArrayList list=new ArrayList(); String sql=select * from book.bookshop; dbbean jdbc=new
12、dbbean();ResultSet rs=jdbc.executeQuery(sql);trywhile(rs.next()bookinfo bi=new bookinfo();bi.setId(rs.getString(id);bi.setName(rs.getString(name);bi.setAuthor(rs.getString(author);bi.setPress(rs.getString(press);bi.setDate(rs.getString(date);bi.setPrice(rs.getInt(price);bi.setAccount(rs.getInt(accou
13、nt);list.add(bi);rs.close();catch(SQLException e)e.printStackTrace();jdbc.close();return list;/通過編號(hào)書名作者來搜索public static ArrayList getbookbyway(String id,String name,String author) ArrayList list=new ArrayList();String sql=null;int way=0;if (!id.equals()way=way+1;if (!name.equals()way=way+10;if (!aut
14、hor.equals()way=way+100;if (way=1|way=11|way=101)sql=select * from book.bookshop where id=+id+;if (way=10)sql=select * from book.bookshop where name like %+name+%;if (way=100)sql=select * from bookshop where author like %+author+%;if (way=110)sql=select * from bookshop where name like %+name+% and a
15、uthor like %+author+%;dbbean jdbc=new dbbean();ResultSet rs=jdbc.executeQuery(sql);trywhile(rs.next()bookinfo bi=new bookinfo();bi.setDate(rs.getString(date);bi.setPress(rs.getString(press);bi.setAuthor(rs.getString(author);bi.setName(rs.getString(name);bi.setId(rs.getString(id);bi.setPrice(rs.getIn
16、t(price);bi.setAccount(rs.getInt(account);list.add(bi);rs.close();catch(SQLException e)jdbc.close();return list;public static bookinfo getbookbyid(String id)String sql=select * from book.bookshop where id=+id+; dbbean jdbc=new dbbean();ResultSet rs=jdbc.executeQuery(sql);bookinfo bi = new bookinfo()
17、;tryif(rs.next()bi.setDate(rs.getString(date);bi.setPress(rs.getString(press);bi.setAuthor(rs.getString(author);bi.setName(rs.getString(name);bi.setId(rs.getString(id);bi.setPrice(rs.getInt(price);bi.setAccount(rs.getInt(account);rs.close();catch(SQLException e)jdbc.close();return bi;public static i
18、nt updatebook(String id,String name,String author,String press,String date,int price,int account)int result=0;String sql=update book.bookshop setname=+name+,author=+author+,press=+press+,date=+date+,price=+price+,account=+account+ where id=+id+;dbbean jdbc=new dbbean();result=jdbc.executeUpdate(sql)
19、;return result;public static int deletebook(String id)int result=0;String sql=delete from book.bookshop where id=+id+;dbbean jdbc=new dbbean();result=jdbc.executeUpdate(sql);return result;public static int addbook(String id,String name,String author,String press,String date,int price,int account)int
20、 result=0;String sql=insert into book.bookshop(id,name,author,press,date,price,account) values(+id+,+name+,+author+,+press+,+date+,+price+,+account+);dbbean jdbc=new dbbean();result=jdbc.executeUpdate(sql);return result;Dbbean.java:package bean;import java.lang.*;import java.sql.*;public class dbbea
21、nprivate String name=root;private String password=xyh201268;private Connection conn=null;private Statement stmt=null;public dbbean()tryClass.forName(driverStr);conn=DriverManager.getConnection(connStr,name,password);stmt=conn.createStatement();catch(Exception ex)public int executeUpdate(String s)int
22、 result=0;tryresult=stmt.executeUpdate(s);catch(Exception ex)return result;public ResultSet executeQuery(String s)ResultSet rs=null;tryrs=stmt.executeQuery(s);catch(Exception ex)return rs;public void close()trystmt.close();conn.close();catch(Exception ex)Servlet.java:package servlets;import java.lan
23、g.*;/* Created by Administrator on 14-5-31.*/public class Servlet extends HttpServlet protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException doPost(request, response);protected void doPost(HttpServletRequest request, HttpServletResponse re
24、sponse) throws ServletException, IOException request.setCharacterEncoding(utf-8);String action=request.getServletPath();if(action.equals(/servlets/depend.do)String value=request.getParameter(password);if(value.equals(123)request.setAttribute(list, list);request.getRequestDispatcher(/manager.jsp).for
25、ward(request,response);elserequest.setAttribute(list, list);request.getRequestDispatcher(/reader.jsp).forward(request,response);else if (action.equals(/servlets/list_m.do)request.setAttribute(list, list);request.getRequestDispatcher(/manager.jsp).forward(request,response);else if (action.equals(/ser
26、vlets/list_r.do)request.setAttribute(list, list);request.getRequestDispatcher(/reader.jsp).forward(request,response);else if(action.equals(/servlets/edit.do)String id =request.getParameter(id);request.setAttribute(bi,bi);request.getRequestDispatcher(/edit.jsp).forward(request,response);else if(actio
27、n.equals(/servlets/update.do)String id=request.getParameter(id);String name=request.getParameter(name);String author=request.getParameter(author);String press=request.getParameter(press); String date=request.getParameter(date); String s_price=request.getParameter(price); String s_account=request.get
28、Parameter(account); int price=Integer.parseInt(s_price);int account=Integer.parseInt(s_account);if (r=1)request.getRequestDispatcher(/success_m.jsp).forward(request,response);elserequest.getRequestDispatcher(/failure_m.jsp).forward(request,response);else if (action.equals(/servlets/delete.do)String
29、id=request.getParameter(id);if (r=1)request.getRequestDispatcher(/success_m.jsp).forward(request,response);elserequest.getRequestDispatcher(/failure_m.jsp).forward(request,response);else if (action.equals(/servlets/add.do)String id=request.getParameter(id);String name=request.getParameter(name);Stri
30、ng author=request.getParameter(author);String press=request.getParameter(press);String date=request.getParameter(date);String s_price=request.getParameter(price);String s_account=request.getParameter(account);int price=Integer.parseInt(s_price);int account=Integer.parseInt(s_account);if (r=1)request
31、.getRequestDispatcher(/success_m.jsp).forward(request,response);elserequest.getRequestDispatcher(/failure_m.jsp).forward(request,response);else if (action.equals(/servlets/buy.do)String buy=request.getParameter(buy);request.setAttribute(bi,bi);request.getRequestDispatcher(/buy.jsp).forward(request,r
32、esponse);else if (action.equals(/servlets/search_r.do)String id=request.getParameter(id);String name=request.getParameter(name);String author=request.getParameter(author);String user=request.getParameter(user);request.setAttribute(list, list);if (user.equals(reader)request.getRequestDispatcher(/sear
33、_result_r.jsp).forward(request,response);if (user.equals(manager)request.getRequestDispatcher(/sear_result_m.jsp).forward(request,response);else if (action.equals(/servlets/check_buy.do)String id=request.getParameter(id);String s_num_buy=request.getParameter(num_buy); int num_buy=Integer.parseInt(s_
34、num_buy); if(bi.getAccount()=num_buy)request.setAttribute(bi,bi);request.setAttribute(s_num_buy,s_num_buy);request.getRequestDispatcher(/success_buy.jsp).forward(request,response); elserequest.getRequestDispatcher(/failure_r.jsp).forward(request,response);else if (action.equals(/servlets/print_order
35、.do)String id=request.getParameter(id);String s_num_buy=request.getParameter(s_num_buy); int num_buy=Integer.parseInt(s_num_buy); request.getRequestDispatcher(/print_order.jsp).forward(request,response);Add_book.jsp: 圖書信息 編號(hào) *( 不能為空) 書名 *( 不能為空 ) 作者 *( 不能為空 ) 出版社 *( 不能為空 ) 出版日期 *(不能為空 ) 價(jià)格 *( 只能數(shù)字 )
36、 庫存 *(只能數(shù)字 ) buy.jsp: 訂單信息 編號(hào) input type=text value= name=name 書名 input type=text value= name=name 作者 input type=text value= name=author 出版社 input type=text value= name=press 出版日期 input type=text value= name=date 價(jià)格 input type=text value= name=price 庫存 input type=text value= name=account 購買數(shù)量 edit.j
37、sp: 修改信息 編號(hào) input type=text value= name=id 書名 input type=text value= name=name 作者 input type=text value= name=author 出版社 input type=text value= name=press 出版日期 input type=text value= name=date 價(jià)格 input type=text value= name=price 庫存 input type=text value= name=account failure_m.jsp: 操作失敗 點(diǎn)擊返回 failur
38、e_r.jsp: 購買信息錯(cuò)誤 點(diǎn)擊返回 index.html:圖書商店用戶登錄 顧客 /管理員登錄 用戶名 *( 顧客不用輸入 ) 密碼 *( 顧客不用輸入 ) 記住我 您忘記密碼 ? 友請(qǐng) 連接 sina Copyright 2014-2015NETWORK. 席燚海鄧勻翔袁野 manager.jsp: 添加圖書 a href=/bookshop/search_r.jsp?user= 點(diǎn)擊查詢 編號(hào) 書名 作者 出版社 出版日期 價(jià)格 庫存 管理 %request.setCharacterEncoding(utf-8);ArrayList list=(ArrayList)request.getAttribute(list); for(bookinfo bi:list)String id=bi.getId();%= bi.getD
- 溫馨提示:
1: 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
2: 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
3.本站RAR壓縮包中若帶圖紙,網(wǎng)頁內(nèi)容里面會(huì)有圖紙預(yù)覽,若沒有圖紙預(yù)覽就沒有圖紙。
4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
5. 裝配圖網(wǎng)僅提供信息存儲(chǔ)空間,僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請(qǐng)與我們聯(lián)系,我們立即糾正。
7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。
最新文檔
- 第二課血與火的征服和掠奪
- 英英學(xué)古詩.英英學(xué)古詩 - 2
- 小苗與大叔的對(duì)話
- 天龍移動(dòng)產(chǎn)業(yè)與物聯(lián)網(wǎng)知識(shí)及技術(shù)國際領(lǐng)導(dǎo).商業(yè)計(jì)劃書
- 方便面調(diào)查問卷演示文稿課件
- (精品)一二陋室銘 (7)
- 千禧佳誠小區(qū)集中供冷暖(簡約版)
- (精品)4.神奇的紙(精品)
- 第6章 工廠供電系統(tǒng)的過流保護(hù)6-5
- 9福州八中選課排課和質(zhì)量監(jiān)控匯報(bào)
- 9、成功項(xiàng)目經(jīng)理系列教程之—建設(shè)高效團(tuán)隊(duì)
- 8三-3第3課制定發(fā)展措施
- 六西格瑪管理的發(fā)展5(1)
- 六西格瑪管理介紹
- 口語交際學(xué)古說今