import java.sql.*;

public class TestBatch {

 /**
  * @param args
  */
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  Class.forName("oracle.jdbc.OracleDriver");
  Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL", "scott", "lomboz_eclipse");
  /*Statement stmt = conn.createStatement();
  stmt.addBatch("insert into dept values (52,'a','aa')");
  stmt.addBatch("insert into dept values (53,'b','bb')");
  stmt.addBatch("insert into dept values (54,'c','cc')");
  stmt.executeBatch();*/
  
  PreparedStatement pstmt = conn.prepareStatement("insert into dept values (?,?,?)");
  pstmt.setInt(1, 58);
  pstmt.setString(2, "hefei");
  pstmt.setString(3, "HF");
  pstmt.addBatch();
  
  pstmt.setInt(1, 59);
  pstmt.setString(2, "hefei");
  pstmt.setString(3, "HF");
  pstmt.addBatch();
  
  pstmt.setInt(1, 60);
  pstmt.setString(2, "hefei");
  pstmt.setString(3, "HF");
  pstmt.addBatch();
  
  pstmt.executeBatch();
  
  pstmt.close();
  conn.close();
 } 
 
}