在SQL Server数据库中，C++可以使用ODBC（Open Database Connectivity）接口来进行事务处理。以下是一个简单的示例代码，演示如何在C++中使用ODBC接口来执行SQL事务处理：
#include <windows.h>#include <sql.h>#include <sqlext.h>#include <iostream>int main() { SQLHENV henv; SQLHDBC hdbc; SQLHSTMT hstmt; SQLRETURN retcode; // Allocate environment handle retcode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv); if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO) { std::cerr << "Error allocating environment handle" << std::endl; return -1; } // Set ODBC version retcode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER) SQL_OV_ODBC3, 0); if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO) { std::cerr << "Error setting ODBC version" << std::endl; return -1; } // Allocate connection handle retcode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc); if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO) { std::cerr << "Error allocating connection handle" << std::endl; return -1; } // Connect to database retcode = SQLConnect(hdbc, (SQLCHAR*)"YOUR_DSN", SQL_NTS, (SQLCHAR*)"USERNAME", SQL_NTS, (SQLCHAR*)"PASSWORD", SQL_NTS); if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO) { std::cerr << "Error connecting to database" << std::endl; return -1; } // Allocate statement handle retcode = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt); if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO) { std::cerr << "Error allocating statement handle" << std::endl; return -1; } // Begin transaction retcode = SQLEndTran(SQL_HANDLE_DBC, hdbc, SQL_COMMIT); if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO) { std::cerr << "Error beginning transaction" << std::endl; return -1; } // Execute SQL statements within the transaction retcode = SQLExecDirect(hstmt, (SQLCHAR*)"INSERT INTO TABLE_NAME (COLUMN1, COLUMN2) VALUES (VALUE1, VALUE2)", SQL_NTS); if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO) { std::cerr << "Error executing SQL statement" << std::endl; return -1; } // Commit transaction retcode = SQLEndTran(SQL_HANDLE_DBC, hdbc, SQL_COMMIT); if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO) { std::cerr << "Error committing transaction" << std::endl; return -1; } // Free statement handle SQLFreeHandle(SQL_HANDLE_STMT, hstmt); // Disconnect from database retcode = SQLDisconnect(hdbc); if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO) { std::cerr << "Error disconnecting from database" << std::endl; return -1; } // Free connection handle SQLFreeHandle(SQL_HANDLE_DBC, hdbc); // Free environment handle SQLFreeHandle(SQL_HANDLE_ENV, henv); return 0;}在上面的示例中，我们首先分配了环境句柄、连接句柄和语句句柄，然后连接到数据库，并开始一个事务。接下来执行SQL语句并提交事务。最后释放句柄并断开与数据库的连接。请确保将YOUR_DSN、USERNAME、PASSWORD、TABLE_NAME、COLUMN1、COLUMN2、VALUE1和VALUE2替换为实际的值。
这只是一个简单的示例，实际情况可能会更复杂。建议参考ODBC文档和SQL Server的文档以获取更多关于ODBC接口和事务处理的信息。
