一、下载SQLite所需文件
1、下载网址:
2、找到:
Precompiled Binaries for Windows
3、找到:
64-bit DLL (x64) for SQLite version 3.43.1.
4、下载完文件之后,解压并把它们两个文件复制到Unity项目文件夹中的插件文件夹
如:E:\UnityProject\cloud_disk\Assets\Plugins
即 项目文件路径\Assets\Plugins
二、复制Unity所需文件
1、寻找Unity编辑器安装目录
如:
C:\Program Files\Unity\Hub Editor 2019.4.2f1 Editor\Data\MonoBleedingEdge\llib\mono\unityiit
或者(我的):
D:\Program Files\Unity\Editor\Unity 2021.3.16f1\Editor\Data\MonoBleedingEdge\lib\mono\unityjit-win32
2、将其复制到Unity项目文件夹中的插件文件夹
如:E:\UnityProject\cloud_disk\Assets\Plugins
即 项目文件路径\Assets\Plugins
三、使用命名空间
using UnityEngine;
using Mono.Data.Sqlite;
using System.IO;
四、尝试创建数据库表格
private string Full_databasePath; //全路径
private SqliteConnection connection;
private SqliteCommand command;
private string databasePath = "SilverGameUser.db"; //数据库路径
public bool IsConnectionEstablished = false;
//##############################
//数据库环境搭建
//##############################
private void Start()
{
Full_databasePath = Application.dataPath + databasePath;
CreateFile(Full_databasePath);
connection = new SqliteConnection($"URI=file:{Full_databasePath}");
connection.Open();
IsConnectionEstablished = true;
}
public void CreateFile(string DbFilePath)
{
if (!File.Exists(DbFilePath))
{
SqliteConnection.CreateFile(DbFilePath);
//Debug.Log($"SQLite数据库文件已创建:{DbFilePath}");
}
else
{
//Debug.Log($"SQLite数据库文件已存在:{DbFilePath}");
}
}
public bool CheckAndExitIfTableEmpty()
{
string countQuery = "SELECT COUNT(*) FROM users_information";
command = new SqliteCommand(countQuery, connection);
int recordCount = Convert.ToInt32(command.ExecuteScalar());
if (recordCount == 0) { return true; }
return false;
}