Unity Sqlite Setup

最新推荐文章于 2023-10-11 13:05:09 发布

原创最新推荐文章于 2023-10-11 13:05:09 发布 · 729 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#unity #SQLite #setup

本文详细介绍了在Unity项目中如何找到并使用Mono.Data.SqliteClient.dll和System.Data.dll文件，创建名为Test的类进行数据库操作，并在根目录下生成danny.db文件。此外，还提供了下载Navicat Premium进行数据库文件内容查看的方法。

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

1. Find two files "Mono.Data.SqliteClient.dll" and "System.Data.dll" in local unity directory and put them in the project Assets folder. (two files can also be downloaded from: http://vdisk.weibo.com/s/abG7k )

2. create Test.cs and bind it to camera. After running, "danny.db" is in root directory of the project.

using UnityEngine;

using System.Collections;
public class Test : MonoBehaviour
{
void Start ()
{
DbAccess db = new DbAccess("data source=danny.db");
db.CreateTable("dick",new string[]{"name","height","email","blog"}, new string[]{"text","text","text","text"});
db.InsertInto("dick", new string[]{ "'danny'","'183'","'dannykong713@gmail.com'","'www.danny.com'" });
db.CloseSqlConnection();
}

}

3. (optional) download "Navicat Premium", use it to see content of db file.