unity3d 使用sqlite数据库
发布时间:2020-12-12 20:32:09 所属栏目:百科 来源:网络整理
导读://创建数据库名称为xuanyusong.db DbAccess db = new DbAccess("data source=horsegame.db"); try{ print("fdsfgdgdsafgdsagda"); //请注意 插入字符串是 已经要加上'宣雨松' 不然会报错 //db.CreateTable("datainfo",new string[]{"name","equipNo","colorT
//创建数据库名称为xuanyusong.db DbAccess db = new DbAccess("data source=horsegame.db"); try{ print("fdsfgdgdsafgdsagda"); //请注意 插入字符串是 已经要加上'宣雨松' 不然会报错 //db.CreateTable("datainfo",new string[]{"name","equipNo","colorType","status","scores"},new string[]{"TEXT","INTEGER","TEXT"}); // db.InsertInto("datainfo",new string[]{ "'equip1'","0","1","200" }); // db.InsertInto("datainfo",new string[]{ "'equip2'","400" }); //注解1 //SqliteDataReader sqReader = db.SelectWhere("datainfo","colorType"},new string[]{"equipNo"},new string[]{"="},new string[]{"0"}); SqliteDataReader sqReader = db.ReadFullTable("datainfo"); string strVal; int nVal; int i = 0; while (sqReader.Read()) { Debug.Log(sqReader.GetString(sqReader.GetOrdinal("name")) + sqReader.GetString(sqReader.GetOrdinal("scores"))); pro = new Property(); nVal = sqReader.GetInt32(sqReader.GetOrdinal("equipNo")); pro.m_nEno = nVal; nVal = sqReader.GetInt32(sqReader.GetOrdinal("colorType")); pro.m_colorType = (ColorType)nVal; nVal = sqReader.GetInt32(sqReader.GetOrdinal("status")); pro.m_bStatu = nVal; strVal = sqReader.GetString(sqReader.GetOrdinal("scores")); m_score = System.Convert.ToInt32(strVal); AddEquipProperty(strEquipName[i],pro); ++i; } db.CloseSqlConnection(); } catch(SqliteException e){ db.CloseSqlConnection(); } (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |