java_sql_Batch_批处理
时间：2021-07-01 10:21:17
帮助过：17人阅读
package com.ayang.jdbc;
2
3 import java.sql.*
;
4
5
6 public class TestBatch {
7
8 //为看清逻辑关系，throws出去
9 public static void main(String[] args)
throws Exception {
10 Class.forName("oracle.jdbc.driver.OracleDriver"
);
11 Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL","scott","root"
);
12
13 /**
14 * 批处理 方法一：
15 */
16 /*Statement stmt = conn.createStatement();
17 stmt.addBatch("insert into dept2 values(51,‘JAVA‘,‘XC‘)");
18 stmt.addBatch("insert into dept2 values(52,‘PHP‘,‘ZZ‘)");
19 stmt.addBatch("insert into dept2 values(53,‘C++‘,‘XINYANG‘)");
20
21 stmt.executeBatch();
22 stmt.close();*/
23
24 /**
25 * 批处理 方法二：
26 */
27 PreparedStatement ps = conn.prepareStatement("insert into dept2 values(?,?,?)"
);
28 ps.setInt(1, 54
);
29 ps.setString(2, "haha"
);
30 ps.setString(3, "HangZhou"
);
31 ps.addBatch();
32
33 ps.setInt(1, 55
);
34 ps.setString(2, "haha"
);
35 ps.setString(3, "HangZhou"
);
36 ps.addBatch();
37
38 ps.setInt(1, 56
);
39 ps.setString(2, "haha"
);
40 ps.setString(3, "HangZhou"
);
41 ps.addBatch();
42 ps.executeBatch();
43 ps.close();
44
45 conn.close();
46
47 }
48
49 }
java_sql_Batch_批处理
标签：
