JDBC处理Transaction

package jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class JDBCTest {/** * @param args */private static final String URL="jdbc:mysql://localhost:3306/jdbc";private static final String DRIVER="com.mysql.jdbc.Driver";private static final String USER="root";private static final String PASSWORD="123";public static void main(String[] args) {Connection conn=null;Statement stmt=null;ResultSet rs=null;try{Class.forName(DRIVER);conn=DriverManager.getConnection(URL, USER, PASSWORD);conn.setAutoCommit(false);stmt=conn.createStatement();stmt.addBatch("insert into enum values(1,'a','a1');");stmt.addBatch("insert into enum values(2,'b','b1');");stmt.addBatch("insert into enum values(3,'c','c1');");stmt.executeBatch();conn.setAutoCommit(true);}catch(ClassNotFoundException e) {e.printStackTrace();}catch(SQLException e){try{if(conn!=null) {conn.rollback();conn.setAutoCommit(true);}}catch(SQLException e1) {e1.printStackTrace();}e.printStackTrace();}finally {try{if(stmt!=null) {stmt.close();stmt=null;}if(conn!=null) {conn.close();conn=null;}}catch(SQLException e) {e.printStackTrace();}}}}