Developing e-Commerce Sites

Vivek Sharma is a software developer at Oracle Corporation with nearly seven years of software development and research experience. He writes for Web magazines such as Java Developers' Journal, and his major area of interest and expertise is Internet application research and development. Rajiv Sharma is the CEO of EDA, Inc., and also works as an independent consultant. He has more than ten years of experience, and is co-author of Java Programming by Example (SIGS publications/Cambridge University Press) with Vivek Sharma. 0201657643AB04062001

Introduction


Rationale



Target Audience



Highlights of the Book



Organization



Acknowledgments

Part I

Chapter 1 The Basics of Internet Technology


Skill Level Required



Web Sites and Browsers



Web Pages and HTML



Web Servers and HTTP



URLs



FORMS and CGI



Javascript



Cookies



Java and Servlets



Databases



JDBC



XML



e-Commerce Systems



Inventory Management Systems



Profile Management Systems



Ordering Management Systems



Shipping Management Systems



Reporting Systems



Getting on the Internet



Using an ISP



Using a Hosting Service



Keeping the Computer with You



A Note about Speed



Disclaimer

Part II

Chapter 2 HTML


Introduction



First HTML File



Some Formatting Tags



Links



Lists



Tables



Frames



Forms



Putting Comments in HTML



Conclusion

Chapter 3 Java


Introduction



Object Oriented Programming



First Java Program



Applets and Applications



Instances



Method Overloading



Inheritance



Interfaces



Packages



Exceptions



File I/O



Threads



Some Useful Classes and Methods



Vectors



Hashtables



Object Serialization



Remote Method Invocation (RMI)



Reading a URL



Working with Proxies



Internationalization



Applets



Threads in Applets



Java Mail API



Commenting Code in Java



Some Useful Tools



Some Practical Examples



Example 1: Displaying Multiple Advertisements on Your Site



Example 2: Keeping Track of Clicks on Advertisements



Conclusion



Some Handy Classes and Methods in Some Useful Packages

Chapter 4 Servlets


= HTML FORMs



= POST and GET METHODs



= Anatomy of a Request and a Response



= CGI Scripts



= Drawbacks of CGI



= Efficiency with Servlets



= Anatomy of a Servlet



= JServ--Servlet Engine



= A Basic Servlet



= FORM Variables



= Cookies



= Sessions



= Some Practical Examples



Example 1: Bulk Email Sender



Example 2: Internationalized Help Screens for Your Worldwide Customers



Example 3: Stocks Reader



= Example: Session-Based Shopping Cart



= Conclusion



= Some Useful Interfaces/Classes and Some of Their Methods

Chapter 5 Javascript


Introduction



Documents



documents.forms



Statements



Examples



Functions



Objects in Javascript



Events and Event Handling



Arrays



FORMs



Select Lists



Buttons



Submit and Radio Buttons



Checkboxes



Text Fields and Text Areas



Frames



Cookies



A Practical Example



Example: Personalized One-to-One Service to Customers



Some Useful Methods, Properties, and Event Handlers of Some Useful Objects



Reference

Chapter 6 SQL and JDBC


Databases and SQL



Schemas



Datatypes



Table Creation



Column Constraints



Keys



Indexes



Dropping Tables



Data Insertion and Modification



Transactions



Data Retrieval



Operators



Functions



Retrieving Records from Multiple Tables



Deleting Records



Sequences



Stored Procedures



JDBC



Connecting to the Database



Drivers



Connection Object



Statement Object



Retrieving Data



Inserting/Modifying Data



PreparedStatement



Insert into a LONG Column



CallableStatement



Transactions in JDBC



Some Practical Examples



Example 1: A Customer Registration System



Example 2: Bulk Email Sender--JDBC Version



Some Useful Classes and Interfaces in the Java.sql Package

Chapter 7 XML


Introduction



Some Rules to Follow



Displaying an XML Document



Data Interchange with an XML Document



Document Type Definitions (DTDs)



Parsers



Using XML



Client-Side Usage



Server-Side Usage



Some Practical Examples



Example 1: Generating XML from the Database



Example 2: Reading XML Data into the Database



Example 3: XML-Based Stock Analyzer



Conclusion



References

PART III

Chapter 8 Credit Card Verification


Card Authorization URLs



Third-Party APIs

Chapter 9 Security and Performance


Security



Firewalls



Database Security



Software Patches



Data Transmission Security



Public and Private Keys



Certificates



Ciphers



Secure Sockets Layer



Message Digests



Password Security



Some Hints on Making the Applications Secure



Performance



Finding and Fixing Bottlenecks



Some Suggestions

PART IV

Chapter 10 System Design


Introduction



Inventory Management System



Things to Think About



Profile Management System



Things to Think About



Ordering Management System



Things to Think About



Other Systems



Conclusion

Chapter 11 Functionality


Introduction



Inventory Management System



Menu



Adding a Category



Adding a Subcategory



Deleting Categories



Adding Products



Modifying Products



Viewing and Deleting Products



Typical Usage Scenario



Ordering System



Sign-In Page



Ordering Menu



Adding Products to Checkout Cart



Cart Contents



Checkout



Checkout for Existing Users



Personal Cart Option



Categories Option



Order History Option



Search Option



Typical Usage Scenario



Profile Management System



Top Menu



Registration



Profile Update



Contact Us Option



Password Finder Option



Shipping Management System



Sign-In Page



Reporting System



Sign-In Page



Reporting Menu



User Distribution



Sales Distribution



User Frequency



Sales Frequency

Chapter 12 Utilities


Introduction



Description of the Utilities



Connection-Pooling Utility



Authenticator



Email-Sending Utility



HTML Template Utility

Chapter 13 Inventory Management System


Prerequisites



High-Level Description



Classes and Their Methods



Detailed Description



HTML Files in Document Root



Other HTML Files and Templates

Chapter 14 Profile Management System


High-Level Description



Classes and Their Methods



Detailed Description



Document Root HTML Files



Other HTML Files and Templates

Chapter 15 Ordering Management System


High-Level Description



Classes and Their Methods



Detailed Description



Document Root HTML Files



Other HTML Files and Templates

PART V

Chapter 16 Shipping Management System


High-Level Description



Classes and Their Methods



Detailed Description



Document Root HTML Files



Other HTML Files and Templates

Chapter 17 Reporting System


High-Level Description



Classes and Their Methods



Detailed Description



Document Root HTML Files



Other HTML Files and Templates

Appendix A Installation and Configuration Instructions


Apache



Installation



Troubleshooting



Configuration



JServ



Installation



Configuration



Oracle



Utilities



mSQL



Troubleshooting



Utilities



JDBC Drivers



Troubleshooting



JavaMail

Appendix B Complete Code Listing
Installation
Inventory Management System
Ordering Management System
Profile Management System
Shipping Management System
Reporting System
Utilities
SQL For Creating Tables and Sequences
Index. 0201657643T04062001