import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class Sql {
public static void main(String[] args) {
Connection conn;
Statement stmt;
String sql[] = {
//”create table student(id varchar(10),name varchar(10))”,
“insert into student values(‘1’,’lancy’)”,
“insert into student values(‘2’,’tom’)”,
“insert into student values(‘3’,’jerry’)” };
try {
//加载驱动
Class.forName(“com.mysql.jdbc.Driver”);
System.out.println(“驱动加载成功”);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
//获得数据库连接
conn = DriverManager
.getConnection(“jdbc:mysql://localhost/student?user=root&password=sa”);
System.out.println(“获得数据库连接”);
//获得语句对象
stmt=conn.createStatement();
//执行sql语句
long t1=System.nanoTime();
for(int i=0;i
Statement 执行更新
最新推荐文章于 2024-05-29 09:12:23 发布