unity3d连接mysql_unity连接mysql

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

今天在蛮牛教育上学习了又关Unity连接mysql 数据库的方法 好啦不用废话直接代码如下：

using UnityEngine;

using System;

using System.Collections;

using System.Data;

using MySql.Data.MySqlClient;

public class CMySql : MonoBehaviour {

// Global variables

private static MySqlConnection dbConnection;

static string host = "192.168.1.100";

static string id = "蛮牛教育";

static string pwd = "123456";

static string result = "";

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 = "Server="+host+";Database=test;User ID="+id+";Password="+pwd+";Pooling=false";

openSqlConnection( connectionString );

}

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;

}

}