javaWeb书店管理系统方案

1、word格式可编辑一、实验目的1)理解并掌握编码与测试相关理论与方法；2)进一步熟悉利用编程语言实现系统；3)要求学生理解测试在软件开发中的重要地位；4)学生了解测试用例与测试报告的相关书写规范。二、实验内容与要求1)根据系统的特点，选取javaWebMVC开发模型实现该系统；2)系统的编码结构：边界类：1个html（项目首页），13个jsp（中间跳转的页面），一个css（界面美化功能），一个javascript（控制输入合法性）。控制类：一个servlet类（连接边界类和实体类）实体类：一个datebase类（连接数据库），一个bookinfo类（书本的增删检查操作）服务器采用tomcat。

2、如下图展示：专业资料整理word格式可编辑3)对系统进行测试分析，并对系统功能实施测试，编写测试用例，系统已经实现可以让手机电脑一起访问并做操作；4)撰写实验报告，同时需要了解测试报告相应的规范与写法。1.下面是一些界面的展示（没有全部展示）：登录页面专业资料整理word格式可编辑顾客首页购买页面订单页面专业资料整理word格式可编辑查询页面查询结果管理员页面专业资料整理word格式可编辑添加图书页面添加图书信息不完整页面专业资料整理word格式可编辑三、完整开发代码(按照上面截图部署即可实现)Table.css:bodybackground:#ffffff;margin:15;body,ta

3、ble,th,td,input,select,textareafont-family:Tahoma,Verdana,Arial,Helvetica,sans-serif;font-size:12px;table.defaultborder:1pxsolid#3366CC;border-collapse:collapse;专业资料整理word格式可编辑width:80%;table.defaulttdpadding:2525;height:26px;text-align:center;border:1pxsolid#ffffff;background-color:#f0f0f0;table.de

4、faulttr.titletdfont-weight:bold;text-align:center;background:#99CCFF;color:red;border:1pxsolid#ffffff;white-space:nowrap;height:26px;table.defaultth.itemfont-weight:bold;color:#333333;text-align:center;专业资料整理word格式可编辑vertical-align:top;padding:10px;font-size:14px;xyh.css:bodyfont-family:Arial,Helvet

5、ica,sans-serif;font-size:12px;color:#666666;background:#fff;text-align:center;*margin:0;padding:0;acolor:#1E7ACE;text-decoration:none;a:hovercolor:#000;text-decoration:underline;h3font-size:14px;font-weight:bold;pre,pcolor:#1E7ACE;margin:4px;input,select,textareapadding:1px;margin:2px;font-size:11px

6、;.buttompadding:1px10px;font-size:12px;border:1px#1E7ACEsolid;background:#D0F0FF;#formwrapperwidth:450px;margin:15pxauto;padding:20px;text-align:left;border:1px#A4CDF2;solid专业资料整理word格式可编辑fieldsetpadding:10px;margin-top:5px;border:1pxsolid#A4CDF2;background:#fff;fieldsetlegendcolor:#1E7ACE;font-weig

7、ht:bold;padding:3px20px3px20px;border:1pxsolid#A4CDF2;background:#fff;fieldsetlabelfloat:left;width:120px;text-align:right;padding:4px;margin:1px;fieldsetdivclear:left;margin-bottom:2px;.inputwidth:120px;.entertext-align:center;.clearclear:both;Common.js:functionisNum(num)for(i=0;i9|c0)returnfalse;专

8、业资料整理word格式可编辑returntrue;functioncheck()if(form1.id.value=)alert(noid!);form1.id.focus();returnfalse;if(.value=)alert(noname!);.focus();returnfalse;if(form1.author.value=)alert(noauthor!);form1.author.focus();returnfalse;if(form1.press.value=)专业资料整理word格式可编辑alert(nopress!);form1.press.focus();return

