executeBatch() 事务 批量执行sql

Connection connection = OracleDB.getConn(ip, user, password);

	if (connection == null) {

	  return;

	}

	Statement statement = null;

	File file = new File("D:\\test.sql");

	

	List<String> sqlList = loadSql(file);

	try {

	    connection.setAutoCommit(false);

	    statement = connection.createStatement();

	    for (String sql : sqlList) {

		System.out.println("sql :  " + sql);

		statement.addBatch(sql);

	    }

	    int[] rows = statement.executeBatch();

	   System.out.println("Row count:" + Arrays.toString(rows));



	} catch (Exception ex) {

	    connection.rollback();

	    connection.setAutoCommit(true);

             System.err.print(ex.getMessage());

	} finally {

	    OracleDB.closeAll(connection, statement, null);

	}

create table TEST_DELETE

(

  ADDRESS VARCHAR2(50) not null,

  NAME    VARCHAR2(50) not null,

  SCORE   NUMBER not null

)

;

alter table TEST_DELETE

  add constraint TEST_PK primary key (ADDRESS, SCORE);





insert into TEST_DELETE (ADDRESS, NAME, SCORE)

values ('Los Angeles', 'kobe', 100);

insert into TEST_DELETE (ADDRESS, NAME, SCORE)

values ('Los Angeles', 'Atai', 23);

insert into TEST_DELETE (ADDRESS, NAME, SCORE)

values ('Italy', 'kobe', 23);

insert into TEST_DELETE (ADDRESS, NAME, SCORE)

values ('Los Angeles', 'Plou', 95);

insert into TEST_DELETE (ADDRESS, NAME, SCORE)

values ('Espana', 'Plou', 95);

Class.forName("oracle.jdbc.driver.OracleDriver");

	  

	  

	    return   DriverManager.getConnection(url,user,password);