InsertSampleData.java

import java.sql.*;

public class InsertSampleData {
    public static void main(String[] args) {
        try {
            // Load the MySQL JDBC driver
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            System.out.println("MySQL JDBC driver not found: " + e.getMessage());
            return;
        }

        try {
            Connection con = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/", "root", "root"
            );

            // Create database if not exists
            Statement stmt = con.createStatement();
            stmt.executeUpdate("CREATE DATABASE IF NOT EXISTS library_db");
            stmt.close();
            con.close();

            // Now connect to the database
            con = DBConnection.getConnection();
            if (con == null) {
                System.out.println("Database connection failed.");
                return;
            }

            // Create table if not exists
            stmt = con.createStatement();
            stmt.executeUpdate(
                "CREATE TABLE IF NOT EXISTS books (" +
                "id INT AUTO_INCREMENT PRIMARY KEY, " +
                "name VARCHAR(50), " +
                "author VARCHAR(50), " +
                "issued BOOLEAN)"
            );
            stmt.close();

            String[] books = {
                "To Kill a Mockingbird|Harper Lee",
                "1984|George Orwell",
                "The Great Gatsby|F. Scott Fitzgerald",
                "Pride and Prejudice|Jane Austen",
                "The Catcher in the Rye|J.D. Salinger",
                "Harry Potter and the Sorcerer's Stone|J.K. Rowling",
                "The Lord of the Rings|J.R.R. Tolkien",
                "The Hobbit|J.R.R. Tolkien",
                "Dune|Frank Herbert",
                "Neuromancer|William Gibson"
            };

            PreparedStatement ps = con.prepareStatement(
                "INSERT INTO books(name, author, issued) VALUES(?,?,false)"
            );

            for (String book : books) {
                String[] parts = book.split("\\|");
                ps.setString(1, parts[0]);
                ps.setString(2, parts[1]);
                ps.executeUpdate();
                System.out.println("Inserted: " + parts[0]);
            }

            ps.close();
            con.close();
            System.out.println("Sample data inserted successfully!");
        } catch (SQLException e) {
            System.out.println("Error: " + e.getMessage());
        }
    }
}