My Fancy Bank

---

Description

BU CS611 Course Project.

Project Developers: Yuqiu Lin and Xiongxin Zeng.

---

---

Bank Management System Introduction

• User(Both customer and banker) are identified by email address & user type, which means one email can only register once(You can use the same email to register as one customer and one banker, but you can't register as 2 different customers)
• One customer can only have one saving account,one checking account,one loan account and one stock account.
• The bank will pay interest to certain saving accounts every day.
• All types of account can have 3 currencies, but only checking account can exchange.
• About creating account:
  • customer need to pay $10.
  • Loan Account & Security Account can only be paid from Saving account, which means if customer want to create those accounts, they must have a saving account.
  • Checking account & Saving account can be paid from the other account or cash(deposit).
• About closing account:
  • customer need to pay $10.
  • Loan Account can be closed when there is no loan and saving account have enough USD to pay the fee.
  • Security Account can be closed when there is no stock position, and the balance of all currencies should all be 0. And saving account have enough USD to pay the fee.
  • Saving account can be closed when there is no loan account and security account, but there must be a checking account, and the balance should be all 0. And checking account have enough USD to pay the fee.
  • Checking account can close if the balance of all currencies is 0 and saving account have enough USD to pay the fee. If the customer only have this one account and the money in this account can pay the fee(any currencies), then pay the fee and give the balance to the customer and close the account.
• Customer can upload certificate of collateral to ask banker to valuate. And take loan using the valuated collateral.
• Loan account can only be repaid by saving account. And the money customer get after take loan will transfer to saving account automatically.
• Security account can only transfer in from and transfer out to saving account. But transfer in operation need to over 1000USD(or the equivalent in other currencies) & the saving account should have at least 5000USD before transfer and have at least 2500USD remaining after transfer.

Implementation

1. add mysql-connector-java-8.0.20.jar to dependencies
2. open mysql.Run following command.

   create database mybank;
   use mybank;
   source /filePath/mybank.sql;
   

3. configure username and password to your mysql username and password in jdbc.properties file:

   driverClass=com.mysql.cj.jdbc.Driver
   url=jdbc\:mysql\://localhost\:3306/mybank
   username=root
   password=
   

4. run Main in IDE or run following commands in terminal:

   javac *.java
   java -cp .;complete-path-to-drive/mysql-connector-java-8.0.20.jar Main
   

Due to the complexity of configuring driver for mysql and the version of jdk required for compilation, we recommand that you run the code with jdk version >=15 in IDE like intelliJ IDEA and configure modules for mysql-connector-java-8.0.20.jar in project setting.

Divide Up

• Yuqiu: Customer part
• Xiongxin: Banker part

Classes of the project

• Main: Main class. Then entrance of the program.
  
  

• CustomerDao: Customer DAO. Get Data from customer table.

• AccountDao: Account DAO. Get Data from account table.

• StockDao: Stock DAO. Get Data from stock table.

• CollateralDao: Collateral DAO. Get Data from collateral & collateralValuation table.

• LoanDao: Collateral DAO. Get Data from Loan table.

• TransactionDao: : Collateral DAO. Get Data from Transaction table.

• BankerDao: : Banker DAO. Get Data from banker table.

• InterestUpdate: InterestUpdate class. Update data. Pay interest to saving account and add interest to loan account.
  
  

• User: User class. Generate an unique id.

• Customer extends User: Customer class.

• Banker extends User: Banker class.
  
  

• Account: Account class. Have 3 currencies.

  • CheckingAccount extends Account implements CanDeposit, CanWithdraw, CanExchange, CanTransferWithin, CanTransferToOthers: Checking account. Can do almost everything, but need to pay transaction fee.
  • SavingAccount extends Account implements CanDeposit, CanTransferWithin: Saving account. Can transfer to checking account, can deposit. Can get interest if the balance is large.
  • LoanAccount extends Account: Loan account. Can take loan, upload collateral request and repay the loan.
  • SecurityAccount extends Account: Security account. can buy or sell stock
    
    

• CanDeposit: CanDeposit interface. Account that can deposit

• CanExchange: CanExchange interface. Account that can exchange

• CanTransferToOthers: CanTransferToOthers interface. Account that can transfer to other customer's account

• CanTransferWithin: CanTransferWithin interface. Account that can transfer to other account of this customer

• CanWithdraw: CanWithdraw interface. Account that can withdraw
  
  

• Transaction: Transaction interface. Can execute

  • AbstractTransaction implement Transaction: Abstract Normal Transaction class. Transaction between account. Has from account and to account
    • Withdraw extends AbstractTransaction: Withdraw transaction. For CanWithdraw account.
    • Deposit extends AbstractTransaction: Deposit transaction.For CanDeposit account.
    • Exchange extends AbstractTransaction: Exchange transaction.For CanExchange account.
    • TakeLoan extends AbstractTransaction: TakeLoan transaction. For Loan account.
    • PayInterest extends AbstractTransaction: Pay Interest transaction. The bank will pay interest to saving account every day automatically
    • Transfer extends AbstractTransaction: Transfer transaction. For CaTransfer account.
      • TransferIn extends Transfer: Transfer In transaction. For Security account
      • TransferOut extends Transfer: Transfer Out transaction. For Security account
  • StockTransaction implements Transaction: Stock Transaction. For stock trade.
    • BuyStock extends StockTransaction: Buy Stock Transaction.
    • SellStock extends StockTransaction: Sell Stock Transaction.
  • order extends Transaction: order interface. Transaction that need manager to solve
    • CollateralValuation implements order: CollateralValuation. upload certificate and ask manager to valuate, using apply() method. Manager will solve the request, using setPrice(double) setApprove() setReject() method
      
      

• ValCounter: ValCounter interface. Strategy Pattern, strategy interface

• Valuable: Valuable interface. Object that has value.

• ValuePool extends HashMap<String, T>: An hashmap that store valuable object. Context class in Strategy pattern. Can execute Strategy impl class. In our code the concrete class is anymous class
  
  

• Loan implements Valuable: Loan class. store balance and collateral.

• Collateral implements Valuable: Collateral class, store collateral value.

• StockInfo: StockInfo class, store stock name, current price and currency type.

  • CustomerStock extends StockInfo implements Valuable: stock that customer has. store in security account's stockPool.
  • StockProfit extends StockInfo implements Valuable: stock profit. store realized profit of one stock
    
    

• ConfigUtil: ConfigUtil class. Get all properties from config.properties file.

• JDBCUtil: JDBCUtil class. Get mysql properties from jdbc.properties file and connect to mysql.

• QueryUtil: QueryUtil class. Help concat string for mysql query.

• GuiUtil: GuiUtil class, help find the frame of one component.
  
  

• MyFrame extends JFrame: MyFrame class, set window position.

  • CoreFrame extends MyFrame: Core Frame class. The main frame.
    • CustomerFrame extends CoreFrame: The frame that shown after customer login
    • BankerFrame extends CoreFrame: The frame that shown after banker login
    • LoginFrame extends CoreFrame: The login frame for both customer and banker
    • RegisterFrame extends CoreFrame: The register frame for customer
  • PopupFrame extends MyFrame: Popup Frame class.
    • AddStockFrame extends PopupFrame: Add new Stock frame by banker with stock name, three currency choices and price.
    • BuyStockFrame extends PopupFrame: Buy Stock frame. Can choose 10, 20,50,100 percent.
    • SellStockFrame extends PopupFrame: Sell stock frame.Can choose 10, 20,50,100 percent.
    • SetStockPriceFrame extends PopupFrame: Frame where a banker set a new price for selected stockName.
    • StockTransactionHistoryFrame extends PopupFrame: Frame where all the logs for stock transactions show up.
    • TransactionHistoryFrame extends PopupFrame: Frame where all the logs for monetary transactions show up.
    • CreateAccountFrame extends PopupFrame: Create account frame. Can choose pay the fee from another account or cash
    • DepositFrame extends PopupFrame: Deposit frame.
    • WithdrawFrame extends PopupFrame: Withdraw frame
    • ExchangeFrame extends PopupFrame: Exchange frame
    • DepositTempFrame extends PopupFrame: Deposit temp frame. Only for the deposit when creating account.
    • RepaymentFrame extends PopupFrame: Repayment frame
    • TakeLoanFrame extends PopupFrame: Take Loan frame. Can choose collateral and currency.
    • TransferFrame extends PopupFrame: Transfer frame. can transfer to other account or another customer.
    • TransferInFrame extends PopupFrame: Transfer In frame. only for security account. transfer in from saving account
    • TransferOutFrame extends PopupFrame: Transfer Out frame. only for security account. transfer out to saving account
    • UploadCollateralFrame extends PopupFrame: upload collateral frame. request collateral valuation and upload corresponding certificate
    • CollateralValuationFrame extends PopupFrame: set-price-for-collateral frame. Banker evaluates each unresolved collateral (either reject or approve) and gives it a value based on which customer can take a loan.
    • RegisterPopUpFrame extends PopupFrame: Frame for registering a new banker account.
    • MessageFrame extends PopupFrame: Message frame. Show message after operation. success or fail.
      
      

• CustomerContentPanel extends JPanel: CustomerContentPanel class. main panel of customer frame, which will change based on the operation.

  • CollateralPanel extends CustomerContentPanel: List Collateral info of the customer
  • CollateralRequestPanel extends CustomerContentPanel: List Collateral request info of the customer, including request status.
  • CustomerHomepagePanel extends CustomerContentPanel: HomePage panel. Show basic info of 4 accounts.
  • TransactionHistoryPanel extends CustomerContentPanel: Transaction history panel. List history transactions of one customer.
  • LoanPanel extends CustomerContentPanel: Loan info Table, show customer's loan info in the table
  • StockListPanel extends CustomerContentPanel: Available stock info Table, show stocks that be traded
  • TablePanel extends CustomerContentPanel: Abstract class. Show info in a table. Has a Currency Filter.
    • StockPositionPanel extends TablePanel: Stock position info Table, show customer's current positions.
    • StockProfitPanel extends TablePanel: Stock profit info Table, show realized profit of the customer from each stock.

• BankerContentPanel extends JPanel: The main panel for banker frames, which will change based on the operation. It shows all the details for manage accounts by default.

  • CustomerListPanel extends BankerContentPanel: Panel for showing all the customers information. Double clicking on specific customers for more details.
  • CollateralEvalsPanel extends BankerContentPanel: Panel for showing all the unresolved collateral requests so far.
  • StockEvalsPanel extends BankerContentPanel: Panel for showing all the stocks on the market with an "Add" button for importing new stocks from the banker.

• DailyReportPanel extends JPanel: The panel for showing the total number of monetary and stock transactions of each type.

• MyMenuButton extends JToggleButton: MyMenuButton class. Implemented a toggle menu button.

• TableSetting: set table design, the color of table.

• TableColumn: store the column name of different table.

Design Pattern & Benefits

1. Singleton : JDBCUtil is a singleton. There is only one Connection, and this connection is open once the program starts and will close if the program ends.

   • Benefit:
     • make sure there is only one connection and easy to control.
     • easy to access database and make sure the connection last until the program ends.

2. Data Access Object (DAO) Pattern: 6 xxxDao class are Dao impl classes.

   • Benefit:
     • separate low level data accessing API or operations from high level business services.

3. Strategy Pattern: ValCounter interface is the Strategy Interface. ValPool<T> class is the Context Class. The concrete classes are anonymous classes.

   • Benefit:
     • sum up the target value of the objects in the HashMap based on the Strategy concrete class.
     • easy to sum up different attributes. easy to extend.

4. MVC Pattern: Controller layer executes and returns the message to view layer to update the frame info.

   • Benefit:
     • loose coupling.
     • convenient to teamwork
     • high scalability and re-usability, easy to maintain

Object, Object Model and GUI Relationship

For the whole part of design, we combine DAO and MVC pattern. Anything that plays with data in each table of database goes into xxxDAO classes, anything dealt with the object functions and attributes we either abstract or implement with all kinds of half-controller classes, and anything regarding GUI design, we cover them in all kinds of Frame and Panel classes and for each of them we include some ActionListeners for synchronizing singleton database with all kinds of views.

Highlights:

• Good Looking and well formatted GUI
• Local persistence with mysql and supporting weak transaction reads and writes
• Loose coupling of backend data and frontend object&control design

Demo

Init Page

Login Page

Register Page

Customer

CustomerHomePage Page

Account Page Overview

Loan Account

Upload collateral valuation request

loan list

collateral Request list

collateral list

Security Account

customer stock position

stock list

stock realized profit list

buy stock

Transaction History Page

StockTrading History Page

Manager

Homepage/DailyReport

UserList

view customer's account info

CollateralRequest

manager collateral valuation

stock management