@Test
public void tableTest() {
Connection conn = null;
Statement st = null;
String sql = "CREATE TABLE `user_test`(`id` int NOT NULL AUTO_INCREMENT,`age` int(3) NOT NULL DEFAULT 0,PRIMARY KEY (`id`)) ENGINE = InnoDB COMMENT = '测试表';";
try {
//数据库的连接对象
conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test", "root", "root");
//createStatement() ; 创建静态语句对象
st = conn.createStatement();
//执行DML /DDL语句 如果执行 DML ,返回的是受影响的行数 如果执行DDL .返回 0 .
st.executeUpdate(sql);
} catch (Exception e) {
e.printStackTrace();
} finally {
//释放资源链接
if (st != null) {
try {
st.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
java执行sql ddl
于 2022-11-09 10:43:52 首次发布