纳金网

标题: 学习笔记-数据库 [打印本页]

作者: 狂风大尉 时间: 2015-7-1 06:39
标题: 学习笔记-数据库

using UnityEngine;
using System.Collections;
using Mono.Data.Sqlite;
public class SQLTest : MonoBehaviour {

// Use this for initialization
void Start () {
      string dbPath = Application.dataPath+"/GameDB.sqlite";
      //1.链接数据库
SqliteConnection connect = new SqliteConnection("Data Source="+dbPath);
      //2.打开数据库
connect.Open();
      //3.创建数据库指令对象
SqliteCommand command = connect.CreateCommand();
      //4.执行SQLite语句
command.CommandText = "";
command.ExecuteNonQuery();

      //4.5 .  获取查询结果

SqliteDataReader reader = command.ExecuteReader();
while ( reader.Read())
      {
      for (int i = 0; i < reader.FieldCount; i++)
         {
         string name= reader.GetName(i);
         string value = reader.GetString(i);
         }
      }

connect.Close();
}
}

欢迎光临纳金网 (http://go.narkii.com/club/)