在java中使用JDBC实现批处理的对象一般是使用PrepareStatement对象
批量插入：
1 Class.forName("Oracle.jdbc.driver.OracleDriver");
2 Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:demo" , "scott" , "tiger");
3 PreparedStatement ps = conn.prepareStatement("insert into dept2 values(? , ? , ?)");
4
5 for(Dept dept-> depts){
6 ps.setInt(1, dept.Id);
7 ps.setString(2, dept.Name);
8 ps.setString(3, dept.Description);
9 ps.addBatch();
10 }
11
12 ps.executeBatch();
13 ps.close();
14
15 conn.close();
1
