create dababase 數(shù)據(jù)庫(kù)名

create table bookinfo(
    -> book_id int primary key auto_increment,
    -> book_name varchar(20) not null,
    -> price float(6,2) not null,
    -> public_date date not null,
    -> store int not null
    -> );

package com.jdbc.test;
import java.math.BigDecimal;
import java.sql.*;
public class DBConnection {
    //數(shù)據(jù)庫(kù)url，username，password
    static final String DB_url = "jdbc:mysql://localhost:3306/book";
    static final String username = "root";
    static final String password = "123456";
    public static void main(String[] args) {
        try {
            //1.注冊(cè)JDBC驅(qū)動(dòng)
            Class.forName("com.mysql.jdbc.Driver");
            //2.獲取數(shù)據(jù)庫(kù)連接
            Connection connection = DriverManager.getConnection(DB_url,username,password);
            //3.操作數(shù)據(jù)庫(kù)
            Statement statement = connection.createStatement();//獲取操作數(shù)據(jù)庫(kù)的對(duì)象
            String sql = "select * from bookinfo";//定義數(shù)據(jù)庫(kù)語(yǔ)句
            ResultSet resultSet = statement.executeQuery(sql);//執(zhí)行數(shù)據(jù)庫(kù)語(yǔ)句獲取結(jié)果集
            while(resultSet.next()){
                int bookid = resultSet.getInt("book_id");
                String bookname = resultSet.getNString("booK_name");
                BigDecimal price = resultSet.getBigDecimal("price");
                Date publicdate = resultSet.getDate("public_date");
                String store = resultSet.getNString("store");
                System.out.println("圖書編號(hào)"+bookid);
                System.out.println("圖書名"+bookname);
            }
            //4.關(guān)閉結(jié)果集，數(shù)據(jù)庫(kù)操作對(duì)象，數(shù)據(jù)庫(kù)連接
            resultSet.close();
            statement.close();
            connection.close();
        }catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}