Abstract The business-to-consumer aspect of electronic commerce (e-commerce) is the most visible business use of the World Wide Web. The primary goal of an e-commerce site is to sell goods and services online. This project deals with developing an e-commerce website for Online Book Sale. It provides the user with a catalog of different books available for purchase in the store. In order to facilitate online purchase a shopping cart is provided to the user. The system is implemented using a 3-tier approach, with a backend database, a middle tier of Sun J2EE 1.4 application server and JSP, and a web browser as the front end client. In order to develop an e-commerce website, a number of Technologies must be studied and understood. These include multi-tiered architecture, server and client side scripting techniques, implementation technologies such as JSP, programming language (such as JAVA, JavaScript, and HTML), relational databases (such as MySQL, Access). This is a project with the objective to develop a basic website where a consumer is provided with a shopping cart application and also to know about the technologies used to develop such an application. This document will discuss each of the underlying technologies to create and implement an ebook store.
TABLE OF CONTENTS 1. INTRODUCTION - - - - - - - - 1 2. LITERATURE REVIEW - - - - - - - - 1 3. IMPLEMENTATION TECHNOLOGIES - - - - - 3 3.1. INTRODUCTION TO JSP (J2EE 1.4 ) - - - - - .3 3.2. JSP ARCHITECTURE - - - - - - …..4 3.2.1. ACCESS MODEL - - - - - …….6 3.3. MYSQL DATABASE - - - - - - … - 8 4. WEB PAGE PROGRAMMING OPTIONS - - - - …….10 5. WEB BASED APPLICATION DEVELOPMENT - - - - 11 6. PROJECT DESIGN - - - - - - - …… - 13 6.1. DATA MODEL - - - - - - - ….13 3.1.1 Database Design - - - - - - .19 6.2. PROCESS MODEL - - - - - - ……19 6.2.1. Functional Decomposition Diagram - - - ….21 6.2.2. Data Flow Diagram (DFD) - - - - …….21 6.3. USER INTERFACE DESIGN - - - - - ….31 7. LIMITATIONS AND FUTURE DEVELOPMENT - - - ……..44 8. CONCLUSION - - - - - - - - … - 45 9. BIBLIOGRAPHY - - - - - - - - - 46 List of Figures Figure 3.2.1 Servlet Container - - - - - ……..5 Figure 3.2.2 "jsp servlet" - - - - - - …..6 Figure 3.2.1.1 "access model" - - - - - - .6 Figure 3.2.1.2 Mvc Design Pattern - - - - - … - 7 Figure 4.1 Web Page Programming Option - - - …….10 Figure6.1.1 Entity relationship diagram - - - - - 13 Figure 6.2.1.1 Functional Decomposition Program - - - …20 Figure 6.2.2.1 A Context Level Diagram - - - - … - 21 Figure 6.2.2.2 A First Level Diagram - - - - - .22 Figure 6.2.2.3 A Second Level Diagram - - - - ……23 Figure 6.2.2.4 A Second Level Diagram - - - - ……24 Figure 6.2.2.5 Use Case Diagram - - - - - … - 25 Figure 6.2.2.6 Customer - Browse Context DFD - - - … - 26 Figure 6.2.2.7 Customer - Browse Detailed DFD - - - …..26 Figure 6.2.2.8 Customer " Shopping Cart Context DFD - - ……26 Figure 6.2.2.9 Customer - Shopping Cart Detailed DFD - - … - 27 Figure 6.2.2.10 Customer - Shopping Cart Detailed DFD - - … - 27 Figure 6.2.