JDBC事务处理

Java事务处理事例

A账户向B账户转1000元

t_bank表

JDBCDemo04

package JDBCTest2;

import com.mysql.jdbc.PreparedStatement;
import utils.JDBCUtils;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JDBCDemo04 {
    /**
     * jdbc事务处理
     * A账户向B账户转1000
     */
    public static void main(String[] args) {
        Connection connection=null;
        PreparedStatement preparedStatement=null;
        ResultSet resultSet=null;
        try {
            //获取连接
            connection = JDBCUtils.getConnection();
            //设置成手动提交
            connection.setAutoCommit(false);
            String sql="update t_bank set balance=balance- ? where bname=?";
            //获取数据库操作对象
            preparedStatement =
                    (PreparedStatement) connection.prepareStatement(sql);

            preparedStatement.setDouble(1,1000);
            preparedStatement.setString(2,"A");

            //返回结果集
            int num = preparedStatement.executeUpdate();
            System.out.println(num);

            String sql2="update t_bank set balance=balance+ ? where bname=?";
            //获取数据库操作对象
            preparedStatement =
                    (PreparedStatement) connection.prepareStatement(sql2);
            preparedStatement.setDouble(1,1000);
            preparedStatement.setString(2,"B");
            int num2 = preparedStatement.executeUpdate();
            System.out.println(num2);

            //事务提交
            connection.commit();
        } catch (Exception e) {
            try {
                //如果捕获到异常，就让当前事务回滚到最近的状态
                connection.rollback();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
            e.printStackTrace();
        }finally {
            JDBCUtils.getClose(connection,preparedStatement,resultSet);
        }
    }
}