一、最初使用方式:
每条sql语句Statement单独执行,每次需要重新编译
像下面这个例子,向学生表中添加三条数据,则需要编译三次。
public static void testOld() {
String sql1 = "insert into studentExam(stuName, exam1, exam2) values ('stu1', 90, 97);";
String sql2 = "insert into studentExam(stuName, exam1, exam2) values ('stu2', 90, 97);";
String sql3 = "insert into studentExam(stuName, exam1, exam2) values ('stu3', 90, 97);";
Connection con = null;
Statement sta = null;
try {
String url = "jdbc:mysql://localhost:3306/webwssc";
Class.forName("com.mysql.cj.jdbc.Driver");
con = DriverManager.getConnection(url, "root", "root");
sta = con.createStatement();
sta.executeUpdate(sql1);
sta.executeUpdate(sql2);
sta.executeUpdate(sql