9、false;if(form1.date.value=)alert(nodate!)form1.date.focus();returnfalse;if(!isNum(form1.price)alert(priceiswrong!)form1.price.focus();returnfalse;if(!isNum(form1.account)alert(accountiswring!)form1.account.focus();returnfalse;专业资料整理word格式可编辑Bookinfo.java:packagebean;importjava.lang.String;importjava

10、.lang.System;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.ArrayList;publicclassbookinfoprivateStringid;privateStringname;privateStringauthor;privateStringpress;privateStringdate;privateintprice;privateintaccount;publicvoidsetName(Stringname)=name;publicStringgetName()returnna

11、me;专业资料整理word格式可编辑publicvoidsetAuthor(Stringauthor)this.author=author;publicStringgetAuthor()returnauthor;publicvoidsetDate(Stringdate)this.date=date;publicStringgetDate()returndate;publicvoidsetPress(Stringpress)this.press=press;专业资料整理word格式可编辑publicStringgetPress()returnpress;publicvoidsetId(Strin

12、gid)this.id=id;publicStringgetId()returnid;publicvoidsetAccount(intacount)this.account=acount;publicintgetAccount()returnaccount;publicvoidsetPrice(intprice)this.price=price;专业资料整理word格式可编辑publicintgetPrice()returnprice;publicstaticArrayListgetbooklist()ArrayListlist=newArrayList();Stringsql=select*

13、frombook.bookshop;dbbeanjdbc=newdbbean();ResultSetrs=jdbc.executeQuery(sql);trywhile(rs.next()bookinfobi=newbookinfo();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);

14、专业资料整理word格式可编辑bi.setAccount(rs.getInt(account);list.add(bi);rs.close();catch(SQLExceptione)e.printStackTrace();jdbc.close();returnlist;/通过编号书名作者来搜索publicstaticArrayListgetbookbyway(Stringid,Stringname,Stringauthor)ArrayListlist=newArrayList();Stringsql=null;intway=0;if(!id.equals()way=way+1;if(!nam

15、e.equals()way=way+10;if(!author.equals()way=way+100;专业资料整理word格式可编辑if(way=1|way=11|way=101)sql=select*frombook.bookshopwhereid=+id+;if(way=10)sql=select*frombook.bookshopwherenamelike%+name+%;if(way=100)sql=select*frombookshopwhereauthorlike%+author+%;if(way=110)sql=select*frombookshopwherenamelike%

16、+name+%andauthorlike%+author+%;dbbeanjdbc=newdbbean();ResultSetrs=jdbc.executeQuery(sql);trywhile(rs.next()专业资料整理word格式可编辑bookinfobi=newbookinfo();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);b

17、i.setPrice(rs.getInt(price);bi.setAccount(rs.getInt(account);list.add(bi);rs.close();catch(SQLExceptione)System.out.println(nofind);jdbc.close();returnlist;publicstaticbookinfogetbookbyid(Stringid)专业资料整理word格式可编辑Stringsql=select*frombook.bookshopwhereid=+id+;dbbeanjdbc=newdbbean();ResultSetrs=jdbc.e

18、xecuteQuery(sql);bookinfobi=newbookinfo();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

19、e)System.out.println(nofind);专业资料整理word格式可编辑jdbc.close();returnbi;publicstaticintupdatebook(Stringid,Stringname,Stringauthor,Stringpress,Stringdate,intprice,intaccount)intresult=0;Stringsql=updatebook.bookshopsetname=+name+,author=+author+,press=+press+,date=+date+,price=+price+,account=+account+whe

20、reid=+id+;dbbeanjdbc=newdbbean();result=jdbc.executeUpdate(sql);returnresult;publicstaticintdeletebook(Stringid)intresult=0;Stringsql=deletefrombook.bookshopwhereid=+id+;专业资料整理word格式可编辑dbbeanjdbc=newdbbean();result=jdbc.executeUpdate(sql);returnresult;publicstaticintaddbook(Stringid,Stringname,Strin

21、gauthor,Stringpress,Stringdate,intprice,intaccount)intresult=0;Stringsql=insertintobook.bookshop(id,name,author,press,date,price,account)values(+id+,+name+,+author+,+press+,+date+,+price+,+account+);dbbeanjdbc=newdbbean();result=jdbc.executeUpdate(sql);returnresult;专业资料整理word格式可编辑Dbbean.java:package

22、bean;importjava.lang.*;importjava.sql.*;publicclassdbbeanprivateStringdriverStr=com.mysql.jdbc.Driver;privateStringconnStr=jdbc:mysql:/localhost:3306/book?characterEncoding=utf-8;privateStringname=root;privateStringpassword=xyh201268;privateConnectionconn=null;privateStatementstmt=null;publicdbbean(

23、)tryClass.forName(driverStr);专业资料整理word格式可编辑conn=DriverManager.getConnection(connStr,name,password);stmt=conn.createStatement();catch(Exceptionex)System.out.println(connecttodatabaseisworry!);publicintexecuteUpdate(Strings)intresult=0;tryresult=stmt.executeUpdate(s);catch(Exceptionex)System.out.prin

24、tln(updatewrong!);returnresult;publicResultSetexecuteQuery(Strings)ResultSetrs=null;try专业资料整理word格式可编辑rs=stmt.executeQuery(s);catch(Exceptionex)System.out.println(searchwrong!);returnrs;publicvoidclose()trystmt.close();conn.close();catch(Exceptionex)System.out.println(cannotclosethedatabase!);Servle

25、t.java:packageservlets;importjavax.servlet.ServletException;专业资料整理word格式可编辑importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importjava.io.IOException;importjava.util.ArrayList;importjava.lang.*;/*CreatedbyAdministratoron14-

26、5-31.*/publicclassServletextendsHttpServletprotectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOExceptiondoPost(request,response);protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOExceptionrequest.setCharac

27、terEncoding(utf-8);Stringaction=request.getServletPath();if(action.equals(/servlets/depend.do)String专业资料整理word格式可编辑value=request.getParameter(password);if(value.equals(123)ArrayListlist=bean.bookinfo.getbooklist();request.setAttribute(list,list);request.getRequestDispatcher(/manager.jsp).forward(req

28、uest,response);elseArrayListlist=bean.bookinfo.getbooklist();request.setAttribute(list,list);request.getRequestDispatcher(/reader.jsp).forward(request,response);else(action.equals(/servlets/list_m.do)ArrayListbean.bookinfo.getbooklist();专业资料整理iflist=word格式可编辑request.setAttribute(list,list);request.g

29、etRequestDispatcher(/manager.jsp).forward(request,response);else(action.equals(/servlets/list_r.do)ArrayListbean.bookinfo.getbooklist();request.setAttribute(list,list);iflist=request.getRequestDispatcher(/reader.jsp).forward(request,response);elseif(action.equals(/servlets/edit.do)Stringid=request.g

30、etParameter(id);bean.bookinfobean.bookinfo.getbookbyid(id);request.setAttribute(bi,bi);bi=request.getRequestDispatcher(/edit.jsp).forward(request,response);专业资料整理word格式可编辑elseif(action.equals(/servlets/update.do)Stringid=request.getParameter(id);Stringname=request.getParameter(name);Stringauthor=req

31、uest.getParameter(author);Stringpress=request.getParameter(press);Stringdate=request.getParameter(date);Strings_price=request.getParameter(price);Strings_account=request.getParameter(account);intprice=Integer.parseInt(s_price);intaccount=Integer.parseInt(s_account);intr=bean.bookinfo.updatebook(id,n

32、ame,author,press,date,price,account);if(r=1)专业资料整理word格式可编辑request.getRequestDispatcher(/success_m.jsp).forward(request,response);elserequest.getRequestDispatcher(/failure_m.jsp).forward(request,response);else(action.equals(/servlets/delete.do)Stringid=request.getParameter(id);intr=bean.bookinfo.del

33、etebook(id);if(r=1)ifrequest.getRequestDispatcher(/success_m.jsp).forward(request,response);elserequest.getRequestDispatcher(/failure_m.jsp).forward(request,response);专业资料整理word格式可编辑elseif(action.equals(/servlets/add.do)Stringid=request.getParameter(id);Stringname=request.getParameter(name);Stringau

34、thor=request.getParameter(author);Stringpress=request.getParameter(press);Stringdate=request.getParameter(date);Strings_price=request.getParameter(price);Strings_account=request.getParameter(account);intprice=Integer.parseInt(s_price);intaccount=Integer.parseInt(s_account);intr=bean.bookinfo.addbook

35、(id,name,author,press,date,price,account);if(r=1)专业资料整理word格式可编辑request.getRequestDispatcher(/success_m.jsp).forward(request,response);elserequest.getRequestDispatcher(/failure_m.jsp).forward(request,response);elseif(action.equals(/servlets/buy.do)Stringbuy=request.getParameter(buy);bean.bookinfobi=

36、bean.bookinfo.getbookbyid(buy);request.setAttribute(bi,bi);request.getRequestDispatcher(/buy.jsp).forward(request,response);else(action.equals(/servlets/search_r.do)Stringid=request.getParameter(id);String专业资料整理ifword格式可编辑name=request.getParameter(name);Stringauthor=request.getParameter(author);Stri

37、nguser=request.getParameter(user);ArrayListbean.bookinfo.getbookbyway(id,name,author);request.setAttribute(list,list);if(user.equals(reader)list=request.getRequestDispatcher(/sear_result_r.jsp).forward(request,response);if(user.equals(manager)request.getRequestDispatcher(/sear_result_m.jsp).forward(

38、request,response);else(action.equals(/servlets/check_buy.do)专业资料整理ifword格式可编辑Stringid=request.getParameter(id);Strings_num_buy=request.getParameter(num_buy);intnum_buy=Integer.parseInt(s_num_buy);bean.bookinfobean.bookinfo.getbookbyid(id);if(bi.getAccount()=num_buy)request.setAttribute(bi,bi);bi=req

39、uest.setAttribute(s_num_buy,s_num_buy);request.getRequestDispatcher(/success_buy.jsp).forward(request,response);elserequest.getRequestDispatcher(/failure_r.jsp).forward(request,response);else(action.equals(/servlets/print_order.do)Stringid=request.getParameter(id);专业资料整理ifword格式可编辑Strings_num_buy=re

40、quest.getParameter(s_num_buy);bean.bookinfobi=bean.bookinfo.getbookbyid(id);intnum_buy=Integer.parseInt(s_num_buy);bean.bookinfo.updatebook(id,bi.getName(),bi.getAuthor(),bi.getPress(),bi.getDate(),bi.getPrice(),(bi.getAccount()-num_buy);request.getRequestDispatcher(/print_order.jsp).forward(request

41、,response);Add_book.jsp:专业资料整理word格式可编辑图书信息编号*(不能为空)书名*(不能为空)作者*(不能为空)出版社*(不能为空)专业资料整理word格式可编辑出版日期*(不能为空)价格*(只能数字)库存*(只能数字)buy.jsp:专业资料整理word格式可编辑订单信息编号inputtype=textvalue=name=name书名inputtype=textvalue=name=name专业资料整理word格式可编辑作者inputtype=textvalue=name=authorthtype=text出版社value=name=pressthtype=te

42、xt出版日期value=name=date价格inputtype=textvalue=name=price库存inputtype=textvalue=name=accountth购买数量type=textname=num_buy专业资料整理word格式可编辑edit.jsp:专业资料整理word格式可编辑修改信息编号inputtype=textvalue=name=id书名inputtype=textvalue=name=name作者inputtype=textvalue=name=authorthtype=text出版社value=name=pressthtype=text出版日期value

43、=name=date专业资料整理word格式可编辑价格inputtype=textvalue=name=price库存inputtype=textvalue=name=accountfailure_m.jsp:专业资料整理word格式可编辑操作失败点击返回failure_r.jsp:购买信息错误点击返回专业资料整理word格式可编辑index.html:图书商店用户登录顾客/管理员登录用户名专业资料整理word格式可编辑*(顾客不用输入)密码*(顾客不用输入)记住我专业资料整理word格式可编辑您忘记密码?友请连接sinasohuCopyright2014-2015NETWORK.席燚海邓匀翔袁野manager.jsp:添加图书ahref=/bookshop/search_r.jsp?user=点击查询编号书名作者出版社出版日期专业资料整理word格式可编辑价格库存管理%request.setCharacterEncoding(utf-8);ArrayListlist=(ArrayList)request.getAttribute(list);for(bookinfo