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();
}
