Oracle9i XML DB Card Payment Gateway Application

Dependencies

Oracle 9i Database Version 9.2 or higher - The XML DB features are available only from Oracle 9i Database Version 9.2 and higher.

Installation and Configuration

Refer to Install.html file present in the sample jar for step-by-step instructions on extracting files, installing and configuring any other systems to successfully run this application.

Description of Sample Files

Java Server Pages

JSPs handle the user interaction and generate the user interface for the user. Following is the list of JSPs that handle the client interaction. These files can be found under the "public_html" directory of the sample JAR file.

File Name	Purpose
Main.jsp	This page is the main page of the application.
Header.jsp	This page forms the Header for all the JSP pages and is included in the other pages as a static include.
Footer.jsp	This page forms the Footer for all the JSP pages and is included in the other pages as a static include.
Login.jsp	This page is used to submit the request for login and it redirects to the appropriate page after validating the login parameters.
MainError.jsp	This error page is used to display any run time exceptions that happen in the Main page or while logging into the system.
CustomerMain.jsp	This page is the main page for the customer login. The Login.jsp page redirects to this page whenever a Customer successfully logs into the application.
ViewAccounts.jsp	This page lists the accounts held by the customer for selection.
AccountDetails.jsp	This page displays the details of the Account selected by the customer in the ViewAccounts page.
TransactionDetais.jsp	This page displays the transaction details on the Account selected by the Customer in the ViewAccounts page.
UpdateProfile.jsp	This page displays the existing details of the Customer which can be updated to new values.
UpdateProfileSub.jsp	This page is used to submit the changes made by the Customer in the UpdateProfile page.
CustomerError.jsp	This page is displayed for any run time exceptions that occur for the Customer pages above.
AddCustomer.jsp	This page displays the form for entering the details of a new Customer.
AddCustomerSub.jsp	This page is used to submit the details entered by the Administrator for creating a new Customer.
AddAccount.jsp	This page displays the form for entering the details of a new Customer Account.
AddAccountSub.jsp	This page is used to submit the details entered by the Administrator for creating a new Customer Account.
UpdateCustomer.jsp	This page displays the details of the existing Customer for updation.
UpdateCustomerSub.jsp	This page is used to submit the updated details of the Customer entered by the Administrator.
UpdateAccount.jsp	This page displays the details of an existing Customer Account for updation.
UpdateAccountSub.jsp	This page is used to submit the updated details of the Customer Account entered by the Administrator.
AccountSearch.jsp	This displays a search form for entering a criteria to search the existing Accounts.
AccountSearchSub.jsp	This page is used to submit the search criteria entered for searching the Accounts.
CustomerSearch.jsp	This displays a search form for entering a criteria to search the existing Customers.
CustomerSearchSub.jsp	This page is used to submit the search criteria entered for searching the Customers.
AdminError.jsp	This page is displayed for any run time exceptions that occur for the Admin pages above.
PaymentRequest.jsp	This page allows merchants to submit purchase requests for processing.
PaymentRequestSub.jsp	This page is used to submit the details entered by the Merchant for processing the puchase.

Java classes

The following table lists the Java classes used in this sample containing all the business logic required for the sample. These files can be found under the "src" directory of the sample JAR file.

File	Purpose
Login.java	This class contains all the logic for processing the JSP requests for the login and logout functions of the sample. This class uses the DataAccessBean class to perform all the database operations.
Admin.java	This class implements the business logic for all the operations that can be performed by an Admin user. This class uses the DataAccessBean class to perform all the database operations.
Customer.java	This class implements the business logic for all the operations that can be performed by a Customer ( cardholder or a merchant). This class uses the DataAccessBean class to perform all the database operations.
DataAccessBean.java	This class implements the logic for all the database operations that can be performed in the application. All the other Javabeans will use this class to perform the database related operations.
PaymentGatewayClient.java	This class is the client that will be used to access the Payment Gateway Web Service when a purchase details are submitted for processing by a Merchant through the PaymentRequest.jsp. This acts as the client for accessing the Web Service.

The following table lists the Java classes which implement the Web Service. These files can be found under the "CPGAWS\src" directory of the sample JAR file.

File	Purpose
PaymentGateway.java	The Java interface defined for the RPC style Web Service. This will have the methods using which the purchase details made by a cardholder can be submitted and validated against the card holder's account.
PaymentGatewayImpl.java	This class provides the implementation for the PaymentGateway.java interface.

SQL files

The SQL file and the PL/SQL files contained in the "sql" directory provides the creation script for creation the database objects required for the sample.

File	Purpose
CPGACreation.sql	This SQL file is used for creation of the CPGA user and the objects required for running of the sample. This script also inserts sample data into the tables, loads XSL files used by the sample and creates the PL/SQL packages used by the sample.

Go back to Readme.html

Please enter your comments about this sample in the OTN Sample Code Discussion Forum.

E-mail this page

Printer View