TestTransation

import java.sql.*;public class TestTransation {//JDBC的"事务处理"--非常严谨的代码public static void main(String[] args) throws Exception {Connection connect = null;Statement stmt = null; try {Class.forName("com.mysql.jdbc.Driver");String url = "jdbc:mysql://localhost:3306/test";String name = "java";String password = "123";connect = DriverManager.getConnection(url, name, password);connect.setAutoCommit(false);//1-设置成false，不让它自动提交。stmt = connect.createStatement();//2-然后做sql操作。stmt.addBatch("insert into user values (30,'1000元')");stmt.addBatch("insert into user values (31,'2000元')");stmt.addBatch("insert into user values (32,'5000元')");stmt.executeBatch();connect.commit();//3-操作完之后，手动提交。connect.setAutoCommit(true);//4-恢复现场，再把提交设置成true} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {//5-捕捉到的任何的SQLException，要记得rollback。e.printStackTrace();try{if(connect !=null){connect.rollback();connect.setAutoCommit(true);}}catch(SQLException e1){e1.printStackTrace();}} finally {try {if (stmt != null) {stmt.close();stmt = null;}if (connect != null) {connect.close();connect = null;}} catch (SQLException e) {e.printStackTrace();}}}}