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.
• 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.
• 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.
• 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.
(Savings account is automatically approved because their checking account is verified)
(Use-case scenario for fraudulent activity, inactivity, long-period of insufficient funds, or customer decides to cancel their account)