Unity连接MySql

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

壹米玖坤

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

阅读量438

点赞数 1

CC 4.0 BY-SA版权

分类专栏： Unity游戏开发文章标签：游戏引擎

本文链接：https://blog.csdn.net/qq_29377339/article/details/146310863

Unity游戏开发专栏收录该内容

5 篇文章

订阅专栏

创建数据库连接代码

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

public class DatabaseManager : MonoBehaviour
{
    private string connectionString = "server=localhost;port=3306;database=game_db;user=root;password=root;";

    void Start()
    {
        // 测试连接
        using (MySqlConnection connection = new MySqlConnection(connectionString))
        {
            try
            {
                connection.Open();
                Debug.Log("数据库连接成功！");
            }
            catch (System.Exception e)
            {
                Debug.LogError("数据库连接失败: " + e.Message);
            }
        }
    }

    public void InsertData(string playerName, int score)
    {
        using (MySqlConnection connection = new MySqlConnection(connectionString))
        {
            connection.Open();
            string query = "INSERT INTO player_scores (player_name, score) VALUES (@playerName, @score)";
            using (MySqlCommand command = new MySqlCommand(query, connection))
            {
                command.Parameters.AddWithValue("@playerName", playerName);
                command.Parameters.AddWithValue("@score", score);
                command.ExecuteNonQuery();
            }
        }
    }
}

游戏中调用

public class GameLogic : MonoBehaviour
{
    public DatabaseManager databaseManager;

    void Update()
    {
        if (Input.GetKeyDown(KeyCode.Space))
        {
            // 假设玩家按空格键完成操作，存储数据到数据库
            databaseManager.InsertData("Player1", 100);
        }
    }
}