【SQLite】Unity和SQLite数据库的应用

主要的三大类 sqliteConnection sqliteCommand sqliteReader

主要的三个方法 ExecuteNoQuery  ExecuteReader ExexuteScalar

语法特点：SQL语句关键字不区分大小写，规范上用大写。

select * from 表名称 

select 列名称，列名称 from 表名称 

例子 select name,sex,age from person(表名称) where sex = "女" and age >= 16 and age <= 20

创建SQLite数据库 主要步骤

1.给出存储地址

2.创建连接

3.打开连接

4.创建命令

5.将SQL命令赋值

6.执行SQL命令

7读取数据

using UnityEngine;using System.Collections;using Mono.Data.Sqlite;public class SQL_IDUS : MonoBehaviour{SqliteConnection sqliteConection;SqliteCommand sqliteCommand;void Awake (){//给出存储地址string sqliteConnection = "Data Source = " + Application.dataPath + "/mylove.sqlite";//创建连接sqliteConection = new SqliteConnection (sqliteConnection);//创建命令sqliteCommand = sqliteConection.CreateCommand ();//连接对象sqliteConection.Open ();//命令赋值sqliteCommand.CommandText = "select * from SQL_Pra";object o = sqliteCommand.ExecuteScalar ();sqliteConection.Close ();}}

using UnityEngine;using System.Collections;using Mono.Data.Sqlite;/// <summary>/// 添加时间：2015年06月29日09:24:12/// </summary>public class SqliteReasderDemo : MonoBehaviour{SqliteConnection connection;SqliteCommand command;SqliteDataReader reader;void Awake (){string path = "Data Source =" + <span style="font-family: Arial, Helvetica, sans-serif;">Application.dataPath + "/mylove.sqlite";</span>connection = new SqliteConnection (path);connection.Open ();command = connection.CreateCommand ();command.CommandText = "select * from BigUnity";reader = command.ExecuteReader ();while (reader.Read ()) {//reader.FieldCount ： 第一行有多少列for (int i = 0; i < reader.FieldCount; i++) {//GetName 字段名字 （表头） ID  Age  Sex  之类的Debug.Log (reader.GetName (i));//获取的值Debug.Log (reader.GetValue (i));}}connection.Clone ();}}

CommandTimeout :超时时间

ExecuteNonQuery 返回一个受影响的列数（增删改查）

ExexuteReader 返回一个存所有数据的类()

ExecuteScalar 只会返回第一个结果 （同理 多个数据也是一样）

sqliteConnection.对象.Clone 关闭并释放内存

sqliteConnection.对象.Close 关闭

using UnityEngine;using System.Collections;using Mono.Data.Sqlite;using System.IO;/// <summary>/// 脚本功能：创建数据库/// 添加时间：2015年07月14日11:05:53/// 添加对象：/// /// </summary>/// 因为是单例类 没有集成所以不会执行Awakepublic class CreateData{//数据库三大类public SqliteConnection connection;public SqliteCommand command;public SqliteDataReader reader;string[] bbb;private static CreateData instance;private CreateData (){bbb = new string[]{ };////通过路径找到第三发过数据库//string addDBPath = Application.dataPath + "/Plugins/Android/assets/" + "NBAGame.sqlite";string addDBPath = "Data Source =" + Application.dataPath + "/Plugins/NBAGame.sqlite";//connection = new SqliteConnection ("URI=file:" + addDBPath);//window测试connection = new SqliteConnection (addDBPath);command = connection.CreateCommand ();connection.Open ();}public static CreateData Instance {get {if (instance == null) {instance = new CreateData ();}return instance;}}void Awake (){bbb = new string[]{ };////通过路径找到第三发过数据库//string addDBPath = Application.dataPath + "/Plugins/Android/assets/" + "NBAGame.sqlite";string addDBPath = "Data Source =" + Application.dataPath + "/Plugins/NBAGame.sqlite";//connection = new SqliteConnection ("URI=file:" + addDBPath);//window测试connection = new SqliteConnection (addDBPath);command = connection.CreateCommand ();////讲第三方数据库拷贝到Android可找到的地方//string addDBPath = Application.persistentDataPath + "/" + "NBAGame.sqlite";//如果已知路径没有地方放数据库，那么我们从unity中拷贝//if (!File.Exists (addDBPath)) {////WWW loadDb = new WWW ("jar:file://" + Application.dataPath + "!/assets/" + "NBAGame.sqlite");//////////connection = new SqliteConnection ("URI=file:" + addDBPath);//////拷贝到指定的地方//File.WriteAllBytes (addDBPath, loadDb.bytes);////}connection.Open ();//在游戏界面读取 现在只是留个口//Debug.Log (command);////测试//command.CommandText = "SELECT LongScore FROM Blue where Block = '82'";//object o = command.ExecuteScalar ();//while (reader.Read ()) {//for (int i = 0; i < reader.FieldCount; i++) {//bbb [i] = reader.GetValue (i).ToString ();//Debug.Log (bbb [i]);//}////}Debug.Log (o.ToString ());}