《javaWeb書店管理系統(tǒng)系統(tǒng)》由會(huì)員分享，可在線閱讀，更多相關(guān)《javaWeb書店管理系統(tǒng)系統(tǒng)（57頁(yè)珍藏版）》請(qǐng)?jiān)谘b配圖網(wǎng)上搜索。

1、、實(shí)驗(yàn)?zāi)康?）理解并掌握編碼與測(cè)試相關(guān)理論與方法；2）進(jìn)一步熟悉利用編程語(yǔ)言實(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)目首頁(yè)），13個(gè)jsp （中間跳轉(zhuǎn)的頁(yè)面），一個(gè)css （界面美化功能），一個(gè)javascript （控制輸入合法性）?？刂祁悾阂粋€(gè)servlet類（連接邊界類和實(shí)體類）實(shí)體類：一個(gè)datebase類（連接數(shù)據(jù)庫(kù)），一個(gè)book info 類（書本的 增刪檢查操作）服務(wù)器采用tomcat 。如下圖

2、展示：.C5S2015/1/1 20:27I .戶2015/1/1 20:27WEB-IWF2015/1/1 20:23,_ add.bcekj&p201S/1/1 21:212KE0 buyj年2015/1/1 21:212Bi gditjsp2015/1/1 21.212KBfailure_iTi.j5p2014/12/29 12:591KB.failure_r.jsp2014/12/2 12:591KBindesnhtrnl2015/1/120:342KBmsnager.jp2015/1/ 14：；S2ni3a1 Oa需ITvFl8m i/iOFM M1ES w聲KSKSlll|HP-4

3、H管sK*密X第s.13耳UdXA.tx 京乂歸丼匪粧棒K*s訂單信息已審檢亮卑2012011 90血日制32U2KISi正在打印訂單請(qǐng)稍候查詢頁(yè)面圖書宿息査詢*笛輸入則需芫整）水目認(rèn)關(guān)濯寧即可）咒輸入矣鍵宇即可）查詢結(jié)果躺號(hào)書色出匸牡32012011307卩唔it學(xué)阿51華檸20111665貼2nL2DL2La亦y梅b5K5畤4卒斗蔚；|20K-1-旳1D2ni2DL124旳衛(wèi)手冃中05科斗社嗣t3300-12-1655B血管理員頁(yè)面編耳書若ttft出am出丹曰期怕略1itrrry#iitW-1!-*科0ttikHA20329I11CK1jiWIKE3DH-34ieM.初】MILW1匚啊tl

4、R亂蘿丸黃倆t30II4-KIQ1昌gfljamnoiiZi#土丈利!KS牡35遜3tl2kll3U囚迴tISE番k攀如t如WK越amoiimJfl12-160ffit201201西丹4如扯Ft20OD-2-19tttt添加圖書頁(yè)面添加圖書信息不完整頁(yè)面圖書佶總nc narr?L三、完整開發(fā)代碼（按照上面截圖部署即可實(shí)現(xiàn)）Table.css:bodybackgro und:margi n: 15;body,table,th,td,i nput,select,textareafon t-family: T ahoma,Verda na,Arial,Helvetica,sa ns-serif;fo

5、n t-size: 12px;table.defaultborder: 1px solid #3366CC;border-collapse: collapse;width: 80%;table.default tdpaddi ng: 2 5 2 5;height: 26px;text-alig n: cen ter;border: 1px solid #ffffff; backgrou nd-color: #fOfOfO;table.default tr.title tdfon t-weight: bold;text-alig n: cen ter;backgrou nd: #99CCFF;c

6、olor: red;border: 1px solid #ffffff; white-space: no wrap;height: 26px;table.default th.itemfon t-weight: bold;color: #333333;text-alig n: cen ter;vertical-alig n: top;paddi ng: 10px; fon t-size: 14px;xyh.css:body fon t-family: Arial, Helvetica, san s-serif;fon t-size:12px;color:#666666;backgrou nd:

7、#fff;text-alig n:cen ter;* margi n:0;paddi ng:0;a color:#1E7ACE;text-decorati on:non e; a:hover color:#000;text-decoratio n:un derl in e;h3 fon t-size:14px;fo nt-weight:bold;pre,p color:#1E7ACE;margi n:4px;in put, select,textarea paddi ng:1px;margi n:2p x;fon t-size:11p x;.buttompadd in g:1px 10px;f

