sql数据访问接口类.docVIP

using System; using System.Data; using System.Configuration; using System.Linq; using System.Web; using System.Xml.Linq; using System.Data.SqlClient; /// summary ///DataBase 的摘要说明 /// /summary namespace BookShop.Common { public class DataBase { string connectString; SqlConnection connection; public DataBase() { this.connectString = ConfigurationSettings.AppSettings[conn]; } public void Open() { if (this.connection == null) { this.connection = new SqlConnection(this.connectString);//建立一个连接 this.connection.Open(); } if (this.connection.State.Equals(ConnectionState.Closed))//如果连接状态是关闭的 { this.connection.Open(); } } public void Close() { if (this.connection != null)//如果连接存在 { this.connection.Close(); } } public SqlConnection GetConnection() { this.Open(); return connection; } /// summary /// 对SqlCommand属性作设置 /// /summary /// param name=cmdSqlCommand对象/param /// param name=ctSqlCommand对象的命令类型/param /// param name=cmdTxtSqlCommand对象的文本/param /// param name=cmdParmsSqlCommand对象的参数/param public void Preparecommand(SqlCommand cmd, CommandType ct, string cmdTxt, SqlParameter[] cmdParms) { this.Open();//打开连接 cmd.Connection = this.connection;//指明这个Command是基于我打开的这个连接 cmd.CommandText = cmdTxt; cmd.CommandType = ct; if (cmdParms != null)//如果使用存储过程 { foreach (SqlParameter parm in cmdParms) { cmd.Parameters.Add(parm); } } } public void Preparecommand(SqlCommand cmd, SqlConnection conn, SqlTransaction tran