网上购书系统设计文档毕业论文.doc

网上购书系统设计文档毕业论文1. 基本思想：网上购书系统是一个用Java Server Pages，Java Servlets，和javaBeans实现的基Java-based web页面系统，这个系统使用了MVC构架。在这个系统中视图是用jsp来实现的，所有的视图都是以.jsp结尾的文件，容器是的实现使用了Java Servlet,所有的容器都是以*Controller.java命名的。而所有的模型都是用JavaBean来实现的，并且讲这些模型方装在Commerce的包中。用户请求通过JSP送到Sevlet，再通过调用JavaBean来操纵数据库。这个网上购书系统是使用PostgreSQL作DBMS，而通过tomcat来模拟网上购书系统的运行。我们们希望通过这次实验使自己对本学期所学的知识有一个比较全面的了解和更深入的理解。2. 设计流程： 用户搜索书目，并将其放入篮子中。SearchControllersearch.jspBookTitleSetbookdetails.jspviewCart.jspAddBasketControllerCommerceBasketindex.jsp 用户登陆，如果没有注册，则注册CustomerLoginControllerlogin.jspregister.jspRegisterControllerlogin_ok.jspregistration-success.jsp填写邮寄地址并付款。login_ok.jspshipping-info.jspShippingInformationControllercardInformation.jspShippingInformationconfirm-order.jsp3. 代码.sql:create.sqldrop table OrderDetail;drop table Run;drop table BookTitle;drop table Promotion;drop table Publisher;drop table orders;drop table Customer;drop table Shipment;create table Promotion( Pno int, StartDate date, EndDate date, primary key (Pno);create table Publisher( Name varchar(20), Address varchar(50), primary key (Name);create table BookTitle( ISBN varchar(13), Author varchar(20), Title varchar(50), Edition varchar(50), PublishingDate date, Price float, BookDescription varchar(100), Categories varchar(20), PublisherName varchar(20), primary key (ISBN), foreign key (PublisherName) references Publisher(Name);create table Run( Pno int, ISBN varchar(13), foreign key (Pno) references Promotion(Pno), foreign key (ISBN) references BookTitle(ISBN);create table Customer( CreditNumber varchar(20), ExpirationDate date, Fname varchar(50), Lname varchar(50), Email varchar(50), Street varchar(250), City varchar(50), State varchar(50), PostalOrZipCode varchar(50), Country varchar(50), PhoneNumber varchar(50), Password varchar(50), primary key (Email);create table Orders( Ono int, MailingAddress varchar(100), ShipmentMethod varchar(20), OrderDateTime date, Email varchar(50), primary key (Ono), foreign key (Email) references Customer(Email);create table Shipment( TrackingNumber int, ShipmentDate date, ExpDeliveryDate date, primary key (TrackingNumber);create table OrderDetail( UnitPrice float, Qty int, ShipCost float, Tax float, ISBN varchar(13), Ono int, TrackingNumber int, primary key (ISBN,Ono,TrackingNumber), foreign key (ISBN) references BookTitle(ISBN), foreign key (Ono) references Orders(Ono), foreign key (TrackingNumber) references Shipment(TrackingNumber);insert.sqlINSERT INTO Promotion VALUES (22512,1/31/2006,2/28/2006);INSERT INTO Promotion VALUES (22513,2/10/2006,3/10/2006);INSERT INTO Promotion VALUES (22515,3/20/2006,4/30/2006);INSERT INTO Publisher VALUES (Javer Zanetti,1600 Pennsylvania Avenue,Washington);INSERT INTO Publisher VALUES (Cristian Vieri,4532 W 125th Street,New York);INSERT INTO Publisher VALUES (Alvaro Recoba,1 Sigma Way,Pittsburgh);INSERT INTO Publisher VALUES (John Herry,456 Elm St,Pittsburgh);INSERT INTO Publisher VALUES (Micheal Balake,123 Main St,Pittsburgh);INSERT INTO BookTitle VALUES (7-81080-702-1,Carlos Hernandez,Web Design and Development Black Book,1st,1/23/2002,56.00,Web Design,Web,Javer Zanetti); INSERT INTO BookTitle VALUES (4-61611-451-6,Dany Fonseca,Visual Basic Programmer,2nd,3/23/2005,78.00,learn VB,SoftWare,John Herry);INSERT INTO BookTitle VALUES (4-26623-656-4,Kurt Bernard,Core PHP Programming,3rd,6/5/2005,26.00,learn PHP,Web,John Herry);INSERT INTO BookTitle VALUES (4-54549-565-4,Walter Centeno,Java Programming for Dummies,1st,3/4/2004,95.00,Learn Java,SoftWare,Micheal Balake);INSERT INTO BookTitle VALUES (6-45412-561-5,Gerald Asamoah,Fundamentals of Database Systems,1st,1/5/2005,65.00,LearnDatabase Systems,Web,Alvaro Recoba);INSERT INTO BookTitle VALUES (1-45964-123-9,Miroslav Klose,Java Database Programming,2nd,3/2/2001,59.00,Learn Java,Web,Cristian Vieri);INSERT INTO BookTitle VALUES (1-62632-265-5,Mike Hanke,Information Systems and the Internet,3rd,2/11/2006,46.00,About Internet,Web,Cristian Vieri);INSERT INTO BookTitle VALUES (9-64648-415-3,Fernando Torres,Computer Algorithms,3rd,2/6/2003,98.00,Computer Algorithms,HardWare,John Herry);INSERT INTO BookTitle VALUES (5-49852-626-4,Danijel Ljuboja,The Effective Executive,4th,2/2/2005,26.00,Effective Executive,SoftWare,Cristian Vieri);INSERT INTO BookTitle VALUES (6-45457-452-9,Junichi Inamoto,Business Data Communications,2nd,3/1/2001,62.00,Business Data Communications,Web,Javer Zanetti);INSERT INTO BookTitle VALUES (4-66423-464-4,Djibril Cisse,Working Knowledge,3rd,2/3/2003,59.00,How to Design,SoftWare,Alvaro Recoba);INSERT INTO BookTitle VALUES (5-26266-262-2,David Trezeguet,An Introduction to Management Science,1st,2/12/2005,65.00,Management Science,SoftWare,Cristian Vieri);INSERT INTO Run VALUES (22512,4-54549-565-4);INSERT INTO Run VALUES (22512,1-62632-265-5);INSERT INTO Run VALUES (22513,4-61611-451-6);INSERT INTO Run VALUES (22513,5-26266-262-2);INSERT INTO Run VALUES (22515,4-66423-464-4);INSERT INTO Run VALUES (22515,5-26266-262-2); INSERT INTO Run VALUES (22515,5-49852-626-4);insert into Customer values(123456789,to_date(21-12-2007,dd-mm-yyyy),John,Doe,123123.com,123 Main st,Pittsburgh,PA,S,UN,412-555-5262,123);INSERT INTO orders VALUES (120,4615 Forbes Ave, Pittsburgh, PA 15147,general,to_date(05/10/2006,dd/mm/yyyy),123123.com);INSERT INTO orders VALUES (121,4613 Dalwen Ave, New York, PA 15264,general,to_date(05/1/2006,dd/mm/yyyy),123123.com);INSERT INTO orders VALUES (122,4600 Forbes Ave, Pittsburgh, PA 15154,NextDay,to_date(05/11/2006,dd/mm/yyyy),123123.com);INSERT INTO orders VALUES (123,4600 Forbes Ave, Pittsburgh, PA 15154,NextDay,to_date(05/8/2006,dd/mm/yyyy),123123.com);INSERT INTO Shipment VALUES (12435678,5/13/2006,5/20/2006);INSERT INTO Shipment VALUES (65213256,5/16/2006,5/30/2006);INSERT INTO Shipment VALUES (51235422,5/30/2006,6/20/2006);INSERT INTO OrderDetail VALUES (78.00,10,10.00,2.00,4-61611-451-6,120,12435678);INSERT INTO OrderDetail VALUES (59.00,20,20.00,4.00,1-45964-123-9,121,65213256);INSERT INTO OrderDetail VALUES (62.00,50,20.00,5.00,6-45457-452-9,122,51235422);jsp:index.jspOnlineBooks Search by: Author Title        search.jspCTE.Library: Search Results Search Results: % String search = request.getParameter(search); String searchby = request.getParameter(action); int start = Integer.parseInt(request.getParameter(start); out.println(for + searchby + includes + search + ); % % if (results.getBookTitleCount() = 0) out.println(Sorry! Nobookswere found!); else if (results.getBookTitleCount() = 1) out.println(results.getBookTitleCount()+ book found); else out.println(results.getBookTitleCount()+ books found); % % for( inti=start; i(start+10)&(i ahref=bookdetails.jsp?ISBN= Author: Price: OtherInfo: 0) Stringencurl=response.encodeRedirectURL(search.jsp?start= + (start - 10) + &searchby= + searchby + &search= + search); % a href=<< Previous10 << Previous 10 % / Do we need to show a Next 10 link? if (start + 10 10) num = 10; String encurl = response.encodeRedirectURL(search.jsp?start= + (start + 10) + &searchby= + searchby + &search= + search); % a href=Next >> Next 10 >> bookdetails.jspBook DetailsBook Details           viewCart.jspView Cart Cart Please review these books and their quantities.When you are happy with youorder,clickCheckout. ISBN TITLE QTYUNIT PRICE AMOUT % StoreBookTitle storeBookTitle = (StoreBookTitle)session.getAttribute(storeBookTitle); String isbns = commerceBasket.getBooks(); String outputptr = ; int totalPrice = 0; out.println(); int numBooks = commerceBasket.getnumBooks(); for ( int i= 0; i commerceBasket.getnumBooks(); i+ ) outputptr += ; outputptr += + isbnsi + + + (storeBookTitle.getTitleThroughIsbn(isbnsi) + + + + (storeBookTitle.getPriceThroughIsbn(isbnsi)+ + +(storeBookTitle.getPriceThroughIsbn(isbnsi)