Batch批处理

 1 import java.sql.*;
 2 public class TestBatch {
 3 
 4 
 5     public static void main(String[] args) throws Exception {
 6         Class.forName("oracle.jdbc.driver.OracleDriver");
 7         Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:SXT", "scott", "tiger");
 8         /*
 9         Statement stmt = conn.createStatement();
10         stmt.addBatch("insert into dept2 values (51, '500', 'haha')");
11         stmt.addBatch("insert into dept2 values (52, '500', 'haha')");
12         stmt.addBatch("insert into dept2 values (53, '500', 'haha')");
13         stmt.executeBatch();
14         stmt.close();
15         */
16         
17         PreparedStatement ps = conn.prepareStatement("insert into dept2 values (?, ?, ?)");
18         ps.setInt(1, 61);
19         ps.setString(2, "haha");
20         ps.setString(3, "bj");
21         ps.addBatch();
22         
23         ps.setInt(1, 62);
24         ps.setString(2, "haha");
25         ps.setString(3, "bj");
26         ps.addBatch();
27         
28         ps.setInt(1, 63);
29         ps.setString(2, "haha");
30         ps.setString(3, "bj");
31         ps.addBatch();
32         
33         ps.executeBatch();
34         ps.close();
35         
36         conn.close();
37 
38     }
39 　　//上面是两种statement进行批处理的例子
40 }