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

直接上代码:

package cn.zhou.epet.test;

import java.sql.*;

public class Addbatch {

public static 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("insert into 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("关闭数据库时出现异常！");

}

}

}

}