利用反射封装对象到List

最新推荐文章于 2021-07-08 18:27:59 发布

原创最新推荐文章于 2021-07-08 18:27:59 发布 · 352 阅读

0 ·

CC 4.0 BY-SA版权

封装类型专栏收录该内容

5 篇文章

订阅专栏

这是一个关于如何使用C#的MySqlDbHelper类通过反射和存储过程来执行数据库操作的示例，包括添加、删除、修改记录以及查询数据。该类连接到指定的MySQL数据库，并提供了ProcProcExecuteNonQuery、ProcExecuteScalar和ProcDataAdapter等方法，用于执行不同的数据库操作。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
//引用命名空间
using MySql.Data.MySqlClient;
using MySql.Data;
using System.Data;

namespace DAL
{
public class MySqlDbHelper
{
//连接数据库
//MySqlConnection conn = new MySqlConnection("");
//public static string connection = "";
static string connectionStrings = "Server=127.0.0.1;Database=周考二;Uid=root;Pwd=root;";

/// <summary>
/// 利用存储过程返回受影响行数添加删除修改
/// </summary>
/// <param name="parameter"></param>
/// <param name="procName"></param>
/// <returns></returns>
public static int ProcProcExecuteNonQuery(CommandType commType,string procName, MySqlParameter[] parm=null)
{
using (MySqlConnection conn=new MySqlConnection(connectionStrings))
{
MySqlCommand cmd = new MySqlCommand(procName);
cmd.Connection = conn;
conn.Open();
cmd.CommandType = commType;
if (parm!=null )
{
cmd.Parameters.AddRange(parm);
}
int i = cmd.ExecuteNonQuery();
return i;
}

}

/// <summary>
/// 利用存储过程,返回一行一列
/// </summary>
/// <param name="procName"></param>
/// <param name="parameter"></param>
/// <returns></returns>
public static object ProcExecuteScalar(CommandType commType, string procName, MySqlParameter[] parm = null)
{
using (MySqlConnection conn = new MySqlConnection(connectionStrings))
{
MySqlCommand cmd = new MySqlCommand(procName);
cmd.Connection = conn;
conn.Open();
cmd.CommandType = commType;
if (parm != null)
{
cmd.Parameters.AddRange(parm);
}
object obj = cmd.ExecuteScalar();
return obj;
}
}

/// <summary>
/// 利用存储过程,获取数据表查询显示
/// </summary>
/// <param name="procName"></param>
/// <param name="parm"></param>
/// <returns></returns>
public static DataTable ProcDataAdapter(CommandType commType, string procName, MySqlParameter[] parm = null)
{
using (MySqlConnection conn = new MySqlConnection(connectionStrings))
{
DataTable dt = new DataTable("com");
MySqlCommand cmd = new MySqlCommand(procName);
cmd.Connection = conn;
conn.Open();
cmd.CommandType = commType;
if (parm!=null)
{
cmd.Parameters.AddRange(parm);
}
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
return dt;
}
}
}
}