纳金网

标题: 连接 MySQL (使用DataSet)_转载 [打印本页]

作者: 她。 时间: 2012-6-29 14:22
标题: 连接 MySQL (使用DataSet)_转载

using UnityEngine;


using System;


using System.Collections;


using System.Data;


using MySql.Data.MySqlClient;


public class CMySql : MonoBehaviour {


      // Global variables


      public static MySqlConnection dbConnection;//Just like MyConn.conn in StoryTools before




      static string host = "192.168.1.100";


      static string id = "mysql";


      static string pwd = "123456";


      static string database = "test";


      static string result = "";





private string strCommand = "Select * from unity3d_test ORDER BY id;";


public static DataSet MyObj;


      void OnGUI()


      {


         host = GUILayout.TextField( host, 200, GUILayout.Width(200));


         id = GUILayout.TextField( id, 200, GUILayout.Width(200));


         pwd = GUILayout.TextField( pwd, 200, GUILayout.Width(200));


         if(GUILayout.Button("Test"))


         {


      string connectionString = string.Format("Server = {0}; Database = {1}; User ID = {2}; Password = {3};",host,database,id,pwd);


      openSqlConnection(connectionString);





      MyObj = GetDataSet(strCommand);


         }


         GUILayout.Label(result);


      }


      // On quit


      public static void OnApplicationQuit() {


         closeSqlConnection();


      }





      // Connect to database


      private static void openSqlConnection(string connectionString) {


         dbConnection = new MySqlConnection(connectionString);


         dbConnection.Open();


         result = dbConnection.ServerVersion;


         //Debug.Log("Connected to database."+result);


      }





      // Disconnect from database


      private static void closeSqlConnection() {


         dbConnection.Close();


         dbConnection = null;


         //Debug.Log("Disconnected from database."+result);


      }





      // MySQL Query


      public static void doQuery(string sqlQuery) {


         IDbCommand dbCommand = dbConnection.CreateCommand();


         dbCommand.CommandText = sqlQuery;


         IDataReader reader = dbCommand.ExecuteReader();


         reader.Close();


         reader = null;


         dbCommand.Dispose();


         dbCommand = null;


      }


      #region Get DataSet


      public  DataSet GetDataSet(string sqlString)


      {


         //string sql = UnicodeAndANSI.UnicodeAndANSI.UnicodeToUtf8(sqlString);








   DataSet ds = new DataSet();


         try


         {


            MySqlDataAdapter da = new MySqlDataAdapter(sqlString, dbConnection);


            da.Fill(ds);





         }


         catch (Exception ee)


         {





            throw new Exception("SQL:" + sqlString + "
" + ee.Message.ToString());


         }


         return ds;





      }


      #endregion


}

复制代码
/*

...本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/nette/archive/2009/07/30/4394849.aspx

*/

另一段代码

using UnityEngine;


using System;


using System.Collections;


using System.Data;




public class DataBaseTest : MonoBehaviour {


public GUISkin myGUISkin = new GUISkin();


string strID = "";


string strName = "";


string strSex = "";


int Index = 1;


// Use this for initialization


void Start () {


}




void OnGUI()


{


   GUI.skin = myGUISkin;


   if (GUI.Button(new Rect(100,320,100,100),"Click Me"))


   {


   foreach(DataRow dr in CMySql.MyObj.Tables[0].Rows)


   {


      if (Index.ToString() == dr["ID"].ToString())


      {


      strID = dr["ID"].ToString();


      strName =  dr["Name"].ToString();


      strSex = dr["Sex"].ToString();





      break;


      }


   }


   Index++;


      if(Index > 5)


   {


      Index = 1;


   }





   }


   GUI.Label(new Rect(320,100,150,70),"DataBaseTest");


   GUI.Label(new Rect(300,210,150,70),strID);


   GUI.Label(new Rect(300,320,150,70),strName);


   GUI.Label(new Rect(300,430,150,70),strSex);





}


}

复制代码
2.導入dll

  同先前的帖子 , 將MySql.data.dll Import至Assets底下 , 然後再到UnityEditorDataFrameworksMono.framework 中

將System.Data.dll 也一起Import至Assets內 , 當然 , 如果想顯示中文的話 , 請參考中文視頻教學 , 建立一個GUISkin與字型

3.建立數據庫內容

  主要是因為代碼中的這段內容

static string host = "192.168.1.100";


      static string id = "mysql";


      static string pwd = "123456";


      static string database = "test";


      private string strCommand = "Select * from unity3d_test ORDER BY id;";

复制代码
其中host ,id , pwd 請自行設定 , 簡單的說就是連進你的MySQL啦~

然後建立一個名為test的Database , 在這個test下建立一張table , 取名為 unity3d_test ,

接下來就為這張unity3d_test建立3個欄位 : ID , Name , Sex (記得將ID設定為primary key 且默認值為1)

再來自行填入5筆資料(5筆資料的原因是腳本那邊是設定成5筆資料一個循環 , 使用者可以自行更改腳本試試)

4.建立GameObject

  建立完GameObject後將上面兩個腳本掛上去 , 如果有建立GUISkin , 記得指定GUISkin

5.執行

  執行後先按Test按鈕來連接數據庫 , 然後再按"Click Me"來顯示數據庫內的內容

6.總結

  以上部份是有關連線至數據庫後 , 再將資料用DataSet的方式獲得出來再加以顯示至介面上 .

转自 http://bbs.vrsh.cn/viewthread.ph ... 26amp%3Btypeid%3D43

作者: 王者再临 时间: 2012-12-30 04:14
学习了，虽然还是有难度，谢谢楼主的用心

欢迎光临纳金网 (http://go.narkii.com/club/)