Unity3D开发(常用方法之mysql增删改查)

最新推荐文章于 2025-06-10 14:09:15 发布

萌城的小小少年

最新推荐文章于 2025-06-10 14:09:15 发布

阅读量1.8k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： unity链接mysql增删改查文章标签： unity3d mysql

本文链接：https://blog.youkuaiyun.com/Mr_chenxiansheng/article/details/84579810

unity链接mysql增删改查专栏收录该内容

1 篇文章

订阅专栏

本文介绍如何在Unity中使用C#进行MySQL数据库的基本操作，包括连接数据库、查询、插入、删除和更新数据。同时，列出了所需导入的DLL文件，为开发者提供了实用的代码示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using MySql.Data.MySqlClient;

using System;

using System.Collections.Generic;

using System.Data;

using System.Linq;

using UnityEngine;



public class MysqlDataCompile : MonoBehaviour {

public int id;

public string modelname;

public double width;

public double heigh;





void Start()

{

try

{

//数据库的增删改查

string MySqlStr = "Database=;server=;User Id=;Password=;";



MySqlConnection mySqlcon = new MySqlConnection(MySqlStr);//连接数据库；

mySqlcon.Open();



//查

string str = "select * from furnituretest where id=" + id + ";";

MySqlCommand mySqlCom = new MySqlCommand(str, mySqlcon);

CheckedMySql(mySqlCom);



//增

//str = "insert into furnituretest values(" + id + ",'" + modelname + "'," + width + ",'" + heigh + "');";

//mySqlCom = new MySqlCommand(str, mySqlcon);

//IducMySql(mySqlCom);



//删

//str = "delete from furnituretest where id=5;";

//mySqlCom = new MySqlCommand(str, mySqlcon);

//IducMySql(mySqlCom);



// 改

//str = "update furnituretest set width=" + width + " where id=" + id + ";";

//mySqlCom = new MySqlCommand(str, mySqlcon);

//IducMySql(mySqlCom);



//GetId(7);

}

catch (Exception e)

{

throw new Exception("服务器连接失败，请重新检查是否打开MySql服务。" + e.Message.ToString());

}

}



//(查)

static private void CheckedMySql(MySqlCommand mySqlcom)

{

MySqlDataReader read = mySqlcom.ExecuteReader();

try

{

if (read.Read())

{



if (read.HasRows)//查找

{

Debug.Log("id:" + read.GetInt32("id"));

Debug.Log("modelname:" + read.GetString("modelname"));

Debug.Log("width:" + read.GetDouble("width"));

Debug.Log("height:" + read.GetDouble("height"));

}



}

}

catch (Exception e)

{



throw e;

}

finally

{

read.Close();

}







}





//增 删 改 查

static private void IducMySql(MySqlCommand mySqlcom)

{

try

{

mySqlcom.ExecuteNonQuery();

}

catch (Exception e)

{

Debug.Log("已存在");

//throw e;

}



}





//指定ID参数打印相关信息

static private void GetId(int id)

{



string MySqlStr = "Database=;server=;User Id=;Password=;";

MySqlConnection mySqlcon = new MySqlConnection(MySqlStr);

mySqlcon.Open();

string str = "select * from furnituretest where id=" + id;//注意 别把分号打上去；

MySqlCommand mySqlCom = new MySqlCommand(str, mySqlcon);

MySqlDataReader reader = mySqlCom.ExecuteReader();

try

{

while (reader.Read())

{



if (reader.HasRows)//查找

{

Debug.Log("id:" + reader.GetInt32("id"));

Debug.Log("modelname:" + reader.GetString("modelname"));

Debug.Log("width:" + reader.GetDouble("width"));

Debug.Log("height:" + reader.GetDouble("height"));

}



}



}

catch (Exception e)

{



throw e;

}

finally

{

reader.Close();

}

}

}

unity中需要导入五个dll：

Unity\Editor\Data\Mono\lib\mono\unity

目录下的

I18N.dll I18N.West.dll I18N.CJK.dll

Unity\Editor\Data\Mono\lib\mono\2.0

目录下的

System.Data.dll System.Drawing.dll

还需要 mysql5.0版本以上的

MySql.Data.dll