java连接mysql执行ddl_JDBC执行DDL语句

~~~

package JDBC;

/**

* @author: hcf

* @qq: 46914685

* @email: 46914685@qq.com

*/

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

/**

* 执行DDL语句

*/

public class JDBCDemo5 {

public static void main(String[] args) {

Connection conn = null;

Statement stmt = null;

try {

//1.注册驱动

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

//2.获取连接对象

conn = DriverManager.getConnection("jdbc:mysql:///db1?serverTimezone=UTC", "root", "admin123");

//3.定义sql

String sql = "create table student(id int,name varchar(20))";

//4.获取执行sql对象

stmt = conn.createStatement();

//5.执行sql

int count = stmt.executeUpdate(sql);

//6.处理结果

System.out.println(count);

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException throwables) {

throwables.printStackTrace();

} finally {

//7.释放资源

if (stmt != null) {

try {

stmt.close();

} catch (SQLException throwables) {

throwables.printStackTrace();

}

}

if (conn != null) {

try {

conn.close();

} catch (SQLException throwables) {

throwables.printStackTrace();

}

}

}

}

}

~~~