JAVA JDBC 数据库的一点记录:事务

JAVA JDBC 数据库的一点记录:事务

import java.sql.*; public class TestBatch { public static void main(String[] args) throws SQLException { Connection conn = null; Statement stmt = null; PreparedStatement pstmt = null; try { Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection ("jdbc:mysql://localhost/test","root","ZHEN"); conn.setAutoCommit(false); ////事务1 transaction stmt = conn.createStatement(); //执行静态 SQL 语句并返回它所生成结果的对象。 stmt.addBatch("INSERT INTO student VALUES(30,'ddd',12,'ii')"); stmt.addBatch("INSERT INTO student VALUES(31,'ddd',12,'ii')"); stmt.addBatch("INSERT INTO student VALUES(32,'ddd',12,'ii')"); stmt.addBatch("INSERT INTO student VALUES(33,'ddd',12,'ii')"); stmt.executeBatch(); /////事务2 pstmt = conn.prepareStatement("INSERT INTO student VALUES(?,?,?,?)"); pstmt.setInt(1, 40); pstmt.setString(2,"qq"); pstmt.setInt(3,5); pstmt.setString(4,"ww"); pstmt.addBatch(); pstmt.setInt(1, 41); pstmt.setString(2,"qq"); pstmt.setInt(3,5); pstmt.setString(4,"ww"); pstmt.addBatch(); pstmt.executeBatch(); /// conn.commit(); //若事务1 和事务2必需要同时完成 或 同时不完成,不能存在只有其中一个被完成的情况,则要用transaction }catch (ClassNotFoundException e1) { e1.printStackTrace(); }catch (SQLException e) { e.printStackTrace(); conn.rollback(); //若事务处理失则,必需回滚 conn.setAutoCommit(true); }finally{ stmt.close(); pstmt.close(); conn.close(); } } }