Fine.java

package LMS.com;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;

public class Fine {

    private Scanner sc = new Scanner(System.in);

    // Insert Fine
    void insert(Connection connection) throws SQLException {

        String query = """
                INSERT INTO fine
                (fine_id, member_id, amount, status)
                VALUES (?, ?, ?, ?)
                """;

        try (PreparedStatement prestmt = connection.prepareStatement(query)) {

            System.out.print("Enter Fine ID: ");
            int fineId = sc.nextInt();

            System.out.print("Enter Member ID: ");
            int memberId = sc.nextInt();

            System.out.print("Enter Amount: ");
            double amount = sc.nextDouble();
            sc.nextLine(); // consume newline

            System.out.print("Enter Status (Paid/Unpaid): ");
            String status = sc.nextLine();

            prestmt.setInt(1, fineId);
            prestmt.setInt(2, memberId);
            prestmt.setDouble(3, amount);
            prestmt.setString(4, status);

            int rows = prestmt.executeUpdate();

            if (rows > 0) {
                System.out.println("✅ Fine Inserted Successfully!");
            } else {
                System.out.println("❌ Fine Insert Failed!");
            }
        }
    }

    // Delete Fine
    void delete(Connection connection) throws SQLException {

        String query = "DELETE FROM fine WHERE fine_id = ?";

        try (PreparedStatement prestmt = connection.prepareStatement(query)) {

            System.out.print("Enter Fine ID to Delete: ");
            int fineId = sc.nextInt();

            prestmt.setInt(1, fineId);

            int rows = prestmt.executeUpdate();

            if (rows > 0) {
                System.out.println("🗑 Fine Deleted Successfully!");
            } else {
                System.out.println("❌ Fine ID Not Found!");
            }
        }
    }

    // Update Fine (Pay / Unpay)
    void update(Connection connection) throws SQLException {

        String query = "UPDATE fine SET status = ? WHERE fine_id = ?";

        try (PreparedStatement prestmt = connection.prepareStatement(query)) {

            System.out.print("Enter Fine ID to Update: ");
            int fineId = sc.nextInt();
            sc.nextLine(); // consume newline

            System.out.print("Enter New Status (Paid/Unpaid): ");
            String status = sc.nextLine();

            prestmt.setString(1, status);
            prestmt.setInt(2, fineId);

            int rows = prestmt.executeUpdate();

            if (rows > 0) {
                System.out.println("✏ Fine Updated Successfully!");
            } else {
                System.out.println("❌ Fine ID Not Found!");
            }
        }
    }

    // Get All Fines
    void getAll(Connection connection) throws SQLException {

        String query = "SELECT * FROM fine";

        try (PreparedStatement prestmt = connection.prepareStatement(query);
             ResultSet rs = prestmt.executeQuery()) {

            System.out.println("\n===== 💰 Fine List =====");

            boolean found = false;
            while (rs.next()) {
                found = true;
                System.out.println(
                        "Fine ID: " + rs.getInt("fine_id") +
                        " | Member ID: " + rs.getInt("member_id") +
                        " | Amount: ₹" + rs.getDouble("amount") +
                        " | Status: " + rs.getString("status")
                );
            }

            if (!found) {
                System.out.println("No fines found.");
            }
        }
    }
}