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 + "\n" + 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);   
     
}   
}