public class TestTranslation {
public static void main(String[] args) {
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try {
conn = JDBCUtils.getConn();
conn.setAutoCommit(false);//关闭自动提交开启事务
String sql = "update account set money = money+100 where id = 1";
String sql1 = "update account set money = money-100 where id = 2";
stmt = conn.prepareStatement(sql);
stmt.executeUpdate();
stmt = conn.prepareStatement(sql1);
stmt.executeUpdate();
conn.commit();//提交事务
System.out.println("成功!!");
} catch (SQLException e) {
try {
conn.rollback(); //事务失败默认会回滚,这里不写也会回滚!
} catch (SQLException ex) {
ex.printStackTrace();
}
e.printStackTrace();
}
finally {
JDBCUtils.release(conn,stmt,null);
}
}
}
使用JDBC编写事务
最新推荐文章于 2022-06-21 10:55:03 发布