Book database application

PHOTO EMBED

Fri Nov 15 2024 15:27:34 GMT+0000 (Coordinated Universal Time)

Saved by @login123 

import java.sql.*;
import java.util.Scanner;

public class BookDatabaseApp {

    private static final String URL = "jdbc:mysql://localhost:3306/books";
    private static final String USER = "root";
    private static final String PASSWORD = "ramesh";

    public static void main(String[] args) {
        Scanner scanner = new Scanner(System.in);

        System.out.println("Enter Book ID: ");
        int id = scanner.nextInt();
        scanner.nextLine();

        System.out.println("Enter Book Title: ");
        String title = scanner.nextLine();

        System.out.println("Enter Book Author: ");
        String author = scanner.nextLine();

        System.out.println("Enter Book Publisher: ");
        String publisher = scanner.nextLine();

        System.out.println("Enter Book Price: ");
        double price = scanner.nextDouble();

        insertBook(id, title, author, publisher, price);
        scanner.close();
    }

    public static void insertBook(int id, String title, String author, String publisher, double price) {
        try (Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
             PreparedStatement pstmt = conn.prepareStatement("INSERT INTO book (id, title, author, publisher, price) VALUES (?, ?, ?, ?, ?)")) {
            pstmt.setInt(1, id);
            pstmt.setString(2, title);
            pstmt.setString(3, author);
            pstmt.setString(4, publisher);
            pstmt.setDouble(5, price);
            System.out.println(pstmt.executeUpdate() + " row(s) inserted.");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}
content_copyCOPY