UE4MySQL数据库插件开发-mysql数据库连接（三）

手可摘星辰0120

已于 2022-01-26 17:06:07 修改

阅读量3.9k

点赞数 1

文章标签： mysql 数据库 ue4

于 2022-01-22 20:47:22 首次发布

本文链接：https://blog.youkuaiyun.com/u014577128/article/details/122642899

版权

1.在Visual Studio中打开我们以前创建MyConnectionObject.h和MyConnectionObject.cpp文件。然后引入头文件，添加如下所示代码。

MyConnectionObject.h文件

#pragma once
 
#include "CoreMinimal.h"
#include "UObject/NoExportTypes.h"
//引入mysql头文件
#include "mysql.h"
#include "MyConnectionObject.generated.h"
 
/**
 *数据库连接对象类
 */
UCLASS(BlueprintType)//声明为蓝图类型的类
class TESTMYSQL_API UMyConnectionObject : public UObject
{
	GENERATED_BODY()
private:
    //声明私有构造函数
    UMyConnectionObject();
public:
    //声明MySQL连接对象
    MYSQL* Conn;
};

MyConnectionObject.cpp文件

 
#include "MyConnectionObject.h"
 
 
UMyConnectionObject::UMyConnectionObject()
{
	//初始化连接对象
	Conn = nullptr;
}

2.打开SqlBlueprintFunctionLibrary.h和SqlBlueprintFunctionLibrary.cpp文件，添加如下所示代码。

SqlBlueprintFunctionLibrary.h文件

#pragma once
 
#include "CoreMinimal.h"
#include "Kismet/BlueprintFunctionLibrary.h"
//引入mysql头文件
#include "mysql.h"
//引入数据库连接对象头文件
#include "MyConnectionObject.h"
#include "SqlBlueprintFunctionLibrary.generated.h"
 
/**
 * 数据库连接类
 */
UCLASS(BlueprintType)//声明为蓝图类型
class TESTMYSQL_API USqlBlueprintFunctionLibrary : public UBlueprintFunctionLibrary
{
	GENERATED_BODY()
public:
    /**
     * 连接MySQL数据库函数
     */
    UFUNCTION(BlueprintCallable,Category="SQL Utilities")
    static UMyConnectionObject* ConnectToMySQL(FString Host,FString userName,FString Password,FString dbName,int32 Port,FString& Msg);
};

SqlBlueprintFunctionLibrary.cpp

#include "SqlBlueprintFunctionLibrary.h"
#include <string>
 
UMyConnectionObject* USqlBlueprintFunctionLibrary::ConnectToMySQL(FString Host, FString userName, FString Password, FString dbName, int32 Port, FString& Msg)
{
	//字符编码格式转换
	std::string t_Host(TCHAR_TO_UTF8(*Host));
	std::string t_userName(TCHAR_TO_UTF8(*userName));
	std::string t_Password(TCHAR_TO_UTF8(*Password));
	std::string t_dbName(TCHAR_TO_UTF8(*dbName));
	//数据库连接对象创建
	UMyConnectionObject* ConnObj = NewObject<UMyConnectionObject>();
	//初始化MYSQL连接对象
	ConnObj->Conn = mysql_init(nullptr);
	//判断连接状态，并返回相应信息
	if (!mysql_real_connect(ConnObj->Conn,t_Host.c_str(),t_userName.c_str(),t_Password.c_str(),t_dbName.c_str(),(uint32)Port,nullptr,0))
	{
		Msg = TEXT("fail");
	}
	else 
	{
		Msg = TEXT("success");
	}
	//返回数据库连接对象
	return ConnObj;
}