Java-JDBC操作事务

Java-JDBC操作事务

1、开启事务（关闭自动提交则默认开启事务）

conn.setAutoCommit(false);

2、一组业务执行完毕，提交事务

conn.commit();

3、可以在catch语句中显示的定义回滚语句，但默认失败就会回滚

conn.rollback();

示例：

package com.test.third;

import com.test.second.JdbcUtils;

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

public class TransactionTest {

    public static void main(String[] args) {

        Connection conn = null;
        PreparedStatement st = null;
        ResultSet rs = null;

        try {
            conn = JdbcUtils.getConnection();
            // 关闭自动提交（开启事务）
            conn.setAutoCommit(false);

            String sql1 = "update `account` set money = money - ? where `id` = ?";
            st = conn.prepareStatement(sql1);
            st.setInt(1,100);
            st.setInt(2,1);
            st.executeUpdate();

            String sql2 = "update `account` set money = money + ? where `id` = ?";
            st = conn.prepareStatement(sql2);
            st.setInt(1,100);
            st.setInt(2,2);
            st.executeUpdate();

            // 提交事务
            conn.commit();
            System.out.println("构建成功");
        } catch (SQLException e) {
            try {
                // 失败则回滚
                conn.rollback();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
            e.printStackTrace();
        } finally {
            JdbcUtils.release(conn,st,rs);
        }
    }
}