java中事务代码大全,java JDBC使用事务示例，javajdbc事务示例,下面代码演示如何使用JD...

ゞ浴缸里的玫瑰 2023-01-13 09:21 144阅读 0赞

java JDBC使用事务示例，javajdbc事务示例,下面代码演示如何使用JD

下面代码演示如何使用JDBC的事务。JDBC事务操作需要在执行操作之前调用Connection类的setAutoCommit(false)方法。

在执行完操作之后，需要调用Connection实例的commit()方法来提交事务。

下面是示例代码：import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;/\*\* \* \* @author byrx.net \*/public class Main \{ /\*\* \* 事务使用示例 \*/ public void updateDatabaseWithTransaction() \{ Connection connection = null; Statement statement = null; try \{ Class.forName("\[nameOfDriver\]"); connection = DriverManager.getConnection("\[databaseURL\]", "\[userid\]", "\[password\]"); //此处调用setAutoCommit(false)指定要在事务中提交 connection.setAutoCommit(false); statement = connection.createStatement(); //Execute the queries statement.executeUpdate("UPDATE Table1 SET Value = 1 WHERE Name = 'foo'"); statement.executeUpdate("UPDATE Table2 SET Value = 2 WHERE Name = 'bar'"); //No changes has been made in the database yet, so now we will commit //the changes. connection.commit(); \} catch (ClassNotFoundException ex) \{ ex.printStackTrace(); \} catch (SQLException ex) \{ ex.printStackTrace(); try \{ //An error occured so we rollback the changes. connection.rollback(); \} catch (SQLException ex1) \{ ex1.printStackTrace(); \} \} finally \{ try \{ if (statement != null) statement.close(); if (connection != null) connection.close(); \} catch (SQLException ex) \{ ex.printStackTrace(); \} \} \} /\*\* \* @param args the command line arguments \*/ public static void main(String\[\] args) \{ new Main().updateDatabaseWithTransaction(); \}\}