JDBC（Oracle 数据库）中的批处理…

直接上代码:

packagecn.zhou.epet.test;

importjava.sql.*;

publicclass Addbatch {

publicstatic void main(String[] args) {

Connection connection =null;

PreparedStatement stmt =null;

try{

//加载数据库相关驱动

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

//连接到数据库

connection =DriverManager.getConnection(

"jdbc:oracle:thin:@localhost:1521:bdqn","epet", "admin");

stmt =connection

.prepareStatement("insertinto master values(master_seq.nextval,?,?,?)");

connection.setAutoCommit(false);//Transaction Begin,让程序不自动提交事务

stmt.setString(1,"QQ");

stmt.setString(2,"RR");

stmt.setInt(3,1);

stmt.addBatch();//添加批处理1

stmt.setString(1,"WW");

stmt.setString(2,"EE");

stmt.setInt(3,1);

stmt.addBatch();//添加批处理2

stmt.setString(1,"VV");

stmt.setString(2,"AA");

stmt.setInt(3,1);

stmt.addBatch();//添加批处理3

stmt.executeBatch();//执行批处理

connection.commit();//提交事务

connection.setAutoCommit(true);//Transaction End,让程序自动提交事务(默认)

System.out.println("dd");

} catch(ClassNotFoundException e) {

e.printStackTrace();

System.out.println("未能成功加载驱动类!");

} catch(SQLException e) {

e.printStackTrace();

System.out.println("执行SQL语句是出现异常！");

try{

if(connection != null) {

connection.rollback();//事务回滚

connection.setAutoCommit(true);//让程序自动提交事务(默认)

}

} catch(SQLException e1) {

e1.printStackTrace();

}

} catch(Exception e) {

e.printStackTrace();

System.out.println("其他异常！");

}finally {

try{

if (stmt!= null) {

stmt.close();

stmt =null;

}

if(connection != null) {

connection.close();

connection =null;

}

} catch(SQLException e2) {

System.out.println("关闭数据库时出现异常！");

}

}

}

}