unity3d+mysql学习demo，简易数据查询系统

实现效果

代码 

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using System.Data;
using UnityEngine.UI;
using MySql.Data.MySqlClient;//引用sql命名空间

public class MysqlCon : MonoBehaviour
{
    public InputField zhuji; //主机名||主机地址
    public InputField user; //账号
    public InputField password; //密码
    public InputField port; //端口号
    public InputField databaseName;//数据库名字 
    public InputField tableName; //表名
    public InputField idName;//id名
    public InputField id;//id
    public InputField columnName;//查询的列名
    public Text shujv;//数据显示

    public Button chaxunButton;//查询按钮



    void Start()
    {
        chaxunButton.onClick.AddListener(Inquire);//添加按钮监听

    }
    void Inquire()
    {
        string constr = string.Format("server={0};port={1};user={2};password={3}; database={4};", zhuji.text.ToString(), port.text.ToString(), user.text.ToString(), password.text.ToString(), databaseName.text.ToString());
        MySqlConnection conn = new MySqlConnection(constr);
        try
        {
           
            conn.Open();
            string str = string.Format("select*from {0} where {1}={2}", tableName.text.ToString(), idName.text.ToString(), id.text.ToString());
            MySqlCommand cmd = new MySqlCommand(str, conn);
            MySqlDataReader rdr = cmd.ExecuteReader();

            rdr.Read();
            shujv.text = rdr.GetString(string.Format("{0}", columnName.text.ToString()));
            rdr.Close();
        }
        catch (MySqlException ex)
        {
            shujv.text = "null";
            print(ex.Message);
        }
        finally
        {
            print("关闭数据库");
                conn.Close(); 

        }






    } 
}

传送门

项目下载