mysql事物处理代码_数据库 事务处理

[c++]代码库#include "stdafx.h"

using namespace System;

using namespace System::Data;

using namespace System::Data::OleDb;

ref struct MyEventHandler

{

static void RowUpdated(Object^ sender, OleDbRowUpdatedEventArgs^ e)

{

if ( e->Status == UpdateStatus::ErrorsOccurred )

throw "Row update failed!";

}

};

void main()

{

OleDbConnection^ myConnection = nullptr;

OleDbTransaction^ myTransaction = nullptr;

try

{

myConnection = gcnew OleDbConnection(

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Music.mdb");

myConnection->Open();

OleDbDataAdapter^ dataAdapter = gcnew OleDbDataAdapter(

"SELECT * FROM Music", myConnection);

OleDbCommandBuilder^ commandBuilder = gcnew OleDbCommandBuilder(dataAdapter);

dataAdapter->UpdateCommand = commandBuilder->GetUpdateCommand();

dataAdapter->RowUpdated += gcnew OleDbRowUpdatedEventHandler(MyEventHandler::RowUpdated);

DataSet^ myDataSet = gcnew DataSet();

dataAdapter->MissingSchemaAction = MissingSchemaAction::AddWithKey;

dataAdapter->Fill(myDataSet);

myTransaction = myConnection->BeginTransaction();

DataTable^ myTable = myDataSet->Tables[0];

DataRow^ row = myTable->Rows->Find("Automatic");

if ( row != nullptr )

row["Title"] = "Automatic (Dance Mix)";

row = myTable->Rows->Find("EnTrance");

if ( row != nullptr )

row["GenreName"] = "Trance";

dataAdapter->Update(myDataSet);

myTransaction->Commit();

}

catch(Exception^ e)

{

Console::WriteLine(e->Message);

if ( myTransaction != nullptr )

{

myTransaction->Rollback();

Console::WriteLine("Transaction rolled back.");

}

}

finally

{

myConnection->Close();

}

}