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

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

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

        String query = """
                INSERT INTO book
                (bookid, title, publication_year, category, copies, isbn)
                VALUES (?, ?, ?, ?, ?, ?)
                """;

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

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

            System.out.print("Enter Title: ");
            String title = sc.nextLine();

            System.out.print("Enter Publication Year: ");
            int publicationYear = sc.nextInt();
            sc.nextLine();

            System.out.print("Enter Category: ");
            String category = sc.nextLine();

            System.out.print("Enter Copies: ");
            int copies = sc.nextInt();
            sc.nextLine();

            System.out.print("Enter ISBN: ");
            String isbn = sc.nextLine();

            prestmt.setInt(1, bookId);
            prestmt.setString(2, title);
            prestmt.setInt(3, publicationYear);
            prestmt.setString(4, category);
            prestmt.setInt(5, copies);
            prestmt.setString(6, isbn);

            int rows = prestmt.executeUpdate();

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

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

        String query = "DELETE FROM book WHERE bookid = ?";

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

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

            prestmt.setInt(1, bookId);

            int rows = prestmt.executeUpdate();

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

    // Update book details
    void update(Connection connection) throws SQLException {

        String query = """
                UPDATE book
                SET title = ?, publication_year = ?, category = ?, copies = ?, isbn = ?
                WHERE bookid = ?
                """;

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

            System.out.print("Enter Book ID to Update: ");
            int bookId = sc.nextInt();
            sc.nextLine();

            System.out.print("Enter New Title: ");
            String title = sc.nextLine();

            System.out.print("Enter New Publication Year: ");
            int publicationYear = sc.nextInt();
            sc.nextLine();

            System.out.print("Enter New Category: ");
            String category = sc.nextLine();

            System.out.print("Enter New Copies: ");
            int copies = sc.nextInt();
            sc.nextLine();

            System.out.print("Enter New ISBN: ");
            String isbn = sc.nextLine();

            prestmt.setString(1, title);
            prestmt.setInt(2, publicationYear);
            prestmt.setString(3, category);
            prestmt.setInt(4, copies);
            prestmt.setString(5, isbn);
            prestmt.setInt(6, bookId);

            int rows = prestmt.executeUpdate();

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

    // Get all books
    void getAll(Connection connection) throws SQLException {

        String query = "SELECT * FROM book";

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

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

            boolean found = false;
            while (rs.next()) {
                found = true;
                System.out.println(
                        "Book ID: " + rs.getInt("bookid") +
                        " | Title: " + rs.getString("title") +
                        " | Year: " + rs.getInt("publication_year") +
                        " | Category: " + rs.getString("category") +
                        " | Copies: " + rs.getInt("copies") +
                        " | ISBN: " + rs.getString("isbn")
                );
            }

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