javaWeb书店管理系统方案.docx

《javaWeb书店管理系统方案.docx》由会员分享，可在线阅读，更多相关《javaWeb书店管理系统方案.docx（48页珍藏版）》请在三一文库上搜索。

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

2、用tomcat。如下图展示：2015/1/1 20:27* k2015/1/1 20:27,WEB-INF2015/1/1 20:23回 add_book.jsp2015/1/1 21:212 KB国 buy.jsp2015/1/1 21212 KB包 edrtjap2015/1/1 21:212 KB,failure_mjsp2014/12/29 12:591 KB| failure_rjsp2014/12/29 12:591 KBmdex.html2015/1/1 20:342 KB,manager.jsp2015/1/2 14:292 KBprint_crdenjsp2015/1/1 2

3、0:351 KBr&aderjsp2015/1/2 14:192 KBI 1; sear_result_m.Mf2015/1/2 15:3。2 KBsear_result_rjsp2015/1/1 20:322 KBl3j search_rjsp2015/1/2 14221 KB131, succes5_buyjsp2015/1/2 15:552 KBsuccess_iTi.jsp2015/1/1 20:321 KB3）对系统进行测试分析，并对系统功能实施测试，编写 测试用例，系统已经实现可以让手机电脑一起访问并 做操作；4）撰写实验报告，同时需要了解测试报告相应的规范与 写法。1.下面是一些

4、界面的 展示（没有全部展示）：登录页面您忘记密码?友请连接sinasohuCopyright 2014-2015NETW0RK 席崩和句翔熬于专业资料整理顾客首页现有图书信息占一百i目第注书名作者出IK社丽间价格库存购买m2411120弋1讲义鼻寓北京大苧出版tt吩424aS20121011190过门!5图如流江中国样城大字出版社2U14-2-I532132012011203s讲义表网尤臣大学出西杜2Q114翻4Q1Q曲】加1128力同I的李刚奢华大学士藏社2011-1-16轴g2012011206软件工程塞再明竟由大学出囱社2012-2-1234520121011210jmfliVflb张三

5、算华大学出版社2014-1-163510201 Zd 112 9 2扼瞬李宝安青华大学出函社2011-1-2630163012011314加，学卓手用中国科技大苧出版杜200-13-15592也1颔1扰的大学英语赤叶声中*学出版社2cm3的301218交购买页面订单信息里号书名作者出版社出版日期饰格库存根袈数量2012011190也程或图刘建斌中国科技五学出新社2014-2-6豆订单页面讨单信息已审核完毕势号20111190书名作者对大城出版社坤国科技大竽出版社出版日期3014-2-6价格32库存10内买副量2打即.|g|正在打印订单，请稍候.一返回主页查询页面图书信息查询嗝号查询二书名查询:

6、作者查询:腹交查询结果查询结果毋号作者出版社出康日明希格库存的英2012011207”母李因得华大学出原社2011-3-16酹020120112101javaWfib珠三青华大学出翦社20-14-1-1655102012011214用归_*李冏中国号披大学出版社2000-12-1 &55B程交管理员页面糠加图书占+*也编写书名作者小境社出版1日明阶格库存管理2012091120C+#吠更蓝*;京大学出的壮1M4-12-434B触 imm zoiiim迥程瘟图口侬中国现技法不出呦2 0 14小七3216Ka tug和1 NII翻3讲我R比京大学野期刘IV例W侬ttB2Q2011207翔W詈华楞出

7、版社2011-146第g触 ftjs刘口西I120&软件工程fciiffl宜京大学却氏社2012-2-12343检曲tm刘1莉11210喷韭三青中大学出翊2014-1-1S3S10诞ttl2012011212视R摩者华大学出蜥士2011-1-M3015皿Hli2012011214所工卓旃中国村姑丈学出顿社200D-12-1655B皿HIM刘】刘120弟大学皈酒q娜看华大学出酎12000-2453012IM HB而同H币添加图书页面图书信息库存添加图书信息不完整页面图书信息三、完整开发代码（按照上面截图部署即可实现 ）Table.css:bodybackground: #ffffff;margi

8、n: 15;body,table,th,td,input,select,textareafont-family:Tahoma,Verdana,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: #

