DatabaseConnection.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class DatabaseConnection {

    public static void main(String[] args) {

        String url = "jdbc:mysql://localhost:3307/trackify";
        String user = "root";
        String password = "";

        try {

            Connection conn = DriverManager.getConnection(url, user, password);

            String sql = "INSERT INTO expenses(amount, category, expense_date) VALUES (?, ?, ?)";

            PreparedStatement pstmt = conn.prepareStatement(sql);

            pstmt.setDouble(1, 500);
            pstmt.setString(2, "Food");
            pstmt.setString(3, "2026-05-22");

            pstmt.executeUpdate();

            System.out.println("Expense inserted successfully!");

            conn.close();

        } catch (Exception e) {

            e.printStackTrace();

        }
    }
}