Project-Java-Banking-App

Description:

This application simulates an instance where a customer registers for an account with a bank. The following details below describes how I set up the Oracle database to the java banking application :

Created SQL scripts that creates users in Oracle database and table schemas for storing your bank users' account information.

Implemented Hash Code method in my JavaBeans API to generate account ID for users in my account table in Oracle.

This database includes at least 1 or more stored procedures for efficiency in time and space complexity.

This bank application connects to the SQL database using JDBC and stores all information that way.

I chose to use the Data Access Object(DAO) design pattern in java application for data connectivity.

How it works for customers :

• Customers of the bank are able to register with a username and password, and apply to open an account.

• Customers are able to apply for joint accounts.

• Once the account is open, customers are able to withdraw, deposit, and transfer funds between accounts (Savings account).

• All basic validation is checked thoroughly, such as trying to input negative amounts, overdrawing from accounts etc.

How it works for employees :

• Employees of the bank should be able to view all of their customers information.

• This includes, account information, Account balances, and Personal information.

• Employees should be able to approve/deny open applications for accounts.

How it works for Bank admins :

• Should be able to view and edit all accounts.

• Approving/denying accounts.

• Withdrawing, depositing, transferring from all accounts.

• Canceling/deleting accounts.

• JUnit testing is expected.

• Log each session (Log4J) so ALL transactions are logged.

Error handling if user enters incorrect option :

Customer registers for a new checking account and is pending active :

Administrator approves the customer's checking account :

Customer now has access to their account and decides to add Savings account :

(Savings account is automatically approved because their checking account is verified)

Customer deposits money into their Checking account :

Customer decides to transfer funds from their Checking account to their Savings account :

Admin cancels the user's account :

(Use-case scenario for fraudulent activity, inactivity, long-period of insufficient funds, or customer decides to cancel their account)