BookRepository.java

import javax.swing.*;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class BookRepository {
    private static final String[][] FAMOUS_BOOKS = {
        {"The Alchemist", "Paulo Coelho"},
        {"Harry Potter and the Sorcerer's Stone", "J.K. Rowling"},
        {"The Hobbit", "J.R.R. Tolkien"},
        {"To Kill a Mockingbird", "Harper Lee"},
        {"Pride and Prejudice", "Jane Austen"},
        {"The Great Gatsby", "F. Scott Fitzgerald"},
        {"1984", "George Orwell"},
        {"The Catcher in the Rye", "J.D. Salinger"},
        {"The Kite Runner", "Khaled Hosseini"},
        {"The Lord of the Rings", "J.R.R. Tolkien"}
    };

    private BookRepository() {
    }

    public static void initializeLibraryData() {
        Connection con = DBConnection.getConnection();
        if (con == null) {
            return;
        }

        try (Statement createTable = con.createStatement()) {
            // Create table first
            createTable.executeUpdate(
                "CREATE TABLE IF NOT EXISTS books ("
                    + "id INT PRIMARY KEY AUTO_INCREMENT,"
                    + "name VARCHAR(255) NOT NULL,"
                    + "author VARCHAR(255) NOT NULL,"
                    + "issued BOOLEAN NOT NULL DEFAULT FALSE)"
            );

            // Then check if we need to seed data
            try (PreparedStatement countStatement = con.prepareStatement("SELECT COUNT(*) FROM books")) {
                ResultSet countResult = countStatement.executeQuery();
                if (countResult.next() && countResult.getInt(1) == 0) {
                    seedFamousBooks(con);
                }
            }
        } catch (Exception ex) {
            JOptionPane.showMessageDialog(null, "Unable to initialize library data.\n" + ex.getMessage());
        }
    }

    public static List<BookItem> getAllBooks() {
        List<BookItem> books = new ArrayList<>();
        Connection con = DBConnection.getConnection();
        if (con == null) {
            return books;
        }

        try (
            PreparedStatement ps = con.prepareStatement("SELECT * FROM books ORDER BY name");
            ResultSet rs = ps.executeQuery()
        ) {
            while (rs.next()) {
                books.add(new BookItem(
                    rs.getInt("id"),
                    rs.getString("name"),
                    rs.getString("author"),
                    rs.getBoolean("issued")
                ));
            }
        } catch (Exception ex) {
            JOptionPane.showMessageDialog(null, "Unable to load books.\n" + ex.getMessage());
        }
        return books;
    }

    public static void loadBooksInto(JComboBox<BookItem> comboBox, boolean onlyAvailable, boolean onlyIssued) {
        comboBox.removeAllItems();
        for (BookItem book : getAllBooks()) {
            if (onlyAvailable && book.isIssued()) {
                continue;
            }
            if (onlyIssued && !book.isIssued()) {
                continue;
            }
            comboBox.addItem(book);
        }
    }

    public static int getBookCount() {
        return getAllBooks().size();
    }

    private static void seedFamousBooks(Connection con) throws SQLException {
        try (PreparedStatement insert = con.prepareStatement(
            "INSERT INTO books(name, author, issued) VALUES(?,?,false)"
        )) {
            for (String[] book : FAMOUS_BOOKS) {
                insert.setString(1, book[0]);
                insert.setString(2, book[1]);
                insert.addBatch();
            }
            insert.executeBatch();
        }
    }
}