import  java.sql.*;
 import  java.io.*;


 public   class  testBatch {
	 public   static   void  main(String[] args) {
		Connection conn =  null ;
		 try  {
			 Class .forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:info", "scott", "tiger");
		}  catch  (Exception e) {
			System.out.println("Error: " + e);
		} //try
		 if  (conn !=  null ) {			
			 try  {
				Statement stmt = conn.createStatement();
				stmt.addBatch("CREATE TABLE tmp1(x INT)");
				stmt.addBatch("CREATE TABLE tmp2(y INT)");
				stmt.executeBatch();
			}  catch  (Exception e) {
				e.printStackTrace();
			}  finally  {
				 try  {
					 if  (conn !=  null ) {
						conn.close(); conn =  null ;
					}
				}  catch  (Exception ignore) {
				} //try
			}
		}
	}
};