9、f0f0f0;table.default tr.title tdfont-weight: bold;text-align: center;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-

10、family: Arial, Helvetica, sans-serif;font-size:12px;color:#666666;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

11、:1px;margin:2px;font-size:11px;.buttompadding:1px 10px;font-size:12px;border:1px #1E7ACE solid;background:#D0F0FF;#formwrapper width:450px;margin:15Px auto;padding:20px;text-align:left;border:1pxsolid #A4CDF2;fieldset padding:10px;margin-top:5px;border:1px solid #A4CDF2;background:#fff;fieldset lege

12、nd color:#1E7ACE;font-weight:bold;padding:3px 20px 3px 20px;border: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

13、 isNum(num)for(i=0;i9|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 name!);form1.name.focus();return false;if(form1.author.value=)alert(no author!);form1.author.focus();return false;if(form1.press.value=)aler

14、t(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 wrong!) form1.price.focus(); return false;if(!isNum(form1.account) alert(account is wring!) form1.account.focus(); return false;Bookinfo.java: pac

15、kage bean;import java.lang.String;import java.lang.System;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;public class bookinfoprivate String id;private String name;private String author;private String press;private String date;private int price;private int account;

16、public void setName(String name) this.name = name;public String getName() return name;public void setAuthor(String author) this.author = author;public String getAuthor() return author;public void setDate(String date) this.date = date;public String getDate() return date;public void setPress(String pr

17、ess) this.press = press;public String getPress() return press;public void setId(String id) this.id = id;public String getId() return id;public void setAccount(int acount) this.account = acount;public int getAccount() return account;public void setPrice(int price) this.price = price;public int getPri

18、ce() return price;list=newpublic static ArrayList getbooklist()ArrayListArrayList();String sql=select * from book.bookshop;dbbean jdbc=new 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

19、.getString(author);bi.setPress(rs.getString(press);bi.setDate(rs.getString(date);bi.setPrice(rs.getInt(price); bi.setAccount(rs.getInt(account);list.add(bi);rs.close();catch(SQLException e) e.printStackTrace();jdbc.close();return list;/ 通过编号书名作者来搜索publicstaticArrayListgetbookbyway(String id,String n

20、ame,String author)ArrayListlist=newArrayList(); String sql=null; int way=0; if (!id.equals()way=way+1; if (!name.equals()way=way+10; if (!author.equals()way=way+100;if (way=1|way=11|way=101) sql=select* from book.bookshop whereid=+id+”;if (way=10) sql=select* from book.bookshop wherename like %+name

21、+%”；if (way=100) sql=select * from bookshop where author like %+author+%;if (way=110) sql=select* from bookshop where namelike %+name+% and author like %+author+%;dbbean jdbc=new dbbean();ResultSet rs=jdbc.executeQuery(sql);trywhile(rs.next()bookinfo bi=new bookinfo();bi.setDate(rs.getString(date);b

22、i.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);list.add(bi);rs.close();catch(SQLException e)System.out.println(no find);jdbc.close();return list;public static booki

23、nfo 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();tryif(rs.next()bi.setDate(rs.getString(date);bi.setPress(rs.getString(press);bi.setAuthor(rs.getString(author);bi.setName(rs.getSt

24、ring(name);bi.setId(rs.getString(id);bi.setPrice(rs.getInt(price);bi.setAccount(rs.getInt(account);rs.close();catch(SQLException e)System.out.println(no find);jdbc.close();return bi;public static int updatebook(String id,String name,String author,String press,String date,int price,int account)int re

25、sult=0;Stringsql=update book.bookshop setname=+name+,author=+author+,press=+press+ ,date=+date+,price=+price+,account=+accoun t+ where id=+id+”;dbbean jdbc=new dbbean();result=jdbc.executeUpdate(sql);return result;public static int deletebook(String id)int result=0;String sql=delete from book.booksh

26、op whereid=+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 result=0;Stringsql=insertintobook.bookshop(id,name,author,press,date,price,accou nt) values(+id+,+nam

27、e+,+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 dbbeanprivateStringdriverStr=com.mysql.jdbc.Driver;privateStringconnStr=jdbc:mysql:/localhost:3306/book?char

28、acterEncoding=utf-8;private 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,passw ord);stmt=conn.createStatement();catch(Exception ex)System.out.print

29、ln(connectto databaseis worry!); public int executeUpdate(String s) int result=0; tryresult=stmt.executeUpdate(s);catch(Exception ex)System.out.println(update wrong!);return result; public ResultSet executeQuery(String s)ResultSet rs=null;tryrs=stmt.executeQuery(s);catch(Exception ex)System.out.prin

30、tln(search wrong!); return rs; public void close()trystmt.close();conn.close();thecatch(Exception ex)System.out.println(cannot closedatabase!); Servlet.java:package servlets;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;impor

31、t javax.servlet.http.HttpServletResponse;import java.io.IOException;import java.util.ArrayList;import java.lang.*;/* Created by Administrator on 14-5-31.*/ public class Servlet extends HttpServlet protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException,

32、 IOException doPost(request, response);protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException request.setCharacterEncoding(utf-8);String action=request.getServletPath();if(action.equals(/servlets/depend.do)String value=request.getParamete

33、r(password);if(value.equals(123)ArrayListlist=bean.bookinfo.getbooklist(); request.setAttribute(list, list);request.getRequestDispatcher(/manager.jsp).forwar d(request,response); elseArrayList list=bean.bookinfo.getbooklist(); request.setAttribute(list, list);request.getRequestDispatcher(/reader.jsp

34、).forward (request,response); elseif(action.equals(/servlets/list_m.do)ArrayListlist=bean.bookinfo.getbooklist();request.setAttribute(list, list);request.getRequestDispatcher(/manager.jsp).forwar d(request,response);elseif(action.equals(/servlets/list_r.do)ArrayListlist=bean.bookinfo.getbooklist();

35、request.setAttribute(list, list);request.getRequestDispatcher(/reader.jsp).forward (request,response);else if(action.equals(/servlets/edit.do)String id =request.getParameter(id);bean.bookinfobi=bean.bookinfo.getbookbyid(id); request.setAttribute(bi,bi);request.getRequestDispatcher(/edit.jsp).forward

36、(r equest,response);elseif(action.equals(/servlets/update.do)String id=request.getParameter(id);Stringname=request.getParameter(name);Stringauthor=request.getParameter(author);Stringpress=request.getParameter(press);Stringdate=request.getParameter(date);Strings_price=request.getParameter(price);Stri

37、ngs_account=request.getParameter(account);int price=Integer.parseInt(s_price);int account=Integer.parseInt(s_account);intr=bean.bookinfo.updatebook(id,name,author,press,date, price,account);if (r=1) request.getRequestDispatcher(/success_m.jsp).forw ard(request,response);elserequest.getRequestDispatc

38、her(/failure_m.jsp).forward(request,response);elseif(action.equals(/servlets/delete.do)String id=request.getParameter(id);int r= bean.bookinfo.deletebook(id);if (r=1)request.getRequestDispatcher(/success_m.jsp).forw ard(request,response);elserequest.getRequestDispatcher(/failure_m.jsp).forward(reque

39、st,response);else if (action.equals(/servlets/add.do)String id=request.getParameter(id);Stringname=request.getParameter(name);Stringauthor=request.getParameter(author);Stringpress=request.getParameter(press);Stringdate=request.getParameter(date);Strings_price=request.getParameter(price);Strings_acco

40、unt=request.getParameter(account);int price=Integer.parseInt(s_price);int account=Integer.parseInt(s_account);intr= bean.bookinfo.addbook(id, name,author, press, date,price,account);if (r=1)request.getRequestDispatcher(/success_m.jsp).forw ard(request,response);elserequest.getRequestDispatcher(/fail

41、ure_m.jsp).forw ard(request,response);else if (action.equals(/servlets/buy.do)String buy=request.getParameter(buy);bean.bookinfobi=bean.bookinfo.getbookbyid(buy);request.setAttribute(bi,bi);request.getRequestDispatcher(/buy.jsp).forward(re quest,response);elseif(action.equals(/servlets/search_r.do)String id=request.getParameter(id);Stringname=request.getParameter(name);Stringauthor=request.getParameter(author);String user=request.getParameter(user);ArrayListlist=bean.bookinfo.getbookbyway(id,name,author);request.setAttribute(list, list); if (use