Java 8服务器事务的代码示例

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

public class ServerTransactionExample {
    public static void main(String[] args) {
        Connection connection = null;
        try {
            // 连接数据库
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
            
            // 开启事务
            connection.setAutoCommit(false);
            
            // 执行一系列数据库操作
            PreparedStatement statement1 = connection.prepareStatement("INSERT INTO users (name, age) VALUES (?, ?)");
            statement1.setString(1, "John");
            statement1.setInt(2, 25);
            statement1.executeUpdate();
            
            PreparedStatement statement2 = connection.prepareStatement("UPDATE users SET age = ? WHERE name = ?");
            statement2.setInt(1, 30);
            statement2.setString(2, "John");
            statement2.executeUpdate();
            
            // 提交事务
            connection.commit();
            
            System.out.println("事务执行成功！");
        } catch (SQLException e) {
            // 回滚事务
            try {
                if (connection != null) {
                    connection.rollback();
                }
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
            
            System.out.println("事务执行失败！");
            e.printStackTrace();
        } finally {
            // 关闭数据库连接
            try {
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}