unity3d中连接数据库.doc

unity3d中连接数据库.txt38当乌云布满天空时，悲观的人看到的是“黑云压城城欲摧”，乐观的人看到的是“甲光向日金鳞开”。无论处在什么厄运中，只要保持乐观的心态，总能找到这样奇特的草莓。/* 在unity3d中连接数据库 收藏 1.C#代码： */ 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 = 00; 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.Comma