ATM System - Java Swing + MySQL

A complete ATM Management System built with Java OOP, Swing GUI, and MySQL database. This is a production-ready desktop application suitable for ATM operations.

✅ User Authentication

• User signup with validation
• Secure PIN-based login
• Email uniqueness validation

✅ Banking Operations

• Deposit money
• Withdraw money (with balance validation)
• Check account balance
• Transaction history (last 10 transactions)

✅ Database Management

• Persistent data storage in MySQL
• Transaction logging
• User account management

✅ UI/UX

• Clean, professional Swing interface
• Designed for laptop screens (900x600)
• Color-coded operations
• Easy navigation between screens

• Language: Java (OOP)
• GUI Framework: Swing
• Database: MySQL
• JDBC Driver: MySQL Connector/J (v8.0+)

ATM-System/
├── src/
│   ├── main/
│   │   └── Main.java
│   ├── ui/
│   │   ├── LoginFrame.java
│   │   ├── SignupFrame.java
│   │   ├── DashboardFrame.java
│   │   ├── DepositFrame.java
│   │   └── WithdrawFrame.java
│   ├── model/
│   │   ├── User.java
│   │   └── Account.java
│   ├── dao/
│   │   ├── DBConnection.java
│   │   ├── UserDAO.java
│   │   ├── AccountDAO.java
│   │   └── TransactionDAO.java
│   └── services/
│       ├── AuthService.java
│       ├── TransactionService.java
│       └── Validator.java
├── sql/
│   └── schema.sql
└── README.md

1. Download and install MySQL from mysql.com
2. Start the MySQL server
3. Ensure MySQL is running on localhost:3306

1. Open MySQL Workbench or MySQL Command Line
2. Run the SQL script to create the database:

mysql -u root -p < schema.sql

Or paste the contents of schema.sql file in MySQL Workbench.

Output:

Database "atm_system" created successfully
Tables created: users, accounts, transactions

1. Download MySQL Connector/J from: https://dev.mysql.com/downloads/connector/j/

2. Or install via Maven:

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.33</version>
</dependency>

Edit dao/DBConnection.java and set your MySQL credentials:

private static final String URL = "jdbc:mysql://localhost:3306/atm_system";
private static final String USER = "root";        // Your MySQL username
private static final String PASSWORD = "root";   // Your MySQL password

Using Command Line:

1. Copy all Java files to a folder
2. Ensure MySQL JDBC driver is in classpath:

javac -cp mysql-connector-java-8.0.33.jar src/**/*.java -d bin/

Using IDE (IntelliJ/Eclipse):

1. Create a new Java project
2. Add project structure (src/main, src/ui, etc.)
3. Add MySQL JDBC JAR to project libraries
4. Build the project

java -cp bin:mysql-connector-java-8.0.33.jar main.Main

Or run directly from IDE by running Main.java

After running schema.sql, you can use this test account:

Email: test@example.com PIN: 1234 Balance: 1000

To add this test account, uncomment the sample data in schema.sql:

INSERT INTO users (name, email, pin) VALUES ('Test User', 'test@example.com', '1234');
INSERT INTO accounts (user_id, balance) VALUES (1, 1000.00);

1. Enter your email and PIN
2. Click "Login" to access your account
3. New users click "Sign Up"

1. Enter full name (minimum 3 characters)
2. Enter email (valid format)
3. Enter PIN (4-10 digits)
4. Confirm PIN
5. Click "Sign Up"

After login, you can:

• Deposit Money - Add funds to your account
• Withdraw Money - Withdraw funds (if balance sufficient)
• Check Balance - View current balance
• Transaction History - See last 10 transactions
• Logout - Exit the application

Solution:

• Ensure MySQL server is running
• Check if port 3306 is accessible
• Verify credentials in DBConnection.java
• Run mysql -u root -p to test connection

Solution:

• Add mysql-connector-java-8.0.33.jar to your classpath
• In IDE, add JAR to project libraries
• Ensure JAR is in the same folder when running from command line

Solution:

• Run schema.sql again
• Verify database "atm_system" was created
• Check MySQL user has proper permissions

Solution:

• Update password in DBConnection.java
• Or reset MySQL root password
• Check MySQL is using default port 3306

id          INT (Primary Key, Auto-increment)
name        VARCHAR(100)
email       VARCHAR(100) (Unique)
pin         VARCHAR(10)
created_at  TIMESTAMP

id          INT (Primary Key, Auto-increment)
user_id     INT (Foreign Key)
balance     DOUBLE
created_at  TIMESTAMP

id          INT (Primary Key, Auto-increment)
user_id     INT (Foreign Key)
type        VARCHAR(20) - DEPOSIT or WITHDRAW
amount      DOUBLE
date        TIMESTAMP

✅ PIN validation (4-10 numeric digits) ✅ Email format validation ✅ Secure user input handling ✅ PreparedStatement (prevents SQL injection) ✅ Balance verification before withdrawal ✅ Prevents negative deposits/withdrawals ✅ Transaction logging for audit trail

Color Scheme:

• Login Frame: Blue (#2980B9)
• Signup Frame: Purple (#9B59B6)
• Dashboard: Light Blue (#3498DB)
• Deposit: Green (#2ECC71)
• Withdraw: Red (#E74C3C)

Screen Size: 900 x 600 (Laptop friendly) Font: Arial (14-36pt depending on use)

1. Click "Sign Up" on Login screen
2. Enter: Name="John Doe", Email="john@test.com", PIN="5678"
3. Confirm PIN="5678"
4. Click "Sign Up"
5. ✅ Account created successfully

1. Login with valid credentials
2. Click "Deposit Money"
3. Enter amount="1000"
4. Click "Deposit"
5. ✅ Balance increases by 1000

1. Dashboard shows balance
2. Click "Withdraw Money"
3. Enter amount="500"
4. Click "Withdraw"
5. ✅ Balance decreases by 500

1. Click "Check Balance"
2. ✅ Shows updated balance
3. Click "Transaction History"
4. ✅ Shows DEPOSIT and WITHDRAW records

This project is suitable for:

• Learning Java Swing GUI development
• Understanding OOP principles
• Practicing database design with JDBC
• Portfolio project showcase

Feel free to extend with:

• Transfer between accounts
• Mini statement printing
• PIN change functionality
• Account freeze/deactivate
• Mobile app version

This project is open-source and free to use for educational and personal purposes.

Created as a complete ATM Management System for learning Java, Swing, and MySQL integration.

For issues or questions:

1. Check the Troubleshooting section
2. Verify database setup
3. Ensure MySQL JDBC driver is properly installed
4. Check Java version (requires Java 8+)

This project teaches:

• OOP Concepts: Inheritance, Encapsulation, Polymorphism
• Design Patterns: DAO, Service Layer, MVC
• Database Operations: CRUD operations, Foreign Keys, Indexes
• GUI Development: Swing, Event Handling, Layout Management
• Best Practices: Input Validation, Error Handling, Code Organization

Enjoy building! 🚀