最近使用控制台给学弟们写了一个班级信息录入,为了程序小而精美,容易看懂,动手写了一个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