UE4 使用Sqlite

配置

1. 启用SqlSupport插件
2. Build.cs 添加

PublicDependencyModuleNames.AddRange(newstring[]{ "Core","CoreUObject","Engine","InputCore","SQLiteSupport"});

查询例

1. 头文件定义函数

//Path数据库路径，SqlQuery查询语句，Items查询返回结果。FSqliteDataTable

UFUNCTION(BlueprintCallable,Category="SqliteDatabase")

boolLoadSqlAsTable(FStringPath,FStringSqlQuery,TArray<FSqliteDataTable>&Items);

1. Cpp

引入头文件

#include"SQLiteDatabaseConnection.h"

 

函数实现

boolASqliteActor::LoadSqlAsTable(FStringPath,FStringSqlQuery,TArray<FSqliteDataTable>&Items)

{

FSQLiteDatabaseConnectiondb;

//连接数据库

Path=*