用SavePoint实现事务处理(转自中国java开发论坛)

最新推荐文章于 2024-09-28 12:43:14 发布

转载最新推荐文章于 2024-09-28 12:43:14 发布 · 1.2k 阅读

文章标签：

#java #insert #query #null #url

博客展示了Java代码实现数据库操作。通过Class.forName加载驱动，DriverManager获取连接，创建Statement对象执行插入语句。还设置了保存点，可进行回滚操作，最后提交事务，体现了Java在数据库操作及事务处理方面的应用。

Class.forName(driver).newInstance();
connection = DriverManager.getConnection(url,username,password);
DriverManager.setLogStream(System.out); // for debuging
connection.setAutoCommit(false);
//create a statement
stmt = connection.createStatement();
//execute a query
stmt.executeUpdate("insert into tickets values ('ivana', 'NY', 'BOSTON', '11-July-2002', '9:00 AM', 'Delta 782')");
stmt.executeUpdate("insert into tickets values ('ivana', 'BOSTON', 'CANCUN', '11-July-2002', '12:00 PM', 'Delta 819')");
txpoint = connection.setSavepoint("oneway"); // establish a save point

stmt.executeUpdate("insert into tickets values ('ivana', 'CANCUN', 'NY', '12-August-2002', '2:00 PM', 'Delta 820')");
stmt.executeUpdate("insert into tickets values ('ivana', 'NY', 'BOSTON', '12-August-2002', '6:00 PM', 'Delta 783')");

// for demo purposes in case there are no exceptions
if (forseoneway && (txpoint != null) )
connection.rollback(txpoint);

connection.commit();

setTransactionIsolation