买卖装备+Sqlite

//框架using UnityEngine;using System.Collections;using Mono.Data.Sqlite;using System.Collections.Generic;public class DatabaseFramework : MonoBehaviour {public static DatabaseFramework instance;void Awake(){instance = this;}#region 全局数据库对象private SqliteConnection con;private SqliteCommand command;private SqliteDataReader reader;#endregion#region 数据库框架-数据库打开关闭//[]表示c#特性[SerializeField]//序列化属性（将私有的属性显示到Inspector面板）//数据库名称private string databaseName;/// <summary>/// 打开数据库/// </summary>/// <param name="databaseName">Database name.</param>public void OpenDatabase(string databaseName){//如果用户传参数是，没有添加数据库文件后缀名if (!databaseName.Contains(".sqlite")) {//添加后缀名databaseName += ".sqlite";}string path = "Data Source=" + Application.streamingAssetsPath + "/" + databaseName;con = new SqliteConnection (path);//建立连接command = con.CreateCommand ();//建立指令对象con.Open ();//打开连接}/// <summary>/// 关闭数据库/// </summary>public void CloseDatabase(){con.Close ();//reader = null;//command = null;//con = null;}#endregion#region  数据库操作/// <summary>/// 执行增删改语句的方法/// </summary>public void InsertUpdateDelete(string query){command.CommandText = query;//传入语句command.ExecuteNonQuery ();//执行语句}/// <summary>/// 查询单个数据/// </summary>/// <returns>object</returns>/// <param name="query">Query.</param>public object SelectSingData(string query){command.CommandText = query;//传入语句object result = command.ExecuteScalar ();//执行语句return result;//返回结果}/// <summary>/// 查询一些数据/// </summary>/// <returns>数据</returns>public List<ArrayList> SelectAnyDate(string query){//传入语句command.CommandText = query;    //执行，接收reader=command.ExecuteReader ();//实例化存储结构List<ArrayList> result = new List<ArrayList> ();//逐行遍历while (reader.Read ()) {//当前行数据ArrayList currentRowData = new ArrayList ();//逐列遍历for (int i = 0; i < reader.FieldCount; i++) {//当前行当前列的值object currentValue=reader.GetValue (i);currentRowData.Add (currentValue);}//将当前的所有数据存放到List中result.Add (currentRowData);}//关闭读取流reader.Close ();//返回结果return result;}/// <summary>/// 获取空的装备栏/// </summary>/// <returns>The empty equip box.</returns>public string  GetEmptyEquipBox(){string checkEmpty="Select Equip01,Equip02 From PlayerTable";//获取装备栏信息List<ArrayList> msg=SelectAnyDate (checkEmpty);//判断装备栏1中是否为空if (msg [0] [0].ToString() == "") {return "Equip01";} //否则判断装备栏2中是否为空else if (msg [0] [1].ToString() == "") {return "Equip02";} //否则装备栏1和2中都有装备else {return "";}}/// <summary>///添加装备 /// </summary>/// <param name="equipID">装备ID.</param>/// <param name="Box">装备栏.</param>public void SetEquips(string equipID,string equipBox){string setQuery = "Update PlayerTable Set "+equipBox+"='"+equipID+"'";InsertUpdateDelete (setQuery);} /// <summary>/// 设置钱数/// </summary>/// <param name="money">Money.</param>public void SetMoney(float money){string setQuery = "Update PlayerTable Set Gold=" + money.ToString ();InsertUpdateDelete (setQuery);}/// <summary>/// 获取装备花费/// </summary>/// <returns>The equip money.</returns>/// <param name="equipID">Equip I.</param>public float GetEquipMoney(string equipID){//语句string getQuery = "Select Cost From EquipTable Where Num='" + equipID + "'";    //执行object result = SelectSingData (getQuery);//返回return System.Convert.ToSingle (result);}/// <summary>/// 设置玩家的AD,AP/// </summary>/// <param name="ad">Ad.</param>/// <param name="ap">Ap.</param>public void SetPlyerADAP(float ad,float ap){string setQuery = "Update PlayerTable Set AD=" + ad.ToString ()+",AP="+ap.ToString();InsertUpdateDelete (setQuery);}/// <summary>/// 获取装备AD,AP值/// </summary>/// <returns>The equip ADA.</returns>/// <param name="equipID">装备ID.</param>/// <param name="AD">AD.</param>/// <param name="AP">AP.</param>public void GetEquipADAP(string equipID, out float AD,out float AP){  //查询语句string query = "Select AD,AP From EquipTable Where Num='" + equipID + "'"; //执行    List<ArrayList> result = SelectAnyDate (query);AD = System.Convert.ToSingle(result [0] [0]);AP = System.Convert.ToSingle(result [0] [1]);}public void PlayerDataReset(){string query="Update PlayerTable Set AD=80,AP=20,Gold=8000,Equip01='',Equip02=''";InsertUpdateDelete (query);}#endregion}//玩家信息using UnityEngine;using System.Collections;using UnityEngine.UI;using System.Collections.Generic;public class PlayerMsgInit : MonoBehaviour {public Text playerName;//名称public Text playerAD;//AD值public Text playerAP;//AP值public Text playerGold;//金币数量public Image playerEquip01;//装备1public Image playerEquip02;//装备2public Sprite[] equips;//装备数组void Start(){playerName = transform.Find ("PlayerName").GetComponent<Text> ();playerAD=transform.Find("PlayerAD").GetComponent<Text> ();playerAP=transform.Find("PlayerAP").GetComponent<Text> ();playerGold=transform.Find("Money/MoneyCount").GetComponent<Text> ();playerEquip01 = transform.Find ("PlayerEquips/EquipBg01/MyEquip").GetComponent<Image> ();playerEquip02 = transform.Find ("PlayerEquips/EquipBg02/MyEquip").GetComponent<Image> ();//测试//Debug.Log (playerName + "|" + playerAD + "|" + playerAP + "|" + playerEquip01 + "|" + playerEquip02);MsgInit ();//执行玩家信息初始化}void Update(){if (Input.GetKeyDown(KeyCode.Space)) {//重置数据DatabaseFramework.instance.OpenDatabase ("EquipDatabase");DatabaseFramework.instance.PlayerDataReset ();DatabaseFramework.instance.CloseDatabase ();//重新加载MsgInit ();}}/// <summary>/// 玩家信息初始化/// </summary>public void MsgInit(){//打开数据库DatabaseFramework.instance.OpenDatabase ("EquipDatabase");   //查询玩家信息string query="Select * From PlayerTable";List<ArrayList> msg=DatabaseFramework.instance.SelectAnyDate (query);  //关闭连接DatabaseFramework.instance.CloseDatabase ();  //将数据同步到UIplayerName.text=msg[0][0].ToString();playerAD.text=msg[0][1].ToString();playerAP.text=msg[0][2].ToString();playerGold.text=msg[0][3].ToString();//如果玩家装备栏01中没有装备if (msg [0] [4].ToString() == "") {//隐藏装备图片playerEquip01.gameObject.SetActive (false);} else {//显示图片playerEquip01.gameObject.SetActive (true);//装备图片playerEquip01.sprite = GetSprite (msg [0] [4].ToString());}//如果玩家装备栏02中没有装备if (msg [0] [5].ToString() == "") {//隐藏装备图片playerEquip02.gameObject.SetActive (false);} else {//显示图片playerEquip02.gameObject.SetActive (true);//装备图片playerEquip02.sprite = GetSprite (msg [0] [5].ToString());}}/// <summary>/// 从装备数组中获取指定的装备图片/// </summary>/// <returns>The sprite.</returns>/// <param name="id">装备图片ID.</param>public Sprite GetSprite(string id){//遍历装备数组foreach (var item in equips) {//如果是该装备if (item.name==id) {//返回return item;}}return null;//如果图片库中没有该装备，返回NULL}}//买装备using UnityEngine;using System.Collections;using UnityEngine.UI;public class BuyEuips : MonoBehaviour {private PlayerMsgInit playerMsg;//玩家信息脚本void Start(){playerMsg = GetComponent<PlayerMsgInit> ();}/// <summary>/// 购买装备按钮/// </summary>/// <param name="EquipID">Equip ID.</param>public void OnBuyEquipButtonClick(string EquipID){//数据库操作准备DatabaseFramework.instance.OpenDatabase("EquipDatabase");//打开数据库//1.获取该装备的花费    //获取装备ID：（EquipID）    // 通过装备ID在数据库中查询装备花费           //查询语句string selectCost="Select Cost From EquipTable where Num='"+EquipID+"'";              //执行语句object cost=DatabaseFramework.instance.SelectSingData(selectCost);//2.检测当前玩家能否支付该装备的花费float playerMoney=System.Convert.ToSingle(playerMsg.playerGold.text);       //如果玩家金钱大于等于装备花费if (playerMoney>=System.Convert.ToSingle(cost)) {//3.判断玩家装备栏中是否有空余位置if (!playerMsg.playerEquip01.gameObject.activeSelf||!playerMsg.playerEquip02.gameObject.activeSelf) {//4.添加装备到玩家装备栏//选择放置的装备栏string equipBox = DatabaseFramework.instance.GetEmptyEquipBox ();//设置到数据库DatabaseFramework.instance.SetEquips (EquipID, equipBox);//5.减去该装备的花费float currentMoney=playerMoney-System.Convert.ToSingle(cost);//设置到数据库DatabaseFramework.instance.SetMoney (currentMoney);//6.将该装备的属性信息(AD,AP)添加到玩家身上 //获取该装备的AD APfloat equipAD,equipAP;DatabaseFramework.instance.GetEquipADAP (EquipID, out equipAD, out equipAP); //获取该玩家的AD APfloat playerAD,playerAP;playerAD = System.Convert.ToSingle(playerMsg.playerAD.text);playerAP = System.Convert.ToSingle(playerMsg.playerAP.text);         //计算玩家新的AD APplayerAD+=equipAD;playerAP+=equipAP;//设置到数据库DatabaseFramework.instance.SetPlyerADAP(playerAD,playerAP);//7.将数据信息更新到UIplayerMsg.MsgInit();}}//8.关闭数据库DatabaseFramework.instance.CloseDatabase();}}//卖装备using UnityEngine;using System.Collections;using UnityEngine.UI;public class SellEquips : MonoBehaviour {private PlayerMsgInit playMsg;//获取脚本void Start(){playMsg = GetComponent<PlayerMsgInit> ();}/// <summary>/// 变卖装备/// </summary>/// <param name="equip">装备图片.</param>public void OnSellButtonClick(Image equip){//打开数据库DatabaseFramework.instance.OpenDatabase ("EquipDatabase");//先判断当前装备栏是1号装备栏还是2号装备栏//获取装备栏背景对象名称（外面的框子）string parentName=equip.gameObject.transform.parent.name;parentName=parentName.Remove (5, 2);//删除‘Bg’字符    //设置当前装备栏为空DatabaseFramework.instance.SetEquips("",parentName);//获取当前装备的花费float equipCost=DatabaseFramework.instance.GetEquipMoney(equip.sprite.name);//半价出售装备equipCost /= 2;//获取当前玩家拥有的金钱float playerMonry=System.Convert.ToSingle(playMsg.playerGold.text);//更新玩家金钱playerMonry += equipCost;//更新数据库中的玩家金钱数DatabaseFramework.instance.SetMoney (playerMonry);    //获取当前装备AD,APfloat equipAD,equipAP;DatabaseFramework.instance.GetEquipADAP (equip.sprite.name, out equipAD, out equipAP);//获取当前玩家AD，APfloat playerAD, playerAP;playerAD=System.Convert.ToSingle (playMsg.playerAD.text);playerAP=System.Convert.ToSingle (playMsg.playerAP.text);//更新玩家AD,APplayerAD -= equipAD;playerAP -= equipAP;//将玩家AD,AP更新到数据库DatabaseFramework.instance.SetPlyerADAP(playerAD,playerAP);//关闭数据库DatabaseFramework.instance.CloseDatabase ();//更新UIplayMsg.MsgInit();}}