自己动手写的一个MySqlDbHelper

最近使用控制台给学弟们写了一个班级信息录入，为了程序小而精美，容易看懂，动手写了一个DbHelper，用ORM框架习惯了，有点生疏，特此记录与分享。

using System.ComponentModel.DataAnnotations;
using System.Data;
using System.Reflection;
using System.Text;
using System.Text.RegularExpressions;
using MySql.Data.MySqlClient;

namespace test_console.Utils;

public static class MySqlDbHelper
{
    private const string ConnectionString = "server=127.0.0.1;uid=root;pwd=123456;database=db_study;port=3306;";
    private static MySqlConnection? _conn;

    /// <summary>
    ///     初始化连接对象
    /// </summary>
    private static void Initialization()
    {
        _conn ??= new MySqlConnection(ConnectionString);
        if (_conn.State == ConnectionState.Closed) _conn.Open();
    }

    /// <summary>
    ///     执行
    /// </summary>
    /// <param name="sql"></param>
    /// <param name="parameters"></param>
    /// <returns></returns>
    public static int Execute(string sql, MySqlParameter[] parameters)
    {
        Initialization();
        var cmd = new MySqlCommand(sql, _conn);
        cmd.Parameters.AddRange(parameters);
        var result = cmd.ExecuteNonQuery();
        Dispose();
        return result;
    }

    /// <summary>
    ///     执行
    /// </summary>
    /// <param name="sql"></param>
    /// <param name="parameter"></param>
    /// <returns></returns>
    public static int Execute(string sql, MySqlParameter parameter)
    {
        Initialization();
        var cmd = new MySqlCommand(sql, _conn);
        cmd.Parameters.Add(parameter);
        var result = cmd.ExecuteNonQuery();
        Dispose();
        return result;
    }

    /// <summary>
    ///     执行
    /// </summary>
    /// &l