import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Statement;
public class JDbc {
public static void main(String[] args) {
Connection connection = null;
Statement statement = null;
try {
Class.forName("com.mysql.jdbc.Driver");//加载Driver类
connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test02?characterEncoding=utf8","root","root");
//链接数据库 在test02库后添加?characterEncoding=utf8 让导入中文不会变成? 单次有效
statement = (Statement) connection.createStatement();//新建Statement接口
statement.addBatch("insert into tb_peo(id, name, birthday) values('5','郭珂','1999-8-10')");
statement.addBatch("insert into tb_peo(id, name, birthday) values('6','狗蛋','1999-8-13')");
statement.addBatch("insert into tb_peo(id, name, birthday) values('7','翠花','1979-4-10')");
int a[] = statement.executeBatch();
for(int res : a){
System.out.println("影响的行数为:"+res);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
statement.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}