DbHelper
发布日期:2021-06-28 17:03:50
浏览次数:3
分类:技术文章
本文共 3112 字,大约阅读时间需要 10 分钟。
using System.Collections.Generic;
using System.Data; using System.Data.Common;namespace ConsoleApp1
{ public class DbHelper { #region 私有成员/// <summary>
/// 数据库类型 /// </summary> private static string ProviderName;/// <summary>
/// 连接字符串 /// </summary> private static string ConnectionString;#endregion
#region 外部接口
/// <summary>
/// 通过数据库连接字符串和Sql语句查询返回DataTable /// </summary> /// <param name="sql">Sql语句</param> /// <returns></returns> public static DataTable GetDataTableWithSql(string sql) { DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory(ProviderName); using (DbConnection conn = dbProviderFactory.CreateConnection()) { conn.ConnectionString = ConnectionString; conn.Open();using (DbCommand cmd = conn.CreateCommand())
{ cmd.Connection = conn; cmd.CommandText = sql;DbDataAdapter adapter = dbProviderFactory.CreateDataAdapter();
adapter.SelectCommand = cmd; DataSet table = new DataSet(); adapter.Fill(table); cmd.Parameters.Clear(); return table.Tables[0]; } } }/// <summary>
/// 通过数据库连接字符串和Sql语句查询返回DataTable,参数化查询 /// </summary> /// <param name="sql">Sql语句</param> /// <param name="parameters">参数</param> /// <returns></returns> public static DataTable GetDataTableWithSql(string sql, List<DbParameter> parameters) { DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory(ProviderName); using (DbConnection conn = dbProviderFactory.CreateConnection()) { conn.ConnectionString = ConnectionString; conn.Open();using (DbCommand cmd = conn.CreateCommand())
{cmd.Connection = conn;
cmd.CommandText = sql; if (parameters != null && parameters.Count > 0) { foreach (var item in parameters) { cmd.Parameters.Add(item); } } DbDataAdapter adapter = dbProviderFactory.CreateDataAdapter(); adapter.SelectCommand = cmd; DataSet table = new DataSet(); adapter.Fill(table); cmd.Parameters.Clear();return table.Tables[0];
} } }/// <summary>
/// 执行无返回值的Sql语句 /// </summary> /// <param name="sql">Sql语句</param> public static int ExecuteSql(string sql) { int count = 0; DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory(ProviderName); using (DbConnection conn = dbProviderFactory.CreateConnection()) { conn.ConnectionString = ConnectionString; conn.Open(); using (DbCommand cmd = dbProviderFactory.CreateCommand()) { cmd.Connection = conn; cmd.CommandText = sql; count = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return count; } } }/// <summary>
/// 执行无返回值的Sql语句 /// </summary> /// <param name="sql">Sql语句</param> /// <param name="spList">查询参数</param> public static int ExecuteSql(string sql, List<DbParameter> paramters) { int count = 0; DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory(ProviderName); using (DbConnection conn = dbProviderFactory.CreateConnection()) { conn.ConnectionString = ConnectionString; conn.Open(); using (DbCommand cmd = dbProviderFactory.CreateCommand()) { cmd.Connection = conn; cmd.CommandText = sql;if (paramters != null && paramters.Count > 0)
{ foreach (var item in paramters) { cmd.Parameters.Add(item); } } count = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return count; } } }#endregion
} }转载地址:https://blog.csdn.net/xiexuzhao/article/details/103140964 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!
发表评论
最新留言
路过按个爪印,很不错,赞一个!
[***.219.124.196]2024年04月01日 20时45分13秒
关于作者
喝酒易醉,品茶养心,人生如梦,品茶悟道,何以解忧?唯有杜康!
-- 愿君每日到此一游!
推荐文章
javascript获取当前时间时间戳的几种方法
2019-04-29
微信小程序App()的作用与getApp()方法
2019-04-29
快速新建新建Vue项目(详细)
2019-04-29
vue项目启动自动开启浏览器
2019-04-29
Vue中 @表示的路径
2019-04-29
Vue实现简单路由跳转
2019-04-29
【vue系列】class动态绑定
2019-04-29
动态表格
2019-04-29
Mock 造假数据
2019-04-29
HTML5中哪些标签可以用来做SEO优化
2019-04-29
git 命令
2019-04-29
eslint
2019-04-29
js 深拷贝封装
2019-04-29
使用 keep-alive 需要判断路由from 走active
2019-04-29
elementui 表格上加小问号 鼠标移入提示文字
2019-04-29
linux操作swap文件
2019-04-29
node同步异步读取文件
2019-04-29
node异步操作与闭包函数
2019-04-29
node同步异步写入文件
2019-04-29
node读取二进制文件
2019-04-29