sql数据访问接口类

this.connection.Open();
}
if (this.connection.State.Equals(ConnectionState.Closed))//如果连接状态是关闭的
{
}
//调用名为cmdText的存储过程
public SqlDataReader ExecuteDataReader(string cmdText)
{
SqlCommand cmd = new SqlCommand();
{
//this.Open();
cmd.Connection = conn;
cmd.Transaction = trans;//把事务和command关联
mandText = cmdTxt;
cmd.Parameters.Clear();
}
//对数据库进行增删改方法
public object ExcuteNonQueryReturn(SqlTransaction trans,CommandType ct, string cmdTxt, SqlParameter[] cmdParms)
cmd.Parameters.Add(parm);
}
}
}
/// <summary>
/// 对数据库进行增删改方法
/// </summary>
{
public class DataBase
{
string connectString;
SqlConnection connection;
public DataBase()
{
this.connectString = ConfigurationSettings.AppSettings["conn"];
using System.Linq;
using System.Web;
using System.Xml.Linq;
using System.Data.SqlClient;
/// <summary>
///DataBase 的摘要说明
/// </summary>
namespace mon
SqlDataReader rdr = cmd.ExecuteReader();
/// <param name="ct">SqlCommand对象的命令类型</param>
/// <param name="cmdTxt">SqlCommand对象的文本</param>
/// <param name="cmdParms">SqlCommand对象的参数</param>
{
cmd.Parameters.Add(parm);
}
}
}
public void Preparecommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType ct, string cmdTxt, SqlParameter[] cmdParms)
this.Preparecommand(cmd, ct, cmdTxt, cmdParms);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
this.Close();
object ob = cmd.Parameters["@Return"].Value;//获取数组中名为"@Return"的值(orderId)赋给ob
return ob;
}
/// <summary>
this.connection.Open();
}
}
public void Close()
{
if (this.connection != null)//如果连接存在
mandText = cmdTxt;
mandType = ct;
if (cmdParms != null)//如果使用存储过程
{
foreach (SqlParameter parm in cmdParms)
{
this.connection.Close();
}
}
public SqlConnection GetConnection()
{
this.Open();
SqlConnection conn = new SqlConnection(connectString);
try
{
this.Preparecommand(cmd, conn, null, CommandType.StoredProcedure, cmdText, null);
/// 读取数据
/// </summary>
/// <param name="ct">SqlCommand对象的命令类型</param>
/// <param name="cmdTxt">SqlCommand对象的文本</param>
{
SqlCommand cmd = new SqlCommand();
this.Preparecommand(cmd,trans.Connection,trans, ct, cmdTxt, cmdParms);
cmd.ExecuteNonQuery();
public void Preparecommand(SqlCommand cmd, CommandType ct, string cmdTxt, SqlParameter[] cmdParms)
{
this.Open();//打开连接
cmd.Connection = this.connection;//指明这个Command是基于我打开的这个连接
///
public void ExcuteNonQuery(CommandType ct, string cmdTxt, SqlParameter[] cmdParms)//对数据库进行增删改方法
{
SqlCommand cmd = new SqlCommand();
{
SqlCommand cmd = new SqlCommand();
this.Preparecommand(cmd, ct, cmdTxt, cmdParms);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
/// <param name="ct">SqlCommand对象的命令类型</param>
/// <param name="cmdTxt">SqlCommand对象的文本</param>
/// <param name="cmdParms">SqlCommand对象的参数</param>
{
SqlCommand cmd = new SqlCommand();
this.Preparecommand(cmd,trans.Connection,trans,ct, cmdTxt, cmdParms);
cmd.ExecuteNonQuery();
sql数据访问接口类.txt14热情是一种巨大的力量，从心灵内部迸发而出，激励我们发挥出无穷的智慧和活力；热情是一根强大的支柱，无论面临怎样的困境，总能催生我们乐观的斗志和顽强的毅力……没有热情，生命的天空就没的色彩。using System;
using System.Data;
using System.Configuration;
/// <param name="arms">SqlCommand对象的参数</param>
/// <returns></returns>
public SqlDataReader ExcuteDataReader(CommandType ct, string cmdTxt, SqlParameter[] cmdParms)//读取数据
return connection;
}
/// <summary>
/// 对SqlCommand属性作设置
/// </summary>
/// <param name="cmd">SqlCommand对象</param>
}
public void Open()
{
if (this.connection == null)
{
this.connection = new SqlConnection(this.connectString);//建立一个连接
}
//对数据库进行增删改方法（使用事务）
public void ExcuteNonQuery(SqlTransaction trans,CommandType ct, string cmdTxt, SqlParameter[] cmdParms)
mandType = ct;
if (cmdParms != null)//如果使用存储过程