中文的SqlHelper详解.docVIP

? 中文的SqlHelper.cs类?? ?? //这是在网上找的中文解释的SqlHelper using?System;using?System.Configuration;using?System.Data;using?System.Data.SqlClient;using?System.Collections;?namespace?com.DataAccess{?????///?summary????///?SqlHelper类提供很高的数据访问性能,?????///?使用SqlClient类的通用定义.????///?/summary????public?abstract?class?SqlHelper????{?????????//定义数据库连接串????????public?static?readonly?string?ConnectionStringLocalTransaction?=?ConfigurationManager.ConnectionStrings[TestConnectionString].ConnectionString;????????//public?static?readonly?string?ConnectionStringInventoryDistributedTransaction?=?ConfigurationManager.ConnectionStrings[SQLConnString2].ConnectionString;????????//public?static?readonly?string?ConnectionStringOrderDistributedTransaction?=?ConfigurationManager.ConnectionStrings[SQLConnString3].ConnectionString;????????//public?static?readonly?string?ConnectionStringProfile?=?ConfigurationManager.ConnectionStrings[SQLProfileConnString].ConnectionString;?????????//?存贮Cache缓存的Hashtable集合????????private?static?Hashtable?parmCache?=?Hashtable.Synchronized(new?Hashtable());?????????///?summary????????///?使用连接字符串，执行一个SqlCommand命令（没有记录返回）????????///?使用提供的参数集.????????///?/summary????????///?remarks????????///?示例:??????????///??int?result?=?ExecuteNonQuery(connString,?CommandType.StoredProcedure,?PublishOrders,?new?SqlParameter(@prodid,?24));????????///?/remarks????????///?param?name=connectionString一个有效的SqlConnection连接串/param????????///?param?name=commandType命令类型CommandType(stored?procedure,?text,?etc.)/param????????///?param?name=commandText存贮过程名称或是一个T-SQL语句串/param????????///?param?name=commandParameters执行命令的参数集/param????????///?returns受此命令影响的行数/returns????????public?static?int?ExecuteNonQuery(string?connectionString,?CommandType?cmdType,?string?cmdText,?params?SqlParameter[]?commandParameters)????????{?????????????SqlCommand?cmd?=?new?SqlCommand();?????????????using?(SqlConnection?conn?=?new?SqlConnection