FileDocCategorySizeDatePackage
TestThinPerfPrepN.javaAPI DocExample1298Fri Apr 06 18:37:44 BST 2001None

TestThinPerfPrepN

public class TestThinPerfPrepN extends Object

Fields Summary
Constructors Summary
Methods Summary
public static voidmain(java.lang.String[] args)

  int i;
  long startTime; 
  long stopTime;
  DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  Connection conn = 
   DriverManager.getConnection("jdbc:oracle:thin:@dssw2k01:1521:orcl","scott","tiger");
  conn.setAutoCommit(false);
  startTime = System.currentTimeMillis();
  PreparedStatement stmt = conn.prepareStatement(
   "insert into testxxxperf ( id, code, descr, insert_user, insert_date ) " +
   "values ( ?, ?, ?, ?, ? )");
  for (i=1;i<new Integer(args[0]).intValue()+1;i++) {
   stmt.setInt(1,i);
   stmt.setString(2,"123456789012345678901234567890");
   stmt.setString(3,"12345678901234567890123456789012345678901234567890123456789012345678901234567890");
   stmt.setString(4,"ZXVI01");
   stmt.setDate(5,new java.sql.Date(System.currentTimeMillis()));
   stmt.executeUpdate();
  }
  conn.commit(); 
  stopTime = System.currentTimeMillis();

  Statement dstmt = conn.createStatement();
  dstmt.executeUpdate("delete testxxxperf");
  conn.commit();
  dstmt.close();

  stmt.close();
  conn.close();
  System.out.println( "Elapsed time in milliseconds: " + Long.toString( stopTime - startTime ) );