实验报告实验名称: E-commerce指导老师:组员:班级:日期: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.设计流程：⑴用户搜索书目，并将其放入篮子中。
⑵用户登陆，如果没有注册，则注册⑶填写邮寄地址并付款。
3.代码.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','LearnDatabaseSystems','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','ManagementScience','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','1 23@','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'),'123@'); INSERT INTO orders VALUES (121,'4613 Dalwen Ave, New York, PA 15264','general',to_date('05/1/2006','dd/mm/yyyy'),'123@'); INSERT INTO orders VALUES (122,'4600 Forbes Ave, Pittsburgh, PA 15154','NextDay',to_date('05/11/2006','dd/mm/yyyy'),'123@'); INSERT INTO orders VALUES (123,'4600 Forbes Ave, Pittsburgh, PA 15154','NextDay',to_date('05/8/2006','dd/mm/yyyy'),'123@');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.jsp<%@ page language="java" import="commerce.*" errorPage="error.jsp" %> <jsp:useBean id="tags" scope="page" class="monTags" /><html><head><title>OnlineBooks</title><link href="styles.css" rel="stylesheet" type="text/css"></head><body><%=tags.getHeader("Search")%><form name="form1" method="post" action="servlet/SearchController"> Search by:</strong><input name="action" type="radio" value="Author" checked><span class="style16">Author<input name="action" type="radio" value="Title">Title </span> <span class="style20"> <input name="search" type="text" class="style12" value=""><input name="submit" type="submit" class="style14" value="OK"></span></form><%=tags.getFooter()%></body></html>search.jsp<!-- Interface for displaying search results. --><%@ page language="java" import="commerce.*, java.sql.*, java.io.*, java.util.*, .*" %><jsp:useBeanid="results" scope="session" class="commerce.BookTitleSet" /><jsp:useBean id="title" scope="session" class="commerce.BookTitle" /> <!-- Page scoped bean for a common header and footer. --><jsp:useBean id="tags" scope="page" class="monTags" /><!DOCTYPE html PUBLIC "-//W3C//DTD html 4.0 transitional//EN"><html><head><link href="styles.css" rel="stylesheet" type="text/css"><title>CTE.Library: Search Results</title></head><body><%=tags.getHeader("")%><div style="width: 600"><p> <b>Search Results:</b><%String search = request.getParameter("search");String searchby = request.getParameter("action");int start = Integer.parseInt(request.getParameter("start")); out.println("<i>for " + searchby + " includes '" + search + "'</i>");%><br><%if (results.getBookTitleCount() == 0) {out.println("<p><blockquote><b>Sorry! Nobookswere found!</b></blockquote>");} else {if (results.getBookTitleCount() == 1) {out.println(results.getBookTitleCount()+" book found"); } else {out.println(results.getBookTitleCount()+" books found"); }%></p><!-- Display the search results one book at a time. --><div style="margin-left: 2em"><dl><dd><p><%for( inti=start; i<(start+10)&&(i < results.getBookTitleCount()); i++) {BookTitle result = results.getBookTitleAt(i);String escaped = URLEncoder.encode(result.getISBN(), "UTF-8"); %></p></dd><dt><b><ahref="bookdetails.jsp?ISBN=<%=escaped%>"><%=result.getTitle()%></a> </b><br></dt><!-- Display the information about a book. --><dd> <b class="smaller">Author:</b> <%=result.getAuthor()%><br><b class="smaller">Price:</b> <%=result.getPrice()%><br><b class="smaller">OtherInfo:</b> <%=result.getBookDescription()%><br><b class="smaller"></b> <%=result.getCategories()%><br><hr size="1" noshade><% } %></dd></dl><%// Do we need to show a 'Previous 10' link?if (start > 0) {Stringencurl=response.encodeRedirectURL("search.jsp?start=" + (start - 10) + "&searchby=" + searchby+ "&search=" + search);%><a href="<%=encurl%>"><< Previous10</a><% } else { %><font color="gray"><< Previous 10 </font><%}// Do we need to show a 'Next 10' link?if (start + 10 < results.getBookTitleCount()) {int num = results.getBookTitleCount() - (start + 10);if (num > 10) {num = 10;}String encurl = response.encodeRedirectURL("search.jsp?start="+ (start + 10) + "&searchby=" + searchby + "&search=" + search);%><a href="<%=encurl%>">Next <%=num%> >></a><% } else { %><font color="gray">Next 10 >></font><%}}%></div></div><!-- Display the copyright information from the custom JSP tags. --> <%=tags.getFooter()%></body></html>bookdetails.jsp<%@ page language="java" import="commerce.*, java.sql.*, java.io.*, java.util.*, .*" %><jsp:useBean id="title" scope="page" class="commerce.BookTitle" /><jsp:useBean id="tags" scope="page" class="monTags" /><jsp:useBean id="storeBookTitle" scope="session"class="commerce.StoreBookTitle" /><jsp:useBean id="commerceBasket" scope="session"class="merceBasket"/><html><head><title>Book Details</title><link href="styles.css" rel="stylesheet" type="text/css"></head><body><%=tags.getHeader("")%><p class="STYLE1">Book Details</p><form name="bookDetail" method="post"action="servlet/AddBasketController"><%String ISBN = request.getParameter("ISBN");if (ISBN != null){storeBookTitle.setNowAccessBookISBN(ISBN);}%><table width="400" border="0" cellspacing="0" cellpadding="0"><tr><th width="133" scope="col"><p> </p><p><img src="images/book.bmp"></p><p> </p><p> </p></th><th width="267" scope="col"> <font size=24><table width="400" border="0" align="left" cellpadding="0" cellspacing="0"><tr><th scope="col"> <div align="left" class="STYLE2"><%out.println(storeBookTitle.getTitleThroughIsbn(ISBN));%></div></th></tr><tr><td><div align="left" class="STYLE2"><%out.println(storeBookTitle.getAuthorThroughIsbn(ISBN));%></div></td></tr><tr><td><div align="left" class="STYLE2"><%out.println("Readinglevel:"+storeBookTitle.getBookDescriptionThroughIsbn(ISBN));%></div></td></tr><tr><td><div align="left" class="STYLE2"><%out.println(storeBookTitle.getCategoriesThroughIsbn(ISBN));%></div></td></tr><tr><td><div align="left" class="STYLE2"><%out.println("ListPrice:"+storeBookTitle.getPriceThroughIsbn(ISBN));%></div></td></tr></table></font></th></tr><tr><td height="47"><p> </p><p> </p></td><td><label><input type="submit" name="Submit" value="Add to Cart" ></label></td></tr></table></td></tr></table></form><%=tags.getFooter()%></body></html>viewCart.jsp<%@ page language="java" import="commerce.*" errorPage="error.jsp" %> <jsp:useBean id="tags" scope="page" class="monTags" /><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>View Cart</title><link href="styles.css" rel="stylesheet" type="text/css"></head><body><br><br><%=tags.getHeader("ViewCart")%> <br><br><br><strong>Cart</strong> <br><PRE><%CommerceBasket commerceBasket =(CommerceBasket)session.getAttribute("commerceBasket");out.println ( "Number of books in your cart " + commerceBasket.getnumBooks());%>Please review these books and their quantities.When you are happy with youorder,click"Checkout".</PRE><table align="center"><tr bgcolor="#FFFFCC"><th><span class="style20">ISBN</span></th><th class="style20">TITLE</th><th><span class="style20">QTY</span></th><th><span class="style20">UNIT PRICE</span></th><th colspan = “2” align = “left”><span class="style20">AMOUT</span></th><th><span class="style20"></span></th></tr><% StoreBookTitle storeBookTitle =(StoreBookTitle)session.getAttribute("storeBookTitle");String[] isbns = commerceBasket.getBooks();String outputptr = "";int totalPrice = 0;out.println("<form action=\"servlet/RemoveBasketController\" method=\"post\">");int numBooks = commerceBasket.getnumBooks();for ( int i= 0; i < commerceBasket.getnumBooks(); i++ ){outputptr += "<tr bgcolor=\"#999966\">";outputptr += "<td>" + isbns[i] + "</td>"+ "<td>" + (storeBookTitle.getTitleThroughIsbn(isbns[i])) + "</td>"+ "<td align=\"center\"> <input border=\"2\" type=\"text\" name=\"quantity\" "+"value=\" "+ (commerceBasket.getQuantity(isbns[i]))+"\" maxlength=\" 3\" size=\"3\" readonly=\"readonly\"></td>"+ "<td align=\"center\">" + (storeBookTitle.getPriceThroughIsbn(isbns[i]))+"</td>"+"<td>"+(storeBookTitle.getPriceThroughIsbn(isbns[i]))+"</td>"+ "<td><input name=\"remove\" value=\"Remove\"type=\"submit\"></td>"+ "/<tr>";//out.println(outputptr);totalPrice += (commerceBasket.getQuantity(isbns[i])) * (storeBookTitle.getPriceThroughIsbn(isbns[i]));}// out.println("</form>");outputptr += "</form>";//outputptr = "";outputptr += "<form action=\"servlet/AddBasketController\" method=\"post\">"+ "<tr bgcolor=\"#999966\"><td colspan=\"3\"></td><td align=\"center\"><strong>SUB-TOTAL:</strong></td>"+ "<td>" + totalPrice + "</td>"+ "<td><input type=\"submit\" name=\"update\" value=\"Update\"> </td>"+ "</form>";out.println(outputptr);%></tr><tr bgcolor="#FFFFCC"><td colspan="6"><BR></td></tr><form action="login.jsp"><tr bgcolor="#FFFFCC"><td colspan="5"></td><td><input type="submit" name="checkout" value="CheckOut"></td> </tr></form><br></form></table><%=tags.getFooter()%></body></html>login.jsp<%@ page language="java" import="commerce.*" errorPage="error.jsp" %> <jsp:useBean id="tags" scope="page" class="monTags" /><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>customer logint</title><link href="styles.css" rel="stylesheet" type="text/css"></head><body><br><br><%=tags.getHeader("Checkout")%> <br><strong>Step 1:</strong><span class="STYLE1">Login</span> <span class="style21">2: Shipping Infomation 3: Billing Information 4: Confirmation </span><br><form name="form1" method="post" action="servlet/CustomerLoginController"><table><tr bgcolor="#666666"><td><span class="style22">LOGIN</span></td></tr><tr bgcolor="#CCCC99"><td class="style20"><strong>E-mail</strong></td></tr><tr><td><input name="e-mail" type="text" id="e-mail" value=""></td> </tr><tr bgcolor="#CCCC99"><td><span class="style15">Password</span></td></tr><tr><td><input name="passwd" type="password" id="passwd"></td></tr><tr bgcolor="#FFFFCC"><td align="center"><input type="submit" name="login" value="Login"></td></tr></table></form><%=tags.getFooter()%></body></html>login_ok.jsp<%@ page language="java" import="commerce.*" errorPage="error.jsp" %> <jsp:useBean id="tags" scope="page" class="monTags" /><jsp:useBean id="loginSuccess" scope = "session" class ="commerce.Customer" /><html><head><title>Customer login Success</title><link href="styles.css" rel="stylesheet" type="text/css"></head><body><%=tags.getHeader("view cart")%><%Customer customer = new Customer();customer = (Customer)session.getAttribute("customer");out.println(customer.getNameThroughEmail(customer.getEmail(),cust omer.getPassword()));%>welcome to your Online Books account center.<p align="left" class="STYLE1">choose any of the options below to change your account information or to view your order information.</p><ul class="STYLE1"><li><a href="shipping-info.jsp">Update Account Profile</a></li></ul><pclass="STYLE1"> update your address ,email, and your password </p><ul class="STYLE1"><li><a href="ordered.jsp">View Status of Orders </a></li></ul><p class="STYLE1"> view past or pending orders </p> <p> </p><p> </p><p></form><%=tags.getFooter()%></p></body></html>Register.jsp<%@ page language="java" import="commerce.*" errorPage="error.jsp" %> <jsp:useBean id="tags" scope="page" class="monTags" /><jsp:useBean id="loginSuccess" scope = "session" class ="commerce.Customer" /><html><head><title>Customer login Success</title><link href="styles.css" rel="stylesheet" type="text/css"></head><body><%=tags.getHeader("view cart")%><%Customer customer = new Customer();customer = (Customer)session.getAttribute("customer");out.println(customer.getNameThroughEmail(customer.getEmail(),cust omer.getPassword()));%>welcome to your Online Books account center.<p align="left" class="STYLE1">choose any of the options below to change your account information or to view your order information.</p><ul class="STYLE1"><li><a href="shipping-info.jsp">Update Account Profile</a></li></ul><pclass="STYLE1"> update your address ,email, and your password </p><ul class="STYLE1"><li><a href="ordered.jsp">View Status of Orders </a></li></ul><p class="STYLE1"> view past or pending orders </p> <p> </p><p> </p><p></form><%=tags.getFooter()%></p></body></html>registration-success.jsp<%@ page language="java" import="commerce.*" errorPage="error.jsp" %> <jsp:useBean id="tags" scope="page" class="monTags" /><html><head><title>Registration Success</title><link href="styles.css" rel="stylesheet" type="text/css"></head><body><%=tags.getHeader("view cart")%><p class="style24">Thank you! </p><p><span class="style17">Your are now registered with Online Books. </span></p><p> </p></form><%=tags.getFooter()%></body></html>ordered.jsp<%@ page language="java" import="commerce.*" errorPage="error.jsp" %> <jsp:useBean id="tags" scope="page" class="monTags" /><jsp:useBean id="loginSuccess" scope = "session" class ="commerce.Customer" /><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>Past Ordered</title><link href="styles.css" rel="stylesheet" type="text/css"></head><body><%=tags.getHeader("")%>PAST ORDERS<table cellpadding="1" bordercolor="#999900" ><tr><td width="250" bgcolor="#CECF9C">ISBN</td><td width="180" bgcolor="#CECF9C">Qty</td><td width="180" bgcolor="#CECF9C">UnitPrice</td><td width="180" bgcolor="#CECF9C">Total</td></tr><%Customer customer = new Customer();customer = (Customer)session.getAttribute("customer");String email=customer.getEmail();StoreOrdered storeOrdered = new StoreOrdered(email);out.println(storeOrdered.size);for (int i =0;i<storeOrdered.size;i++)。
