Unity連接本地數據庫sqlite

首先要創建一個sqlite的數據庫，記住文件地址，拷貝到Assets目錄下，創建的數據庫文件后綴為.sqlite。具體創建方法百度sqlite然后百度Mono.Data.Sqlite，這是一個dll文件，下載下來，同樣需要放到Assets目錄下接下來創建c#腳本，usingUnityEngine;usingSystem.Collections;usingMono.Data.Sqlite;usingSystem.IO;publicclassSQLiteDemo:MonoBehaviour{ stringsqlQuery="createtableunity(unity1int,unity2int)";stringsqlQuery="select*fromunity";//UsethisforinitializationvoidStart(){stringconnectionString="DataSource="+application.dataPath+"/test.sqlite";SqliteConnectiondbConnection;dbConnection=newSqliteConnection(connectionString);dbConnection.Open();SqliteCommanddbCommand;dbCommand=dbConnection.CreateCommand();dbCommand.CommandText=sqlQuery;dbCommand.ExecuteNonQuery();SqliteDataReaderdbReader;dbReader=dbCommand.ExecuteReader();while(dbReader.Read()){for(inti=0;i<dbReader.FieldCount;i++){Debug.Log(dbReader.GetName(i));Debug.Log(dbReader.GetValue(i));}}}}拖到任意物體上，運行。