Java培训系列课程-批处理与事务处理（精品培训）.pptx

工程师培训资料标题：Java培训系列课程-批处理与事务处理（精品培训）培训人：xx本章学习目标了解JDBC的概念以及四种驱动分类；可以使用JDBC进行Oracle数据库的开发；可以使用DriverManager、Connection、PreparedStatement、ResultSet对数据库进行增、删、改、查操作；掌握事务的概念以及JDBC对事务的支持。批处理在Statement接口与PreparedStatement接口中有关于批处理操作的定义：Statement接口定义的方法：增加批处理语句：public void addBatch(String sql) throws SQLException；执行批处理：public int[] executeBatch() throws SQLException；返回的数组是包含了每条SQL语句的执行后所影响的数据行数；PreparedStatement接口定义的方法：增加批处理：public void addBatch() throws SQLException。范例：执行批处理（以Statement接口操作为例）public class TestDemo { private static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ; private static final String DBURL = "jdbc:oracle:thin:@localhost:1521:yootk" ; private static final String USER = "scott" ; private static final String PASSWORD = "tiger" ; public static void main(String[] args) throws Exception { Class.forName(DBDRIVER) ;// 加载驱动程序 Connection conn = DriverManager.getConnection(DBURL, USER, PASSWORD) ;// 连接数据库 Statement stmt = conn.createStatement() ;// 创建数据库操作对象 stmt.addBatch("INSERT INTO member(mid,name) VALUES (myseq.nextval,'优拓A')"); stmt.addBatch("INSERT INTO member(mid,name) VALUES (myseq.nextval,'优拓B')"); stmt.addBatch("INSERT INTO member(mid,name) VALUES (myseq.nextval,'优拓C')"); stmt.addBatch("INSERT INTO member(mid,name) VALUES (myseq.nextval,'优拓D')"); stmt.addBatch("INSERT INTO member(mid,name) VALUES (myseq.nextval,'优拓E')"); int result [] = stmt.executeBatch() ; // 执行批处理 System.out.println(Arrays.toString(result)); conn.close(); // 关闭数据库连接 }}JDBC事务控制JDBC提供的事务处理操作来进行手工的事务控制，所有的操作方法都在Connection接口里定义；事务提交：public void commit() throws SQLException；事务回滚：public void rollback() throws SQLException；设置是否为自动提交：public void setAutoCommit(boolean autoCommit) throws SQLException。范例：利用事务处理public class TestDemo { private static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ; private static final String DBURL = "jdbc:oracle:thin:@localhost:1521:yootk" ; private static final String USER = "scott" ; private static final String PASSWORD = "tiger" ; publi