unity数据库连接

unityMYSQL数据库连接：

using MySql.Data.MySqlClient;
using System;
using System.Data;
using UnityEngine;

public class Test : MonoBehaviour
{

public MySqlConnection mysql;
static string host = "localhost";
static string port = "3306";
static string username = "root";
static string pwd = "123456";
static string database = "gametest";

void Start()
{
    OpenSQL();
}
//连接数据库
public void OpenSQL()
{
    //建立连接语句
    string constr = string.Format("server = {0};port={1};database = {2};user = {3};password = {4};charset=utf8;", host, port, database, username, pwd);
    //建立连接
    mysql = new MySqlConnection(constr);
    //打开连接
    mysql.Open();
}

//查询，读取数据
public void Search(string tableName)
{
    //sql命令，选择gametest表
    string sqlString = "select * from " + tableName;
    MySqlCommand cmd = new MySqlCommand(sqlString, mysql);
    MySqlDataReader reader = cmd.ExecuteReader();
    //Read一次就是一行数据，Read不为空执行打印数据
    while (reader.Read())
    {
        Debug.Log("查询数据：" + reader[0] + "  " + reader[1] + "   " + reader[2]);
    }    reader.Close();
}

//添加数据
public void AddData(int id, int level, string name)
{
    //在表player中添加ID = id,LV = level,Name = name
    string sql = "insert into player(ID,LV,Name) values('" + id + "','" + level + "','" + name + "')";
    MySqlCommand cmd = new MySqlCommand(sql, mysql);
    //返回更改数据行数
    int result = cmd.ExecuteNonQuery();
    Debug.Log("添加数据成功:" + result);

}
//更新数据
public void UpdateData()
{
    //更新表player中ID = 2的数据 ,设置LV = 9,Name = zhang
    string sql = "update player set LV='9',Name='zhang' where ID=2";//更改的sql命令
    MySqlCommand cmd = new MySqlCommand(sql, mysql);
    //返回值是数据库中修改的行数
    int result = cmd.ExecuteNonQuery();
    Debug.Log("更新数据成功:" + result);

}
//删除数据
public void DeleteData()
{
    //删除的sql命令，这里是删除player中id=20的一行数据
    string sql = "delete from player where ID=2";
    MySqlCommand cmd = new MySqlCommand(sql, mysql);
    int result = cmd.ExecuteNonQuery();
    Debug.Log("删除数据成功:" + result);
}

/// <summary>
/// 关闭数据库连接
/// </summary>
public void Close()
{
    if (mysql != null)
    {
        mysql.Close();
        mysql.Dispose();
        mysql = null;
    }
}

}