Personal Finance Management System 💰

A simple Java-based console application to manage personal finances using MySQL and JDBC.

🚀 Features

• Add Income
• Add Expense (with categories)
• View Balance Summary
• View All Transactions
• Delete Transactions
• Filter Transactions by Category

🛠️ Tech Stack

• Java
• JDBC
• MySQL
• Maven

🗄️ Database Setup

CREATE DATABASE finance_db;

USE finance_db;

CREATE TABLE transactions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    type VARCHAR(20),
    category VARCHAR(50),
    amount DOUBLE,
    date VARCHAR(20)
);

▶️ How to Run

1. Clone the repository
2. Configure database credentials in DBConnection.java
3. Run Main.java

⚠️ Note

Database credentials are not included for security reasons.

📌 Future Improvements

• GUI (JavaFX)
• Monthly reports
• User authentication