Members.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 Members {

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

    // Insert new Member
    void insert(Connection connection) throws SQLException {

        String query = """
                INSERT INTO members
                (member_id, name, email, phone, membership_date)
                VALUES (?, ?, ?, ?, ?)
                """;

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

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

            System.out.print("Enter Member Name: ");
            String name = sc.nextLine();

            System.out.print("Enter Email: ");
            String email = sc.nextLine();

            System.out.print("Enter Phone Number: ");
            String phone = sc.nextLine();

            System.out.print("Enter Membership Date (YYYY-MM-DD): ");
            String membershipDate = sc.nextLine();

            prestmt.setInt(1, memberId);
            prestmt.setString(2, name);
            prestmt.setString(3, email);
            prestmt.setString(4, phone);
            prestmt.setString(5, membershipDate);

            int rows = prestmt.executeUpdate();

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

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

        String query = "DELETE FROM members WHERE member_id = ?";

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

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

            prestmt.setInt(1, memberId);

            int rows = prestmt.executeUpdate();

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

    // Update Member
    void update(Connection connection) throws SQLException {

        String query = """
                UPDATE members
                SET name = ?, email = ?, phone = ?, membership_date = ?
                WHERE member_id = ?
                """;

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

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

            System.out.print("Enter New Name: ");
            String name = sc.nextLine();

            System.out.print("Enter New Email: ");
            String email = sc.nextLine();

            System.out.print("Enter New Phone: ");
            String phone = sc.nextLine();

            System.out.print("Enter New Membership Date (YYYY-MM-DD): ");
            String membershipDate = sc.nextLine();

            prestmt.setString(1, name);
            prestmt.setString(2, email);
            prestmt.setString(3, phone);
            prestmt.setString(4, membershipDate);
            prestmt.setInt(5, memberId);

            int rows = prestmt.executeUpdate();

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

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

        String query = "SELECT * FROM members";

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

            System.out.println("\n===== 👥 Members List =====");

            boolean found = false;
            while (rs.next()) {
                found = true;
                System.out.println(
                        "Member ID: " + rs.getInt("member_id") +
                        " | Name: " + rs.getString("name") +
                        " | Email: " + rs.getString("email") +
                        " | Phone: " + rs.getString("phone") +
                        " | Membership Date: " + rs.getDate("membership_date")
                );
            }

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