TianJin_23/Assets/Scripts/DBScripts/Test.cs

<EFBFBD><EFBFBD>using UnityEngine;
using System.Collections;
using Mono.Data.Sqlite;

//using Mono.Data.SqliteClient;

public class Test : MonoBehaviour 
{
	
	string  name = null;
	string  email = null;
	string path = null;

	void Start () 
	{

		//penc<EFBFBD>^<EFBFBD>e<EFBFBD>N<EFBFBD>PX[0W@W
		//string appDBPath = Application.persistentDataPath + "/xuanyusong.db";

        string appDBPath = Application.dataPath + "/yhd.db";	
		
		DbAccess db = new DbAccess(@"Data Source=" + appDBPath);			
	
		path = appDBPath;
		
        ////<EFBFBD><EFBFBD><EFBFBD>la <EFBFBD>ceQW[&{2N/f <EFBFBD>]<EFBFBD>~<EFBFBD><EFBFBD><EFBFBD>R
N'<EFBFBD>[<EFBFBD><EFBFBD>~g' 
N6qO<EFBFBD>b<EFBFBD>
        //db.CreateTable("momo",new string[]{"name","qq","email","blog"}, new string[]{"text","text","text","text"});
        ////b(Wpenc<EFBFBD>^-Nޏ<EFBFBD>~<EFBFBD>ceQ	Nagpenc
        //db.InsertInto("momo", new string[]{ "'<EFBFBD>[<EFBFBD><EFBFBD>~g'","'289187120'","'xuanyusong@gmail.com'","'www.xuanyusong.com'"   });
        //db.InsertInto("momo", new string[]{ "'<EFBFBD><EFBFBD>~gMOMO'","'289187120'","'000@gmail.com'","'www.xuanyusong.com'"   });
        //db.InsertInto("momo", new string[]{ "'<EFBFBD>T<EFBFBD>T<EFBFBD>T'","'289187120'","'111@gmail.com'","'www.xuanyusong.com'"   });
		
        ////6qT(W R<EFBFBD>c$Nagpenc
        //db.Delete("momo",new string[]{"email","email"}, new string[]{"'xuanyusong@gmail.com'","'000@gmail.com'"}  );
		
        ////<EFBFBD>l<EFBFBD><EFBFBD>1
        //using (SqliteDataReader sqReader = db.SelectWhere("momo",new string[]{"name","email"},new string[]{"qq"},new string[]{"="},new string[]{"289187120"}))
        //{
	
        //    while (sqReader.Read())  
        //    { 	
        //        //<EFBFBD>vMR-N<EFBFBD>e<EFBFBD>e<EFBFBD>l>f:y
        //        Debug.Log("xuanyusong" + sqReader.GetString(sqReader.GetOrdinal("name")));
			
		
        //        Debug.Log("xuanyusong" + sqReader.GetString(sqReader.GetOrdinal("email")));
				
				
        //        name = sqReader.GetString(sqReader.GetOrdinal("name"));
        //        email = sqReader.GetString(sqReader.GetOrdinal("email"));
				
        //    } 
		
        //    sqReader.Close();
        //}

        using (SqliteDataReader sqReader = db.ReadFullTable("momo"))
        {
            while (sqReader.Read())
            {
                Debug.Log("name:" + sqReader.GetString(sqReader.GetOrdinal("name")));
                Debug.Log("qq:" + sqReader.GetString(sqReader.GetOrdinal("qq")));
                Debug.Log("email:" + sqReader.GetString(sqReader.GetOrdinal("email")));
            }
            sqReader.Close();
        }
		
		db.CloseSqlConnection();
	}
	
	
	void OnGUI()
	{
		if(name != null)
		{
			GUILayout.Label(name);
		}
		
		if(email != null)
		{
			GUILayout.Label(email);
		}
		
		
		if(path != null)
		{
			GUILayout.Label(path);
		}
	}
	
	
	void Update()
	{
		if (Input.GetKeyDown(KeyCode.Escape) ||Input.GetKeyDown(KeyCode.Home) )
        {

            Application.Quit();
        }
	}

}