DbHelper
发布日期:2021-06-28 17:03:50
浏览次数:4
分类:技术文章
本文共 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 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!
发表评论
最新留言
哈哈,博客排版真的漂亮呢~
[***.90.31.176]2024年04月06日 01时32分21秒
关于作者
喝酒易醉,品茶养心,人生如梦,品茶悟道,何以解忧?唯有杜康!
-- 愿君每日到此一游!
推荐文章
java学习笔记:PreparedStatement解决sql注入
2019-04-29
java学习笔记:JDBC批处理
2019-04-29
java学习笔记:JavaBean
2019-04-29
java学习笔记:连接池
2019-04-29
java学习笔记:分层思想
2019-04-29
java学习笔记:事务管理
2019-04-29
java学习笔记:详解匿名内部类(转载)
2019-04-29
前端学习笔记:HTML(1)
2019-04-29
rocket-chip 编译
2019-04-29
Linux 上的数据可视化工具
2019-04-29
Scilab must give you power(转贴)
2019-04-29
scilab中计算B样条基函数
2019-04-29
Scilab工具箱的初步开发和使用
2019-04-29
scilab中求积分
2019-04-29
SCILAB及其在控制系统仿真中的应用
2019-04-29