写一个unity 使用sqlite存储数据。
当前使用unity版本:2019.3.5。
一开始找了很多的资料,需要Mono.Data.Sqlite.dll,System.Data.dll,Sqlite3.dll3个dll.但是我当前的版本不需要System.Data.dll。而且在当前版本的mono文件下找到的Mono.Data.Sqlite.dll,使用起来会报错。最后我去2018的unity安装目录下找了Mono.Data.Sqlite.dll(Editor\Data\Mono\lib\mono\2.0\ Mono.Data.Sqlite.dll)就不报错了。其他大神关于unity 使用sqlite教程。
sqlite.dll下载 x86 和 x64 架构
之后将dll放入到assets/pludins文件夹下。
建立数据库,我将数据库放在了streamingAssets下
using UnityEngine;
using System.Collections;
using Mono.Data.Sqlite;
using System;
public class SQLite
{
public SqliteConnection connection;
private SqliteCommand command;
public SQLite(string path)
{
try
{
connection = new SqliteConnection(path); // 创建SQLite对象的同时,创建SqliteConnection对象
connection.Open(); // 打开数据库链接
Debug.Log("Connect successful!");
Command();
}
catch (Exception ex)
{
Debug.Log(ex.Message);
}
}
public SqliteCommand Command()
{
command = connection.CreateCommand();
return command;
}
// 【增加数据】
public SqliteDataReader InsertData(string table_name, string[] fieldNames, object[] values)
{
// 如果字段的个数,和数据的个数不相等,无法执行插入的语句,所以返回一个null
if (fieldNames.Length != values.Length)
{
return null;
}
Debug.Log("table_name:" + table_name);
command.CommandText = "insert into " + table_name + "(";
for (int i = 0; i < fieldNames.Length; i++)
{
command.CommandText += fieldNames[i];
if (i < fieldNames.Length - 1)
{
command.CommandText += ",";
}
}
command.CommandText += ")" + "values (";
for (int i = 0; i < values.Length; i++)
{
command.CommandText += values[i];
if (i < values.Length - 1)
{
command.CommandText += ",";
}
}
command.CommandText += ")";
Debug.Log(command.CommandText);
return command.ExecuteReader();
}
// 【删除数据】
public SqliteDataReader DeleteData(string table_name, string[] conditions)
{
command.CommandText = "delete from " + table_name + " where " + conditions[0];
for (int i = 1; i < conditions.Length; i++)
{
// or:表示或者
// and:表示并且
command.CommandText += " or " + conditions[i];
}
return command.ExecuteReader();
}
// 【修改数据】
public SqliteDataReader UpdateData(string table_name, string[] values, string[] conditions)
{
command.CommandText = "update " + table_name + " set " + values[0];
for (int i = 1; i < values.Length; i++)
{
command.CommandText += "," + values[i];
}
command.CommandText += " where " + conditions[0];
for (int i = 1; i < conditions.Length; i++)
{
command.CommandText += " or " + conditions[i];
}
return command.ExecuteReader();
}
// 【查询数据】
public SqliteDataReader SelectData(string table_name, string[] fields)
{
command.CommandText = "select " + fields[0];
for (int i = 1; i < fields.Length; i++)
{
command.CommandText += "," + fields[i];
}
command.CommandText += " from " + table_name;
return command.ExecuteReader();
}
// 【查询整张表的数据】
public SqliteDataReader SelectFullTableData(string table_name)
{
command.CommandText = "select * from " + table_name;
return command.ExecuteReader();
}
// 【关闭数据库】
public void CloseDataBase()
{
connection.Close();
command.Cancel();
}
}
这里注意 连接数据库路径//需带'Data Source='前缀
using UnityEngine;
using System.Collections;
using Mono.Data.Sqlite;
public class Test : MonoBehaviour
{
// Use this for initialization
void Start()
{
// 数据库文件的具体路径,有的是.sqlite/.db
string path = "Data Source="+Application.streamingAssetsPath + "/" + "settingdata.db";
Debug.Log("path:" + path);
SQLite sql = new SQLite(path);
SqliteDataReader reader1 = sql.InsertData("ddd", new string[] { "name", "score" }, new object[] { "'Sivan'", 99 });
// 读取到的信息使用之后需要关闭
reader1.Close();
sql.CloseDataBase();
}
// Update is called once per frame
void Update()
{
}
}
亲测有效!!!