unity查询mysql数据库

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

public class DatabaseManager
{
    private MySqlConnection connection;
    private string server;
    private string database;
    private string uid;
    private string password;

    public DatabaseManager()
    {
        server = "localhost";
        database = "your_database_name";
        uid = "your_username";
        password = "your_password";
        string connectionString = "Server=" + server + ";Database=" + database + ";Uid=" + uid + ";Pwd=" + password + ";";
        connection = new MySqlConnection(connectionString);
    }

    public void OpenConnection()
    {
        if (connection.State == ConnectionState.Closed)
        {
            connection.Open();
        }
    }

    public void CloseConnection()
    {
        if (connection.State == ConnectionState.Open)
        {
            connection.Close();
        }
    }

    public DataTable Select(string query)
    {
        OpenConnection();
        MySqlCommand command = new MySqlCommand(query, connection);
        MySqlDataAdapter adapter = new MySqlDataAdapter(command);
        DataTable dataTable = new DataTable();
        adapter.Fill(dataTable);
        CloseConnection();
        return dataTable;
    }
}

public DataTable SelectAllUsers()
{
    string query = "SELECT * FROM users";
    return Select(query);
}

DatabaseManager databaseManager = new DatabaseManager();
DataTable usersData = databaseManager.SelectAllUsers();

foreach (DataRow row in usersData.Rows)
{
    string username = row["username"].ToString();
    int score = int.Parse(row["score"].ToString());
    // 进行后续操作
}