using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace DAL
{
public class SQLHelper
{
private string connStr = null;
private SqlConnection conn = null;
private SqlCommand cmd = null;
private SqlDataReader sdr = null;
public SQLHelper()
{
//connStr=Web.config连接字符串
connStr=@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Db.mdf;Integrated Security=True;User Instance=True";
/*
<connectionStrings>
<add name="DbConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Db.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
*/
conn = new SqlConnection(connStr);
}
/// <summary>
/// 获取Connection对象
/// </summary>
/// <returns></returns>
private SqlConnection GetConn()
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
return conn;
}
/// <summary>
/// 执行查询
/// </summary>
/// <param name="cmdText">要执行的sql语句、或存储过程名</param>
/// <param name="ct">cmdType类型</param>
/// <returns></returns>
public DataTable ExecuteQuery(string cmdText,CommandType ct)
{
DataTable dt = new DataTable();
cmd = new SqlCommand(cmdText, GetConn());
cmd.CommandType = ct;
using (sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))//关闭cmd同时关闭conn
{
dt.Load(sdr);
}
return dt;
}
/// <summary>
/// 执行带参数的查询
/// </summary>
/// <param name="cmdText">要执行的sql语句、或存储过程名</param>
/// <param name="para">Para参数</param>
/// <param name="ct">cmdType类型</param>
/// <returns></returns>
public DataTable ExecuteQuery(string cmdText, SqlParameter[] para,CommandType ct)
{
DataTable dt = new DataTable();
cmd = new SqlCommand(cmdText, GetConn());
cmd.CommandType = ct;
cmd.Parameters.AddRange(para);
using (sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))//关闭cmd同时关闭conn
{
dt.Load(sdr);
}
return dt;
}
/// <summary>
/// 执行sql增删改
/// </summary>
/// <param name="cmdText">要执行的sql语句、或存储过程名</param>
/// <param name="ct">cmdType类型</param>
/// <returns></returns>
public int ExecuteNoQuery(string cmdText,CommandType ct)
{
int res;
cmd = new SqlCommand(cmdText, GetConn());
cmd.CommandType = ct;
try
{
res = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return res;
}
/// <summary>
/// 执行sql增删改
/// </summary>
/// <param name="cmdText">要执行的sql语句、或存储过程名</param>
/// <param name="para">Para参数</param>
/// <param name="ct">cmdType类型</param>
/// <returns></returns>
public int ExecuteNoQuery(string cmdText, SqlParameter[] para,CommandType ct)
{
int res;
cmd = new SqlCommand(cmdText, GetConn());
cmd.CommandType=ct;
cmd.Parameters.AddRange(para);
try
{
res = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return res;
}
/// <summary>
/// 执行返回单一数据的sql语句
/// </summary>
/// <param name="sql">要执行的sql语句</param>
/// <returns></returns>
/* public object ExecuteScalar(string sql)
{
object res;
cmd = new SqlCommand(sql, GetConn());
try
{
res = cmd.ExecuteScalar();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return res;
}
*/
}
}
/*
林舜煌
*/
using System;
using System.Collections.Generic;
using System.Web;
using System.Data.OleDb;
using System.Data;
using System.Configuration;
/// <summary>
///OldHelper access数据库助手类
/// </summary>
namespace DAL
{
public class OledbHelper
{
private string connStr = null;
private OleDbConnection conn = null;
private OleDbCommand cmd = null;
private OleDbDataReader sdr = null;
public OledbHelper()
{
/*
<connectionStrings>
<add name="DbConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\WebSite2\App_Data\db1.mdb;Persist Security Info=True" />
</connectionStrings>
connStr = ConfigurationManager.ConnectionStrings["DbConnectionString"].ConnectionString;
*/
connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\WebSite2\App_Data\db1.mdb;Persist Security Info=True";
conn = new OleDbConnection(connStr);
}
/// <summary>
/// 获取Connection对象
/// </summary>
/// <returns></returns>
private OleDbConnection GetConn()
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
return conn;
}
/// <summary>
/// 执行查询
/// </summary>
/// <param name="cmdText">要执行的sql语句、或存储过程名</param>
/// <param name="ct">cmdType类型</param>
/// <returns></returns>
public DataTable ExecuteQuery(string cmdText, CommandType ct)
{
DataTable dt = new DataTable();
cmd = new OleDbCommand(cmdText, GetConn());
cmd.CommandType = ct;
using (sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))//关闭cmd同时关闭conn
{
dt.Load(sdr);
}
return dt;
}
/// <summary>
/// 执行带参数的查询
/// </summary>
/// <param name="cmdText">要执行的sql语句、或存储过程名</param>
/// <param name="para">Para参数</param>
/// <param name="ct">cmdType类型</param>
/// <returns></returns>
public DataTable ExecuteQuery(string cmdText, OleDbParameter[] para, CommandType ct)
{
DataTable dt = new DataTable();
cmd = new OleDbCommand(cmdText, GetConn());
cmd.CommandType = ct;
cmd.Parameters.AddRange(para);
using (sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))//关闭cmd同时关闭conn
{
dt.Load(sdr);
}
return dt;
}
/// <summary>
/// 执行sql增删改
/// </summary>
/// <param name="cmdText">要执行的sql语句、或存储过程名</param>
/// <param name="ct">cmdType类型</param>
/// <returns></returns>
public int ExecuteNoQuery(string cmdText, CommandType ct)
{
int res;
cmd = new OleDbCommand(cmdText, GetConn());
cmd.CommandType = ct;
try
{
res = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return res;
}
/// <summary>
/// 执行sql增删改
/// </summary>
/// <param name="cmdText">要执行的sql语句、或存储过程名</param>
/// <param name="para">Para参数</param>
/// <param name="ct">cmdType类型</param>
/// <returns></returns>
public int ExecuteNoQuery(string cmdText, OleDbParameter[] para, CommandType ct)
{
int res;
cmd = new OleDbCommand(cmdText, GetConn());
cmd.CommandType = ct;
cmd.Parameters.AddRange(para);
try
{
res = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return res;
}
/// <summary>
/// 执行返回单一数据的sql语句
/// </summary>
/// <param name="sql">要执行的sql语句</param>
/// <param name="para">参数集</param>
/// <returns></returns>
public object ExecuteScalar(string cmdText, OleDbParameter[] para, CommandType ct)
{
object res;
cmd = new OleDbCommand(cmdText, GetConn());
cmd.CommandType = ct;
cmd.Parameters.AddRange(para);
try
{
res = cmd.ExecuteScalar();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return res;
}
/// <summary>
/// 执行返回单一数据的sql语句
/// </summary>
/// <param name="sql">要执行的sql语句</param>
/// <returns></returns>
public object ExecuteScalar(string cmdText, CommandType ct)
{
object res;
cmd = new OleDbCommand(cmdText, GetConn());
cmd.CommandType = ct;
try
{
res = cmd.ExecuteScalar();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return res;
}
}
}
分享到:
相关推荐
C#实现TCP与UDP助手类小案例,可以用于学习。。。。。
(代码模板)新建一个SQLiteOpenHelper助手类.xml
因为工作至今接触的数据库还算比较全面,每次搭建新项目开发数据库选择后,都要编写整理对应的.NET与数据库交互的DBHelper助手类,时间一长,便将各类型数据库助手类整理出来共享,在提升大家开发效率的同时,减少...
链接数据库
NULL 博文链接:https://walleyekneel.iteye.com/blog/1035857
微信支付助手类类,实例中写的很详细,请参看我的博客
本教学部分简单介绍了在微软原版的数据库访问助手基础之上改造的数据库访问助手类的功能。 本课程教程为本人原创,欢迎学习使用,请勿使用商业用途。 开发IDE为VS2013,数据库为MS SQL 2012。 本资源中有视频教程和...
这个助手类主要特点,Memcache连接复用,一个http请求只使用一个Memcache连接,使用Key前缀,使多个项目共享Memcache实例,这个助手类可用于任意框架(codeigniter可放于helper文件夹下).
数据库增删改差功能的数据库助手类,适合新人学习使用.高手闪过.用C#写的,可以用在C/S架构或B/S架构
RxSwift的助手类和扩展
noCAPTCHA - Google的noCAPTCHA (reCAPTCHA)的助手类
ExcelHelper 导入/导出 助手类,采用NPOI,已经封闭好了导入导出接口
这个助手类主要特点,Memcache连接复用,一个http请求只使用一个Memcache连接,使用Key前缀,使多个项目共享Memcache实例,这个助手类可用于任意框架(codeigniter可放于helper文件夹下).
go-funk: 一个现代的Go工具库提供一些助手类(map, find, contains, filter, ...)
1.常见的串口 (1)RS-232接口:通常适合于数据传输频率在0~20000bps范围的通信。... 不足:抗干扰能力差,通信距离短,速率低。 (2)RS-422/485接口:传输速度和通信距离变得非常远(1200m),并且在一条平衡总线...
dry_crud 帮你生成简单和可扩展的控制权、视图以及助手类 (Ruby on Rails),用以实现符合DRY(Don't Repeat Yourself)原则的CRU代码。
搜集的一组 C# 工具助手类 (C# tools a set of helper classes) .NET 版本 .NET Framework 4.6.2 目前包括助手类 (Currently includes): RequestHelper: 助手(HttpWebRequest helper) 支持 GET/POST 下载 HTML 或者 ...
数据库的使用,包含增删改查,是使用android 内置的数据库助手类实现的
thinkphp6 常用的一些扩展类库 ...以下类库都在\\think\\helper命名空间下 Str 字符串操作 // 检查字符串中是否包含某些字符串 Str::contains($haystack, $needles) // 检查字符串是否以某些字符串结尾 ...
/// /// 获取指定页面的HTML代码 /// /// 指定页面的路径 /// 回发的数据 /// 是否以post方式发送请求 /// <param name="cookieCollection">Cookie集合 /// <returns></returns>