e-Commerce Applications Using Oracle8i and Java From Scratch

Description

In Building e-Commerce Database Applications Using Oracle8i and Java from scratch, Meghraj Thakkar takes novice web programmers through the process of creating a web-enabled database application. You will look at the requirements, analysis, design, implementation, testing and deployment of an "Online Coffee Shop" from scratch. You will also learn to create database objects (tables and indexes), populate the database, and use SQL, PL/SQL and Java to manipulate the data. Additional topics include using Oracle tools such as SQL*Loader and Export/Import to populate Oracle databases, use of JDBC to connect and interact with the database, how to process the results coming back from the database, use of SQLJ to write efficient Java code, JDBC error messages & exceptional handling in the project, how to store Java code in the database using Java Stored Procedures, techniques for debugging & stress testing your applications, and more.

Downloads

Source Code

Source Code

The source code from the book. - 324KB -- setup.exe

Sample Content

Table of Contents

Introduction.


Introduction to the Internet Capabilities of Oracle8i.


Creating and Populating the JavaStop Database.


Manipulating the JavaStop Oracle Database Using SQL.


Java Basics for Developing JavaStop.


Using JDBC to Connect to JavaStop.


Using JDBC to Perform Data Manipulation in JavaStop.


Implementing Clean and Compact Code Using SQLJ.


Handling Exceptions in JavaStop.


Writing Java Stored Procedures for JavaStop.


Diagnosing Problems and Debugging JavaStop Code.


Securing JavaStop Using Database Security and Firewalls.


Improving the Scalability of JavaStop.


Optimizing JavaStop Performance.


Testing JavaStop to Improve Quality.


Enhancing JavaStop Using EJBs and CORBA.


A JDBC API Reference.


B Oracle8i Commonly Used SQL Statements and Data Dictionary Views.


Index.

Updates

Submit Errata