void Start() { //设置数据库存储路径 appDBPath = Application.persistentDataPath + "/" + "Madoka.db"; //如果数据库不存在,从unity中拷贝 if (!File.Exists(appDBPath)) { //用www先从Unity中下载到数据库 WWW loadDB = new WWW("jar:file://" + Application.dataPath + "!/assets/" + "Madoka.db"); bool boo = true; while (boo) { if (loadDB.isDone) { //拷贝至规定的地方 File.WriteAllBytes(appDBPath, loadDB.bytes); boo = false; } } } dbName = "URI=file:" + appDBPath; #if UNITY_EDITOR //编辑器的话,路径设置成这样 dbName = "data source = Madoka.db"; #endif db = new DbAccess(dbName); IsTableExist(db); db.DisConnectDb(); LoadSetting(); InitGameSprite(); }
private void UpdateTable(string table_name, string[] strFiled, string[] strValue, string strKeyFiled, string strKeyValue) { DbAccess db = new DbAccess(dbName); db.UpdateTable(table_name, strFiled, strValue, strKeyFiled, strKeyValue); db.DisConnectDb(); }
private void SelectTable(string table_name, int keyvalue, out string[] strData, string keyfiled = "TableIndex") { DbAccess db = new DbAccess(dbName); SqliteDataReader SqliteReader = db.SelectTable(table_name, keyfiled, keyvalue); object[] objData = new object[SqliteReader.FieldCount]; int fieldCount = SqliteReader.GetValues(objData); strData = new string[fieldCount]; for (int i = 0; i < fieldCount; i++) { strData[i] = objData[i].ToString(); } db.DisConnectDb(); }
private void InsertTable(string table_name, string[] strFiled, string[] strValue) { DbAccess db = new DbAccess(dbName); db.InsertTable(table_name, strFiled, strValue); db.DisConnectDb(); }
private void SelectTable(string table_name, string item, out string[] strData) { DbAccess db = new DbAccess(dbName); SqliteDataReader SqliteReader = db.SelectTable(table_name); strData = new string[4]; if (SqliteReader.HasRows) { while (SqliteReader.Read()) { object[] objData = new object[SqliteReader.FieldCount]; int fieldCount = SqliteReader.GetValues(objData); strData[int.Parse(objData[0].ToString())] = objData[2].ToString(); } } db.DisConnectDb(); }