JDBC中处理事务（SXT）

 JDBC中处理事务（SXT）

 

Demo

1. import java.sql.*;
3. public class TestTransaction
4. {
6.     /**
7.      * @JDBC中处理事务
8.      */
9.     public static void main(String[] args)
10.     {
11.         // 1.不用PreparedStatement
13.         Connection conn = null;
14.         Statement stmt = null;
15.         String url = "jdbc:mysql://localhost:3306/college";
16.         String user = "root";
17.         String password = "123456";
19.         try
20.         {
21.             Class.forName("com.mysql.jdbc.Driver");
22.             conn = DriverManager.getConnection(url, user, password);
24.             conn.setAutoCommit(false);
26.             stmt = conn.createStatement();
27.             stmt.addBatch("insert into user values(301,'go1','123','0')");
28.             stmt.addBatch("insert into user values(302,'go2','1234','00')");
29.             stmt.addBatch("insert into user values(303,'go3','12345','000')");
31.             stmt.executeBatch();
33.             conn.commit();
34.             conn.setAutoCommit(true);
36.         } catch (ClassNotFoundException e)
37.         {
38.             // TODO Auto-generated catch block
39.             e.printStackTrace();
40.         } catch (SQLException e)
41.         {
42.             e.printStackTrace();
44.             try
45.             {
46.                 if (conn != null)
47.                 {
48.                     conn.rollback();
49.                     conn.setAutoCommit(true);
50.                 }
51.             } catch (SQLException e1)
52.             {
53.                 // TODO Auto-generated catch block
54.                 e1.printStackTrace();
55.             }
56.         } finally
57.         {
58.             try
59.             {
60.                 if (stmt != null)
61.                 {
62.                     stmt.close();
63.                     stmt = null;
64.                 }
65.                 if (conn != null)
66.                 {
67.                     conn.close();
68.                     conn = null;
70.                 }
72.             } catch (SQLException e)
73.             {
74.                 // TODO Auto-generated catch block
75.                 e.printStackTrace();
76.             }
77.         }
79.     }
81. }