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

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

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

        String query = """
                INSERT INTO library_service
                (service_id, service_name, description, status)
                VALUES (?, ?, ?, ?)
                """;

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

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

            System.out.print("Enter Service Name: ");
            String serviceName = sc.nextLine();

            System.out.print("Enter Description: ");
            String description = sc.nextLine();

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

            prestmt.setInt(1, serviceId);
            prestmt.setString(2, serviceName);
            prestmt.setString(3, description);
            prestmt.setString(4, status);

            int rows = prestmt.executeUpdate();

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

    // Delete Library Service
    void delete(Connection connection) throws SQLException {

        String query = "DELETE FROM library_service WHERE service_id = ?";

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

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

            prestmt.setInt(1, serviceId);

            int rows = prestmt.executeUpdate();

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

    // Update Library Service
    void update(Connection connection) throws SQLException {

        String query = """
                UPDATE library_service
                SET service_name = ?, description = ?, status = ?
                WHERE service_id = ?
                """;

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

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

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

            System.out.print("Enter New Description: ");
            String description = sc.nextLine();

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

            prestmt.setString(1, serviceName);
            prestmt.setString(2, description);
            prestmt.setString(3, status);
            prestmt.setInt(4, serviceId);

            int rows = prestmt.executeUpdate();

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

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

        String query = "SELECT * FROM library_service";

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

            System.out.println("\n===== 📚 Library Services List =====");

            boolean found = false;
            while (rs.next()) {
                found = true;
                System.out.println(
                        "Service ID: " + rs.getInt("service_id") +
                        " | Service Name: " + rs.getString("service_name") +
                        " | Description: " + rs.getString("description") +
                        " | Status: " + rs.getString("status")
                );
            }

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