纳金网

标题: Unity3d 连接MySQL数据库测试成功_教程 [打印本页]

作者: 她。 时间: 2012-6-15 17:57
标题: Unity3d 连接MySQL数据库测试成功_教程
C#代码：

view plaincopy to clipboardprint?


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";//这里是你自己的数据库的用户名字，我一开始想用root，发现不行，后来添加了新的用户才可以


      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


}

复制代码
此段代码网络上出现在很多不同的地方，已经搞不清是出自哪位高人之手了，所以在感激的同时感到抱歉无法注明出处了，希望更多的人能够从中受益。

另一段C#代码：

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





}


}

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

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