BalanceEnquiry.java

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;

public class BalanceEnquiry extends JFrame implements ActionListener {

    String pin;
    JButton b1;

    public BalanceEnquiry(String pin) {
        this.pin = pin;

        // Background Image Setup
        ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("icons/atm2.png"));
        Image i2 = i1.getImage().getScaledInstance(1550, 830, Image.SCALE_DEFAULT);
        ImageIcon i3 = new ImageIcon(i2);
        JLabel l3 = new JLabel(i3);
        l3.setBounds(0, 0, 1550, 830);
        l3.setLayout(null); // CRITICAL: Allows components on top of the image to work
        add(l3);

        // Back Button
        b1 = new JButton("BACK");
        b1.setBounds(700, 406, 150, 35);
        b1.setBackground(new Color(65, 125, 128));
        b1.setForeground(Color.WHITE);
        b1.addActionListener(this);
        l3.add(b1);

        // Database Logic to calculate balance
        int balance = 0;
        try {
            Con c = new Con();
            ResultSet rs = c.statement.executeQuery("select * from bank where pin = '" + pin + "'");
            while (rs.next()) {
            // Use Double.parseDouble and cast to int to avoid decimal errors
            String amountStr = rs.getString("amount");
            int amount = (int) Double.parseDouble(amountStr); 
        
            if (rs.getString("type").equalsIgnoreCase("Deposit")) {
                balance += amount;
            } else {
                balance -= amount;
            }
        }
    } catch (Exception e) {
    // This will print the exact error to your terminal
        System.out.println("SQL ERROR: " + e.getMessage());
        e.printStackTrace(); 
    }

        // Display Balance Label
        JLabel label1 = new JLabel("Your Current Balance is:");
        label1.setForeground(Color.WHITE);
        label1.setFont(new Font("System", Font.BOLD, 16));
        label1.setBounds(430, 180, 400, 30);
        l3.add(label1);

        JLabel label2 = new JLabel("Rs " + balance);
        label2.setForeground(Color.WHITE);
        label2.setFont(new Font("System", Font.BOLD, 16));
        label2.setBounds(430, 220, 400, 30);
        l3.add(label2);

        // Frame Properties
        setLayout(null);
        setSize(1550, 1080);
        setLocation(0, 0);
        setUndecorated(true); // Matches your ATM theme
        setVisible(true);
    }

    @Override
    public void actionPerformed(ActionEvent e) {
        setVisible(false);
        new main_Class(pin);
    }

    public static void main(String[] args) {
        new BalanceEnquiry("");
    }
}