JDBC新建数据库建表并插入数据

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Study {

    public static void main(String[] args) throws Exception {
    
        Class.forName("com.mysql.jdbc.Driver");
        String url = "jdbc:mysql://localhost:3306/study";
        Connection conn = DriverManager.getConnection(url, "root", "123456");
        Statement stat = conn.createStatement();
        stat.executeUpdate("create database hello");    // 创建数据库hello
        
        url = "jdbc:mysql://localhost:3306/hello";
        conn = DriverManager.getConnection(url, "root", "123456");
        stat = conn.createStatement();
        // 创建表 test
        stat.executeUpdate("create table test(id int, name varchar(80))");    
        //添加数据
        stat.executeUpdate("insert into test values(1, '张三')");
        stat.executeUpdate("insert into test values(2, '李四')");
        //查询数据
        ResultSet result = stat.executeQuery("select * from test");
        while (result.next()) {
            System.out.println(result.getInt("id") + " " + result.getString("name"));
        }
        result.close();
        stat.close();
        conn.close();
    }
}