UNITY3D 数据库连接C#

刚在蛮牛上看到涉及到服务器这块，特意的去网上找了一些资料和自己的一些认知，分享给大家
  不多废话，直接上代码：

1. using UnityEngine;
   
2. using System;
   
3. using System.Collections;
   
4. using System.Data;
   
5. using MySql.Data.MySqlClient;
   
6. public class CMySql : MonoBehaviour {
   
7.     // Global variables 全局变量
   
8.     public static MySqlConnection dbConnection;//Just like MyConn.conn in StoryTools before
   
9. //自己的主机地址
   
10.      static string host = "192.168.1.100";
    
11.      static string id = "mysql";//这里是你自己的数据库的用户名字，我一开始想用root，发现不行，后来添加了新的用户才可以
    
12. //数据库密码
    
13.      static string pwd = "123456";
    
14. //数据库名称
    
15.      static string database = "test";
    
16. //定义一个空字符串
    
17.      static string result = "";
    
18. //数据库查询语句
    
19. private string strCommand = "Select * from unity3d_test ORDER BY id;";
    
20. //dataset这个是MySql.Data.MySqlClient.dll库中自带的类型
    
21. public static DataSet MyObj;
    
22. 
    
23.      void OnGUI()
    
24.      {
    
25.          host = GUILayout.TextField( host, 200, GUILayout.Width(200));
    
26.          id = GUILayout.TextField( id, 200, GUILayout.Width(200));
    
27.          pwd = GUILayout.TextField( pwd, 200, GUILayout.Width(200));
    
28.          if(GUILayout.Button("Test"))
    
29.          {
    
30.     string connectionString = string.Format("Server = {0}; Database = {1}; User ID = {2}; Password = {3};",host,database,id,pwd);
    
31.     openSqlConnection(connectionString);
    
32.     MyObj = GetDataSet(strCommand);
    
33.          }
    
34.          GUILayout.Label(result);
    
35.      }  
    
36.     // On quit
    
37.     public static void OnApplicationQuit() {
    
38.         closeSqlConnection();
    
39.     }
    
40.     // Connect to database
    
41.     private static void openSqlConnection(string connectionString) {
    
42.         dbConnection = new MySqlConnection(connectionString);
    
43.         dbConnection.Open();
    
44.         result = dbConnection.ServerVersion;
    
45.         //Debug.Log("Connected to database."+result);
    
46.     }
    
47.     // Disconnect from database
    
48.     private static void closeSqlConnection() {
    
49.         dbConnection.Close();
    
50.         dbConnection = null;
    
51.         //Debug.Log("Disconnected from database."+result);
    
52.     }
    
53.     // MySQL Query
    
54.     public static void doQuery(string sqlQuery) {
    
55.         IDbCommand dbCommand = dbConnection.CreateCommand();   
    
56.         dbCommand.CommandText = sqlQuery;
    
57.         IDataReader reader = dbCommand.ExecuteReader();
    
58.         reader.Close();
    
59.         reader = null;
    
60.         dbCommand.Dispose();
    
61.         dbCommand = null;
    
62.     }
    
63.     #region Get DataSet
    
64.     public  DataSet GetDataSet(string sqlString)
    
65.     {
    
66.         //string sql = UnicodeAndANSI.UnicodeAndANSI.UnicodeToUtf8(sqlString);
    
67.   DataSet ds = new DataSet();
    
68.         try
    
69.         {
    
70.             MySqlDataAdapter da = new MySqlDataAdapter(sqlString, dbConnection);
    
71.             da.Fill(ds);
    
72.         }
    
73.         catch (Exception ee)
    
74.         {
    
75.             throw new Exception("SQL:" + sqlString + "/n" + ee.Message.ToString());
    
76.         }
    
77.         return ds;
    
78.     }
    
79.     #endregion
    
80. }

复制代码

好资源，底子薄还需要消化一下

感謝分享這麼好的資源!

有什么用吗？