public class ShiWu { public static void main(String[] args) { //连接,连接池; Connection connection = JdbcUtil.getConnection(); try { //1.关闭自动提交 connection.setAutoCommit(false); //2.更新的sql语句 String sql = "update work set age= age-3 where id = ?"; //3.调用预处理搬运工 PreparedStatement preparedStatement = connection.prepareStatement(sql); //4.设置参数,并赋值 preparedStatement.setObject(1, 1); //执行语句 int i = preparedStatement.executeUpdate(); System.out.println(i); // int i2 = 10 / 0; //更新sql的语句 String sql1 = "update work set age= age+3 where id = ?"; PreparedStatement preparedStatement1 = connection.prepareStatement(sql1); preparedStatement1.setObject(1, 2); int i1 = preparedStatement1.executeUpdate(); System.out.println(i1); connection.commit(); } catch (SQLException e) { try { //如果抛出异常,返回原数据据。 connection.rollback(); } catch (SQLException ex) { ex.printStackTrace(); } } catch (Exception e) { e.printStackTrace(); } } }
JDBC中的事务,原子性,详解
最新推荐文章于 2024-10-17 10:27:13 发布