使用Statement执行sql语句
时间：2021-07-01 10:21:17
帮助过：2人阅读
java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import org.junit.Test;
public class Demo2 {
private String url = "jdbc:mysql://localhost:3306/test1"
;
private String user = "root";
//用户名
private String password ="123";
//密码
/**
* 执行DDL语句(创建表)
*/
@Test
public void test1(){
Statement stmt =
null;
Connection conn =
null;
try {
//1.驱动注册程序
Class.forName("com.mysql.jdbc.Driver"
);
//2.获取连接对象
conn =
DriverManager.getConnection(url, user, password);
//3.创建Statement
stmt =
conn.createStatement();
//4.准备sql
String sql = "CREATE TABLE student2(id INT PRIMARY KEY AUTO_INCREMENT,NAME VARCHAR(20),gender VARCHAR(2))"
;
//5.发送sql语句，执行sql语句,得到返回结果
int count =
stmt.executeUpdate(sql);
//6.输出
System.out.println("影响了"+count+"行！"
);
} catch (Exception e) {
e.printStackTrace();
throw new RuntimeException(e);
} finally{
//7.关闭连接(顺序:后打开的先关闭)
if(stmt!=
null)
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException(e);
}
if(conn!=
null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException(e);
}
}
}
}
使用Statement执行sql语句
标签：
