Unity数据库的简单使用

下载地址：http://www.sqlite.org/download.html
　　将Precompiled Binaries for Windows下的包下载下来sqlite-dll-win64-x64-3150100.zip、sqlite-tools-win32-x86-3150100.zip
　　sqlite-dll-win64-x64-3150100.zip包含.def、.dll两个文件
sqlite-tools-win32-x86-3150100.zip包含三个执行文件exe
将它们一起解压到D:\sqlite文件夹，配置环境变量PATH后追加“D:\sqlite;”

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using Mono.Data.Sqlite;
public class SqliteTest : MonoBehaviour ｛
    void Start () ｛
        //打开数据库
        SqliteConnection con = new SqliteConnection("data source=" + Application.dataPath + "/data.db");
        con.Open();
        //创建表
        SqliteCommand cmd = new SqliteCommand("create table if not exists User(uid integer, name text)",con);
        //执行创建表命令
        cmd.ExecuteNonQuery();
        cmd.Dispose();
        //插入一条数据
        cmd = new SqliteCommand("insert into User values(1,'令狐冲')", con);
        //执行插入数据命令
        cmd.ExecuteNonQuery();
        cmd.Dispose();
        //查询当前几条结果
        cmd = new SqliteCommand("select count(*) from User", con);
        object obj = cmd.ExecuteScalar();
        int count = System.Convert.ToInt32(obj);
        Debug.Log("count:" + count);
        cmd.Dispose();
        //查询数据
        cmd = new SqliteCommand("select * from User",con);
        SqliteDataReader reader = cmd.ExecuteReader();
        /*
         1 令狐冲
         2 岳不群
         3 任盈盈
         */
        while (reader.Read())
        ｛
            //取出第一列
            int uid = reader.GetInt32(0);
            //取出第二列
            string name = reader.GetString(1);
            Debug.Log(uid + " " + name);
        ｝
        cmd.Dispose();
        reader.Close();
        con.Close();
    ｝
    void test()
    ｛
        SqliteManager.Instance.Open(Application.dataPath + "/data.db");
        //创建表
        SqliteManager.Instance.ExecuteNonQuery("create table if not exists User(uid integer, name text)");
        //插入一条数据
        SqliteManager.Instance.ExecuteNonQuery("insert into User values(2,'岳不群')");
        //查询
        SqliteDataReader reader = SqliteManager.Instance.ExecuteReader("select * from User");
        //....
        reader.Close();
        SqliteManager.Instance.Close();
    ｝
｝

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using Mono.Data.Sqlite;
public class SqliteManager : MonoBehaviour ｛
    public static SqliteManager Instance;
    SqliteConnection con;
    SqliteCommand cmd;
    SqliteDataReader reader;
    void Awake () ｛
        Instance = this;
    ｝
    //打开数据库
    public void Open(string fileName)
    ｛
        con = new SqliteConnection("data source=" + fileName);
        con.Open();
    ｝
    //关闭数据库
    public void Close()
    ｛
        con.Close();
    ｝
    //执行增删改
    public int ExecuteNonQuery(string command)
    ｛
        cmd = new SqliteCommand(command, con);
        int count = cmd.ExecuteNonQuery();
        cmd.Dispose();
        return count;
    ｝
    //执行查
    public SqliteDataReader ExecuteReader(string command)
    ｛
        cmd = new SqliteCommand(command, con);
        reader = cmd.ExecuteReader();
        cmd.Dispose();
        return reader;
    ｝
｝