[大数据] UE MysqlConnect使用说明

开发: C++知识库 Java知识库 JavaScript Python PHP知识库人工智能区块链大数据移动开发嵌入式开发工具数据结构与算法开发测试游戏开发网络协议系统运维
教程: HTML教程 CSS教程 JavaScript教程 Go语言教程 JQuery教程 VUE教程 VUE3教程 Bootstrap教程 SQL数据库教程 C语言教程 C++教程 Java教程 Python教程 Python3教程 C#教程
数码: 电脑笔记本显卡显示器固态硬盘硬盘耳机手机 iphone vivo oppo 小米华为单反装机图拉丁

-> 大数据 -> UE MysqlConnect使用说明 -> 正文阅读

[大数据]UE MysqlConnect使用说明

在这里插入图片描述

Features:

Execute using query statement （example： select * from tableName）

Support C++ or pure blueprint calls

Synchronous and asynchronous support

Support MYSQL 5.x.x - 8.x.x series

used in C++

/// synchronous connection example ///

Mysql = UMysqlConnectSubsystem::Get();
Results = NewObject<UMysqlResult>();

Mysql->Connect("127.0.0.1", 3306, "username", "pw", "TableName", Results);
if (!Results->IsSucceed)
{
	UE_LOG(LogTemp, Warning, TEXT("MYSQL: ConnectError: %s"), *Results->Msg);
	return;
}

//Get the total number of rows
Mysql->Query("SELECT count(1) FROM `testtable`", Results);
UE_LOG(LogTemp, Warning, TEXT("MYSQL: Count: IsSucceed = %d, msg = %s, count = %d"), Results->IsSucceed, *Results->Msg, Results->getCount());

//get row
Mysql->Query("SELECT * FROM `testtable`", Results);
UE_LOG(LogTemp, Warning, TEXT("MYSQL: rows: IsSucceed = %d, msg = %s, Num = %d"), Results->IsSucceed, *Results->Msg, Results->getRows().Num());

/// Asynchronous connection example ///

Mysql = UMysqlConnectSubsystem::Get();
Results = NewObject<UMysqlResult>();

const FLatentActionInfo LatentInfo(0, FMath::Rand(), TEXT("ConnectCallback"), this);
Mysql->AConnect("127.0.0.1", 3306, "username", "pw", "TableName", Results, this, LatentInfo);

//Asynchronous callback function
void APluginProjectGameModeBase::ConnectCallback()
{
    if (!Results->IsSucceed)
    {
        UE_LOG(LogTemp, Warning, TEXT("MYSQL: ConnectError: %s"), *Results->Msg);
        return;
    }

    //Get the total number of rows
    const FLatentActionInfo LatentInfo(0, FMath::Rand(), TEXT("fetch_count_Callback"), this);
    Mysql->AQuery("SELECT count(1) FROM `testtable`", Results, this, LatentInfo);
}

//Asynchronous callback function
void APluginProjectGameModeBase::fetch_count_Callback()
{
    UE_LOG(LogTemp, Warning, TEXT("MYSQL: Count: IsSucceed = %d, msg = %s, count = %d"), Results->IsSucceed, *Results->Msg, Results->getCount());

    //get row
    const FLatentActionInfo LatentInfo(0, FMath::Rand(), TEXT("fetch_rows_Callback"), this);
    Mysql->AQuery("SELECT * FROM `testtable`", Results, this, LatentInfo);
}

//Asynchronous callback function
void APluginProjectGameModeBase::fetch_rows_Callback()
{
    UE_LOG(LogTemp, Warning, TEXT("MYSQL: rows: IsSucceed = %d, msg = %s, Num = %d"), Results->IsSucceed, *Results->Msg, Results->getRows().Num());
}