Spring框架中的默认隔离级别

Spring框架中的默认隔离级别及案例演示

java
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@Service
public class BankService {
    @Autowired
    private JdbcTemplate jdbcTemplate;
    @Transactional
    public void withdrawAmount(int accountId, double amount) {
        double currentBalance = jdbcTemplate.queryForObject("SELECT balance FROM accounts WHERE id = ?", Double.class, accountId);
        if (currentBalance >= amount) {
            jdbcTemplate.update("UPDATE accounts SET balance = balance - ? WHERE id = ?", amount, accountId);
        } else {
            throw new InsufficientFundsException("Insufficient funds for withdrawal");
        }
    }
}

java
public class ConcurrentTransactionExample {
    public static void main(String[] args) {
        BankService bankService = /* ... initialize BankService bean ... */;
        Runnable withdrawTask = () -> {
            try {
                bankService.withdrawAmount(1, 50.0);
            } catch (InsufficientFundsException e) {
                System.out.println("Transaction failed: " + e.getMessage());
            }
        };
        // Create two threads to simulate concurrent transactions
        Thread thread1 = new Thread(withdrawTask);
        Thread thread2 = new Thread(withdrawTask);
        // Start both threads
        thread1.start();
        thread2.start();
    }
}