jdbc事务处理(commit rollback)

最新推荐文章于 2025-02-06 14:19:11 发布

原创最新推荐文章于 2025-02-06 14:19:11 发布 · 1w 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#jdbc #exception #string #database #insert #null

数据库同时被 2 个专栏收录

9 篇文章

订阅专栏

java语言

9 篇文章

订阅专栏

本文展示了一个使用Java进行SQL数据库操作的例子，重点介绍了如何在出现异常时回滚数据库事务，确保数据一致性。通过创建订单及其详细信息的过程，演示了连接设置、插入操作及异常处理等关键步骤。

package org.kodejava.example.sql; import java.sql.*; public class TransactionRollbackExample { public static void main(String[] args) throws Exception { String url = "jdbc:mysql://localhost/testdb"; String username = "root"; String password = ""; Connection conn = null; try { Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection(url, username, password); conn.setAutoCommit(false); StringBuilder sb = new StringBuilder("INSERT INTO orders (username, order_date) " + "VALUES ('javaduke', '2007-12-13')"); Statement orderStmt = conn.createStatement(); orderStmt.execute(sb.toString(), Statement.RETURN_GENERATED_KEYS); ResultSet keys = orderStmt.getGeneratedKeys(); int id = 1; while (keys.next()) { id = keys.getInt(1); } String insertDetail = "INSERT INTO order_details (order_id, product_id, quantity, price) " + "VALUES (?, ?, ?, ?)"; PreparedStatement detailStmt = conn.prepareStatement(insertDetail); detailStmt.setInt(1, id); detailStmt.setString(2, "P0000001"); detailStmt.setInt(3, 10); detailStmt.setDouble(4, 100); detailStmt.execute(); // // Commit transaction to mark it as a success database operation // conn.commit(); System.out.println("Transaction commit..."); } catch (SQLException e) { // // Rollback any database transaction due to exception occured // if (conn != null) { conn.rollback(); System.out.println("Connection rollback..."); } e.printStackTrace(); } finally { if (conn != null && !conn.isClosed()) { conn.close(); } } } }