8、o nt-size:12px;border:1px #1E7ACE solid;backgro un d:#D0F0FF; #formwrapper width:450p x;m argi n:15px auto;paddi ng:20px;text-alig n:left;border:1px solid #A4CDF2; fieldset paddi ng:10px;marg in-top:5px;border:1px solid #A4CDF2;backgrou nd:#fff;fieldset lege nd color:#1E7ACE;fo nt-weight:bold;paddi

9、ng:3px 20px 3px 20px;border:1px solid #A4CDF2;backgro un d:#fff;fieldset label float:left;width:120px;text-alig n:right;paddi ng:4px;marg in :1px;fieldset div clear:left;marg in-bottom:2px;.in put width:120px;.en ter text-alig n:ce nter;.clear clear:both;Common.js:fun ctio n isNum( nu m) for(i=0;i9|

10、c0) return false; return true;function check() if(form1.id.value=”) alert ( no id!);form1.id.focus();return false; if(form1. name.value=) alert(” no n ame!);form1. name.focus(); return false; if(form1.author.value=) alert(no author!);form1.author.focus(); return false;if(form1.press.value=”) alert(

11、no press!);form1.press.focus();return false;if(form1.date.value=) alert(no date!) form1.date.focus(); return false;if(!isNum(form1.price) alert(price is wron g!) form1.price.focus(); return false;if(!isNum(form1.acco un t) alert(acco unt is wring!) form1.acco un t.focus(); return false;Bookinfo.java

12、:package bea n;import java .Ian g.Stri ng;import java .Ian g.System;import java.sql.ResultSet;import java.sql.SQLExcepti on;import java.util.ArrayList;public class book infoprivate String id;private String name;private String author;private String press;private String date;private int price;private

13、int acco unt;public void setName(Stri ng n ame) this. name = n ame;public String getName() return n ame;public void setAuthor(Stri ng author) this.author = author;public Stri ng getAuthor() return author;public void setDate(Stri ng date) this.date = date; public Stri ng getDate() return date;public

14、void setPress(Stri ng press) this.press = press;public String getPress() retur n press;public void setld(Stri ng id) this.id = id; public Stri ng getId() return id;public void setAcco un t(i nt aco unt) this.acco unt = aco unt;public int getAcco un t() retur n acco unt; public void setPrice(int pric

15、e) this.price = price;public int getPrice() retur n price;public static ArrayList getbooklist()ArrayList list=new ArrayList();String sql=select * from book.bookshop;dbbea n jdbc=new dbbea n();ResultSet rs=jdbc.executeQuery(sql);trywhile(rs. next()book info bi=new book info();bi.setld(rs.getStri ng(i

16、d);bi.setName(rs.getStri ng( name);bi.setAuthor(rs.getStri ng(author);bi.setPress(rs.getStri ng(press);bi.setDate(rs.getStri ng(date);bi.setPrice(rs.get In t(price);bi.setAcco un t(rs.get In t(acco un t); list.add(bi);rs.close();catch(SQLExceptio n e)e.pri ntStackTrace();jdbc.close();return list;/通過

17、編號(hào)書名作者來搜索n ame,Stri ngpublic static ArrayListgetbookbyway(Stringid,Stringauthor)ArrayList list=new ArrayList();String sql=n ull;int way=0;if (!id.equals()way=way+1;if (!n ame.equals()way=way+10;if (!author.equals()way=way+100;if (way=1|way=11|way=101)sql=select * from book.bookshop where id=+id+;if

18、(way=10)sql=select * from book.bookshop where n ame like %+name+%：if (way=100)sql=select * from bookshop where author like %+author+%；andif (way=110)sql=select * from bookshop where name like %+name+% author like %+author+%;dbbea n jdbc=new dbbea n();ResultSet rs=jdbc.executeQuery(sql);trywhile(rs.

19、next()book info bi=new book info();bi.setDate(rs.getStri ng(date);bi.setPress(rs.getStri ng(press);bi.setAuthor(rs.getStri ng(author);bi.setName(rs.getStri ng( name);bi.setld(rs.getStri ng(id);bi.setPrice(rs.get In t(price);bi.setAcco un t(rs.get In t(acco un t);list.add(bi);rs.close();catch(SQLExce

20、ptio n e)System.out.pri ntl n(” no fin d);jdbc.close();return list;public static book info getbookbyid(Stri ng id)String sql=select * from book.bookshop where id=+id+;dbbea n jdbc=new dbbea n();ResultSet rs=jdbc.executeQuery(sql);book info bi = new book in fo();tryif(rs. next()bi.setDate(rs.getStri

21、ng(date);bi.setPress(rs.getStri ng(press);bi.setAuthor(rs.getStri ng(author);bi.setName(rs.getStri ng( name);bi.setld(rs.getStri ng(id);bi.setPrice(rs.get In t(price);bi.setAcco un t(rs.get In t(acco un t);rs.close();catch(SQLExceptio n e)System.out.println(no find);jdbc.close();return bi;author,Str

22、i ngsetpublic static intupdatebook(Stri ngid,Stri ngn ame,Stri ngpress,String date,int price,int account)int result=0;Stringsql=updatebook.bookshopn ame=+name+,author=+author+,press=+press+,date=+date+,price= +price+,acco un t=+acco un t+ where id=+id+;dbbea n jdbc=new dbbea n();result=jdbc.executeU

23、pdate(sql);return result;public static int deletebook(String id)int result=O;String sql=delete from book.bookshop where id=+id+;dbbea n jdbc=new dbbea n();result=jdbc.executeUpdate(sql);return result;public static int addbook(String id,String name,String author,String press,String date,i nt price,i

24、nt acco un t)intoint result=0;Stringsql=i nsertbook.bookshop(id ,n ame,author,press,date,price,acco unt)values(”+id+,”+name+,”+author+,”+press+,”+date+,+price+,+accoun t+);dbbea n jdbc=new dbbea n();result=jdbc.executeUpdate(sql);return result;Dbbean.java:package bea n;import java .Ian g.*;import ja

25、va.sql.*;public class dbbea nprivate String driverStr=com.mysql.jdbc.Driver;Stri ngprivateconn Str=jdbc:mysql:/localhost:3306/book?characterE ncodi ng=utf-8;private String name=root;private Stri ng password=xyh201268;private Connection conn=n ull;private Stateme nt stmt=n ull;public dbbea n()tryClas

26、s.forName(driverStr);conn=DriverMa nager.getC onn ecti on(conn Str, name,password);stmt=c onn .createStateme nt();catch(Excepti on ex)System.out.pri ntln (conn ect to database is worry!);public int executeUpdate(Stri ng s)int result=0;tryresult=stmt.executeUpdate(s);catch(Excepti on ex)System.out.pr

27、i ntl n(update wrong!);return result;public ResultSet executeQuery(Stri ng s)ResultSet rs=n ull;tryrs=stmt.executeQuery(s);catch(Excepti on ex)System.out.pri ntl n(search wrong!);return rs;public void close()trystmt.close();c onn .close();catch(Excepti on ex)System.out.println(can not close the data

28、base!);Servlet.java:package servlets;import javax.servlet.ServletExceptio n;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResp on se;import java.i o.I OExcepti on;import java.util.ArrayList;import java .Ian g.*;/* Created by A

29、dmi nistrator on 14-5-31.*/public class Servlet exte nds HttpServlet protected void doGet(HttpServletRequestrequest, HttpServletResp onseresp on se) throws ServletExcepti on, I OExcepti on doPost(request, resp on se);protected void doPost(HttpServletRequestrequest, HttpServletResp onseresp on se) th

30、rows ServletExcepti on, I OExcepti on request.setCharacterE ncodi ng(utf-8);String action=request.getServletPath();if(act ion. equals(/servlets/depe nd.do)String value=request.getParameter(password);if(value.equals(123)ArrayList list= bean.bookinfo.getbooklist(); request.setAttribute(list, list);req

31、uest.getRequestDispatcher(/ma nager.jsp).forward(request,resp on se);elseArrayList list= bea n.book in fo.getbooklist();request.setAttribute(list, list);request.getRequestDispatcher(/reader.jsp).forward(request,resp on se);else if (act ion. equals(/servlets/list_m.do)ArrayList list= bean.bookinfo.ge

32、tbooklist(); request.setAttribute(list, list);request.getRequestDispatcher(/ma nager.jsp).forward(request,resp on se);else if (act ion. equals(/servlets/list_r.do)ArrayList list= bean.bookinfo.getbooklist(); request.setAttribute(list, list);request.getRequestDispatcher(/reader.jsp).forward(request,r

33、esp on se);else if(act ion. equals(/servlets/edit.do)String id =request.getParameter(id);bea n. book info bi= bea n.book in fo.getbookbyid(id);request.setAttribute(bi,bi);request.getRequestDispatcher(/edit.jsp).forward(request,resp on se);else if(act ion. equals(/servlets/update.do)String id=request

34、.getParameter(id);String n ame=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_acco un t=request.getParameter(acco un t);int price=ln teger.parse

35、 In t(s_price);int acco unt=ln teger.parse In t(s_acco un t);r=intbea n. book in fo.updatebook(id, name,author,press,date,price,acco un t);if (r=1)request.getRequestDispatcher(/success_m.jsp).forward(request,resp on se);elserequest.getRequestDispatcher(/failure_m.jsp).forward(request,resp on se);els

36、e if (actio n.equals(/servlets/delete.do)String id=request.getParameter(id);int r= bea n. book in fo.deletebook(id);if (r=1)request.getRequestDispatcher(/success_m.jsp).forward(request,resp on se);elserequest.getRequestDispatcher(/failure_m.jsp).forward(request,resp on se);else if (act ion. equals(/

37、servlets/add.do)String id=request.getParameter(id);String n ame=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_acco un t=request.getParameter(ac

38、co un t);int price=ln teger.parse In t(s_price);int acco unt=ln teger.parse In t(s_acco un t);press,int r=bea n. book in fo.addbook(id,n ame,author,date,price,acco un t);if (r=1)request.getRequestDispatcher(/success_m.jsp).forward(request,resp on se);elserequest.getRequestDispatcher(/failure_m.jsp).

39、forward(request,resp on se);else if (act ion. equals(/servlets/buy.do)String buy=request.getParameter(buy);bea n. book info bi=bea n. book in fo.getbookbyid(buy);request.setAttribute(bi,bi); request.getRequestDispatcher(/buy.jsp).forward(request,resp on se);else if (act ion. equals(/servlets/search_

40、r.do)String id=request.getParameter(id);String n ame=request.getParameter( name);String author=request.getParameter(author);String user=request.getParameter(user);list=ArrayListbea n. book in fo.getbookbyway(id, name,author);request.setAttribute(list, list);if (user.equals(reader)request.getRequestD

41、ispatcher(/sear_result_r.jsp).forward(request,resp on se);if (user.equals(ma nager)request.getRequestDispatcher(/sear_result_m.jsp).forward(request,resp on se);else if (act ion. equals(/servlets/check_buy.do)String id=request.getParameter(id);String s_nu m_buy=request.getParameter( nu m_buy);int nu

42、m_buy =ln teger.parse In t(s_ nu m_buy);bea n. book info bi= bea n.book in fo.getbookbyid(id);if(bi.getAcco un t() =nu m_buy)request.setAttribute(bi,bi);request.setAttribute(s_ nu m_buy,s_ nu m_buy); request.getRequestDispatcher(/success_buy.jsp).forward(request,resp on se);elserequest.getRequestDis

43、patcher(/failure_r.jsp).forward(request,resp on se);else if (act ion. equals(/servlets/pri nt_order.do)String id=request.getParameter(id);String s_nu m_buy=request.getParameter(s_ nu m_buy);bea n. book info bi= bea n.book in fo.getbookbyid(id);int nu m_buy =ln teger.parse In t(s_ nu m_buy);bea n. bo

44、ok in fo.updatebook(id,bi.getName(),bi.getAuthor(),bi.getPress(),bi.getDate( ),bi.getPrice(),(bi.getAcco un t()-nu m_buy);request.getRequestDispatcher(/pri nt_order.jsp).forward(request,resp on se);Add_book.jsp: vformn ame=form1on submit=retur ncheck（）action=/bookshop/servlets/add.do method=post圖書信息

45、 編 號(hào)*（不能為空）書 名*（不能為空）作 者 *（ 不能為空）name=press*（不能為空）出版日期 *（ 不能為空）價(jià) 格 *（只能數(shù)字）庫(kù) 存 *（只能數(shù)字）buy.jsp: 訂單信息 編 號(hào) in putvalue= n ame=n ame 書名 in putvalue= n ame=n ame 作者 in putvalue= name=author 出版社 i nputvalue= n ame=press 出版日期 inputtype=texttype=texttype=texttype=texttype=textvalue= name=date value= n ame=pr

46、ice 庫(kù) 存 in putvalue= n ame=acco un t 購(gòu)買數(shù)量 edit.jsp:type=texttype=textIan guage=java 修改信息 編 號(hào) in puttype=textvalue= name=id 書名 input type=text value= n ame=n ame 作者 input type=text value= n ame=author 出版社 inputtype=textvalue= n ame=press 出版日期 inputtype=textvalue= name=date value= n ame=price type=text 庫(kù) 存 in