TestBatch(26)

来源：互联网发布：三巨网络面试如何编辑：程序博客网时间：2024/06/04 23:25

/**
*Title:TestBatch
*Description:
*@Copyright:
*@Company:
*@autor:firefly
*@version:1.0
*@time:2012.10.30
*/

import java.sql.*;

public class TestBatch {
public static void main(String[] args) throws Exception {
  Class.forName("oracle.jdbc.driver.OracleDriver");
  Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@122.207.171.222:1521:ORCL", "scott", "tiger");
  /*
  Statement stmt = conn.createStatement();   //Statement 可以进行批处理操作
  stmt.addBatch("insert into dept2 values (51, '500', 'haha')");
  stmt.addBatch("insert into dept2 values (52, '500', 'haha')");
  stmt.addBatch("insert into dept2 values (53, '500', 'haha')");
  stmt.executeBatch();
  */

  //PreparedStatement 也可以进行批处理操作。
  PreparedStatement ps = conn.prepareStatement("insert into dept2 values (?, ?, ?)");
  ps.setInt(1, 51);
  ps.setString(2, "500");
  ps.setString(3, "haha");
  ps.addBatch();

  ps.setInt(1, 52);
  ps.setString(2, "500");
  ps.setString(3, "haha");
  ps.addBatch();

  ps.setInt(1, 53);
  ps.setString(2, "500");
  ps.setString(3, "haha");
  ps.addBatch();

  ps.executeBatch();
  ps.close();
  conn.close();
}
}