Skip to content

Latest commit

 

History

History
211 lines (146 loc) · 4.47 KB

README.md

File metadata and controls

211 lines (146 loc) · 4.47 KB
Raw

Online Banking Application

An online banking application built with Java and MySQL, providing functionalities for account management, customer management, and transaction management.

Table of Contents

Features

  • Manage Accounts:
    • View Account
    • View All Accounts
    • Create Account
    • Update Account
    • Delete Account
  • Manage Customers
  • Manage Transactions

Installation

Prerequisites

  • Java 8+
  • MySQL
  • Maven

Steps

  1. Clone the repository
git clone https://github.com/AmruthLP12/com.OnlineBankingApplication.git
cd online-banking-application
  1. Build the project using Maven:
mvn clean install
  1. Run the application:
mvn exec:java -Dexec.mainClass="com.banking.ui.Main"

Database Setup

  1. Create the database schema:
-- Drop existing database
DROP DATABASE IF EXISTS banking;

-- Create database
CREATE DATABASE banking;

-- Use the created database
USE banking;
  1. Create the tables:
-- Table for customers
CREATE TABLE customers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    phone VARCHAR(15) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Table for accounts
CREATE TABLE accounts (
    id INT AUTO_INCREMENT PRIMARY KEY,
    account_number VARCHAR(20) UNIQUE NOT NULL,
    account_type ENUM('SAVINGS', 'CHECKING', 'BUSINESS') NOT NULL,
    balance DOUBLE NOT NULL DEFAULT 0.0,
    customer_id INT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (customer_id) REFERENCES customers(id)
);

-- Table for transactions
CREATE TABLE transactions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    account_id INT NOT NULL,
    amount DOUBLE NOT NULL,
    type ENUM('DEPOSIT', 'WITHDRAWAL', 'TRANSFER') NOT NULL,
    timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (account_id) REFERENCES accounts(id)
);
  1. Populate the tables with initial data (optional):
-- Sample data insertion
INSERT INTO customers (name, email, phone) VALUES
('John Doe', '[email protected]', '123-456-7890'),
('Jane Smith', '[email protected]', '098-765-4321');

INSERT INTO accounts (account_number, account_type, balance, customer_id) VALUES
('ACC1001', 'SAVINGS', 1500.00, 1),
('ACC1002', 'CHECKING', 500.00, 2),
('ACC1003', 'BUSINESS', 2500.00, 1);

INSERT INTO transactions (account_id, amount, type) VALUES
(1, 200.00, 'DEPOSIT'),
(1, -50.00, 'WITHDRAWAL'),
(2, 100.00, 'DEPOSIT'),
(3, 500.00, 'TRANSFER');

Configuration

Configure the database connection in src/main/resources/config.properties:

db.url=jdbc:mysql://localhost:3306/banking
db.username=root
db.password=your_password

Usage

  1. Run the application:
mvn exec:java -Dexec.mainClass="com.banking.ui.Main"
  1. Follow the on-screen prompts to manage accounts, customers, and transactions.

Project Structure

online-banking-application/
│
├── src/
│   ├── com/
│   │   ├── banking/
│   │   │   ├── config/
│   │   │   │   └── DatabaseConfig.java
│   │   │   ├── dao/
│   │   │   │   └── AccountDAO.java
│   │   │   │   └── CustomerDAO.java
│   │   │   │   └── TransactionDAO.java
│   │   │   ├── model/
│   │   │   │   └── Account.java
│   │   │   │   └── Customer.java
│   │   │   │   └── Transaction.java
│   │   │   ├── service/
│   │   │   │   └── AccountService.java
│   │   │   │   └── CustomerService.java
│   │   │   │   └── TransactionService.java
│   │   │   ├── ui/
│   │   │       └── AccountUI.java
│   │   │       └── CustomerUI.java
│   │   │       └── TransactionUI.java
│   │   │       └── Main.java
│   ├── resources/
│   │   └── schema.sql
│
├── pom.xml
├── README.md
└── .gitignore

Contributing

Contributions are always welcome!

See CONTRIBUTING.md for ways to get started.

License

This project is licensed under the MIT License - see the LICENSE.md file for details.