新建一个表格book(书号,书名,作者,价格,出版社,书类),新增三条记录,用jdbc连接

下面是用Java JDBC连接MySQL数据库，并创建book表格，插入三条记录的代码示例：

import java.sql.*;

public class BookDatabase {
    public static void main(String[] args) {
        // 数据库连接信息
        String url = "jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC";
        String username = "root";
        String password = "123456";

        try {
            // 加载驱动程序
            Class.forName("com.mysql.cj.jdbc.Driver");

            // 获取数据库连接
            Connection conn = DriverManager.getConnection(url, username, password);

            // 创建表格book
            Statement stmt = conn.createStatement();
            String sql = "CREATE TABLE IF NOT EXISTS book (id INT AUTO_INCREMENT PRIMARY KEY, book_number VARCHAR(20), book_name VARCHAR(50), author VARCHAR(50), price DOUBLE, publisher VARCHAR(50), book_category VARCHAR(50))";
            stmt.executeUpdate(sql);

            // 插入三条记录
            sql = "INSERT INTO book (book_number, book_name, author, price, publisher, book_category) VALUES (?, ?, ?, ?, ?, ?)";
            PreparedStatement pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, "001");
            pstmt.setString(2, "Java编程思想");
            pstmt.setString(3, "Bruce Eckel");
            pstmt.setDouble(4, 78.5);
            pstmt.setString(5, "机械工业出版社");
            pstmt.setString(6, "计算机科学");
            pstmt.executeUpdate();

            pstmt.setString(1, "002");
            pstmt.setString(2, "深入理解Java虚拟机");
            pstmt.setString(3, "周志明");
            pstmt.setDouble(4, 69.9);
            pstmt.setString(5, "机械工业出版社");
            pstmt.setString(6, "计算机科学");
            pstmt.executeUpdate();

            pstmt.setString(1, "003");
            pstmt.setString(2, "数据结构与算法分析");
            pstmt.setString(3, "Mark Allen Weiss");
            pstmt.setDouble(4, 58.0);
            pstmt.setString(5, "机械工业出版社");
            pstmt.setString(6, "计算机科学");
            pstmt.executeUpdate();

            // 关闭连接
            pstmt.close();
            stmt.close();
            conn.close();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

这里我们使用了MySQL数据库，创建了一个名为book的表格，包含了书号、书名、作者、价格、出版社和书类等字段。然后插入了三条记录。在实际应用中，需要根据实际情况修改数据库连接信息和SQL语句。