mysqlhelper 用法

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

public class MySQLHelper
{
    private static string connectionString = "your_connection_string_here";

    public static DataTable ExecuteQuery(string sql)
    {
        DataTable result = new DataTable();
        using (MySqlConnection conn = new MySqlConnection(connectionString))
        {
            conn.Open();
            using (MySqlDataAdapter adapter = new MySqlDataAdapter(sql, conn))
            {
                adapter.Fill(result);
            }
        }
        return result;
    }

    public static int ExecuteNonQuery(string sql)
    {
        int result = 0;
        using (MySqlConnection conn = new MySqlConnection(connectionString))
        {
            conn.Open();
            using (MySqlCommand command = new MySqlCommand(sql, conn))
            {
                result = command.ExecuteNonQuery();
            }
        }
        return result;
    }

    // 其他数据库操作方法...
}