Java JDBC 开启事务
Java 事务 JDBC About 1,108 words代码
connection.setAutoCommit(false);
:开启事务。
connection.commit();
:提交事务。
connection.rollback();
:回滚事务。
boolean autoCommit = connection.getAutoCommit();
:是否开启食物。
public static void main(String[] args) throws Exception {
ResourceBundle bundle = ResourceBundle.getBundle("jdbc");
String user = bundle.getString("user");
String password = bundle.getString("password");
String url = bundle.getString("url");
String driverClass = bundle.getString("driverClass");
Class.forName(driverClass);
Connection connection = DriverManager.getConnection(url, user, password);
System.out.println(connection);
// 开启事务
connection.setAutoCommit(false);
// boolean autoCommit = connection.getAutoCommit();
String sql = "update test set name = ? where id = ?";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setObject(1, "abc");
preparedStatement.setObject(2, 1);
int row = preparedStatement.executeUpdate();
connection.commit();
// connection.rollback();
preparedStatement.close();
connection.close();
}
Views: 2,700 · Posted: 2022-06-02
————        END        ————
Give me a Star, Thanks:)
https://github.com/fendoudebb/LiteNote扫描下方二维码关注公众号和小程序↓↓↓
Loading...