如何在 unity 3d 5 中连接 sqlite DB?(无插件) [英] how to connect a sqlite DB in unity 3d 5?(no plugins)

问题描述

您好，我正在使用 unity3d 5(c# 语言)开发一个 android 游戏项目，需要将一些数据保存到 sqlite 数据库.游戏没有很多数据来存储它只有 1 个表.有一些连接到 sqlite 的统一插件，但我不想使用它们.那么如何将我的数据统一存储在 sqlite 文件中?

解决方案

你可以找到你的答案

更多 SQLite 帮助访问:http://www.tutorialspoint.com/sqlite/>

Hello i'm working on an android game project in unity3d 5 (language c#)that needs to save some data to sqlite database. the game doesn't have a lot of data to store it has only 1 table .there are some plugins for unity that connect to sqlite but i don't want to use them . so how can i store my data on sqlite file in unity ?

解决方案

You can find your answer here

1. Create new folder under Assets Folder Rename it Plugins .
2. Copy sqlite3.def and sqlite3.dll into Assets/Plugins in your unity project .You can download these files here http://www.sqlite.org/download.html for windows (Precompiled Binaries for Windows)
3. Download SQLite Browser http://sourceforge.net/projects/sqlitebrowser/ or http://sqliteadmin.orbmu2k.de/ download SQLite Administrator tool
4. Create Database in Assets folder in your unity project using SQLite Browser.
5. Copy System.Data.dll and Mono.Data.Sqlite.dll from **C:Program Files (x86)Unity EditorDataMonolibmono2.0* and paste them in your Assets/Plugins* folder in your unity project.
6. Add these namespaces using Mono.Data.Sqlite; using System.Data; using System;
7. string conn= "URI=file:" + Application.dataPath + "/PickAndPlaceDatabase.s3db";

Replace PickAndPlaceDatabase.s3db with your database name

void Start () {
    string conn = "URI=file:" + Application.dataPath + "/PickAndPlaceDatabase.s3db"; //Path to database.
    IDbConnection dbconn;
    dbconn = (IDbConnection) new SqliteConnection(conn);
    dbconn.Open(); //Open connection to the database.
    IDbCommand dbcmd = dbconn.CreateCommand();
    string sqlQuery = "SELECT value,name, randomSequence " + "FROM PlaceSequence";
    dbcmd.CommandText = sqlQuery;
    IDataReader reader = dbcmd.ExecuteReader();
    while (reader.Read())
    {
        int value = reader.GetInt32(0);
        string name = reader.GetString(1);
        int rand = reader.GetInt32(2);

        Debug.Log( "value= "+value+"  name ="+name+"  random ="+  rand);
    }
    reader.Close();
    reader = null;
    dbcmd.Dispose();
    dbcmd = null;
    dbconn.Close();
    dbconn = null;
}

Further SQLite Help Visit : http://www.tutorialspoint.com/sqlite/

这篇关于如何在 unity 3d 5 中连接 sqlite DB?(无插件)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！