ONLINE BANKING SYSTEM

The ojective of this project is to maintain the accounts like saving account, withdrawing, depositing money and applying loan to the user. Bank provides account number to the customer for dealing transaction into the bank. At first a user register himself/herself as customer. After that account can be opened. A customer can open more than one account.This is a console based application which gives access to do all kind of banking operations. JDBC has been used to develop this system which includes JDBC Driver, Connections, DAO implementations and exception handling. MySQL has been used for database.

Er Diagram

Modules

• Login & Logout Module
• Account Module
• Customer Module
• Transaction Module

Features:

Accountant Features

• Login using his/her username and password.
• Adding new Account for Customer.
• Editing already available Account.
• Removing account by using Account number.
• Viewing particular account by giving Account number.
• Viewing all the account details.
• Taking care of deposite and withdrawal opreation.

Customer Features

• Login using his/her username and password.
• Transfer the money from his account to other account.
• Checking the transaction history.

Setup for Running the Project

1. Open project ONLINE BANKING SYSTEM.
2. Open src/com/obs and then mainwork folder.
3. Create Database,tables into local system from SQL_TABLES.txt.
4. Download .jar file according to your MySQL version from https://mvnrepository.com/artifact/mysql/mysql-connector-java.
5. Run java file 'Main.java'.

Tech Stack and Tools

• Core Java
• JDBC
• SQL