UE5连接SQL数据库

qq_616086886

已于 2022-06-05 16:45:57 修改

阅读量3.4k

点赞数 1

CC 4.0 BY-SA版权

文章标签： ue5 sql 服务器

于 2022-06-05 16:45:04 首次发布

本文链接：https://blog.youkuaiyun.com/qq_39447679/article/details/125133669

本文档详细介绍了如何在Unreal Engine中安装和使用SqlConnect插件进行数据库连接。该插件支持本地SQL服务器和云数据库（如Azure Database for SQL），并提供了C++和蓝图的同步及异步调用方式。通过示例代码，展示了如何进行数据库的连接、查询及获取数据行数等操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、安装 Sql Connect 插件
Install the Sql Connect plugin

https://www.unrealengine.com/marketplace/zh-CN/product/d1e931c9fb2a459ea2f33a12823e830a

2、使用插件
Use plugins

在这里插入图片描述

Features:（产品特点）

Support local SQL server and cloud database connection (eg: Azure Database for SQL)
支持本地SQL服务器和云数据库连接（例如：Azure Database for SQL）

Support C++ or pure blueprint calls
支持 C++ 或纯蓝图调用

Synchronous and asynchronous support
同步和异步支持

used in C++（在 C++ 中使用）

/////////////////////////// synchronous connection example（同步连接示例） ///////////////////////////////

sql = USqlConnectSubsystem::Get();
Results = NewObject<USqlResult>();

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

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

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

/////////////////////////// Asynchronous connection example（异步连接示例） ///////////////////////////////

sql = USqlConnectSubsystem::Get();
Results = NewObject<USqlResult>();

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

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

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

//Asynchronous callback function
void APluginProjectGameModeBase::fetch_count_Callback()
{
    UE_LOG(LogTemp, Warning, TEXT("SQL: 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);
    sql->AQuery("SELECT * FROM `testtable`", Results, this, LatentInfo);
}

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