JDBC连接数据库

JDBC连接数据库

public static void gwc(String man) throws SQLException {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");//mysql 8.0版本以上的注册语句
            Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/b1(数据库名)
            ?useSSL=false&serverTimezone=UTC", "root","password");
            String sql="create table "+man+"(name varchar(20),price double,payment varchar(20),insert_time timestamp)";
            Statement stmt=conn.createStatement();
            stmt.executeUpdate(sql);
            stmt.close();conn.close();
        }catch(ClassNotFoundException e) {
            e.printStackTrace();
        }
​
    }

时区语句

?useSSL=false&serverTimezone=UTC

连接步骤

1. 导入jar包（jar包版本需和数据库版本一致）构建引用路径

2. 注册驱动

   Class.forName("com.mysql.cj.jdbc.Driver");

3. 获取数据库连接对象

   Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/xxx", "root","password");

4. 定义sql语句

   String sql="create table "+man+"(name varchar(20),price double,payment varchar(20),insert_time timestamp)";

5. 获取执行sql语句对象

   Statement stmt=conn.createStatement();

6. 执行sql语句

   stmt.executeUpdate(sql);

7. 处理结果

8. 释放资源