sqlhelper.cs

用ASP.NET（C#）、SQL Server2000数据库开发在线考试系统源代码

using System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.Collections;

namespace ExamineSystem
{
	/// <summary>
	/// Summary description for SQLHelper.
	/// </summary>
	public abstract class SQLHelper 
	{
		/// <summary>
		/// 数据库链接字符串
		/// </summary>
		public static readonly string DBCONNECTIONSTRING = ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"];
	
		/// <summary>
		/// 参数缓冲哈希表
		/// </summary>
		private static Hashtable paramCache = Hashtable.Synchronized(new Hashtable());

		/// <summary>
		/// 缓存参数数据到Cache中
		/// </summary>
		/// <param name="cacheKey"></param>
		/// <param name="cmdParms"></param>
		public static void CacheParameters(string cacheKey, params SqlParameter[] cmdParms) 
		{
			SQLHelper.paramCache[cacheKey] = cmdParms;
		}

		/// <summary>
		/// 为Command添加参数
		/// </summary>
		/// <param name="myCommand"></param>
		/// <param name="mySqlParamter"></param>
		public static void AddMyCommandParams(SqlCommand myCommand,SqlParameter[] mySqlParamter)
		{
			foreach(SqlParameter param in mySqlParamter)
			{
				myCommand.Parameters.Add(param);
			}
		}

		/// <summary>
		/// 为DataAdapter添加参数
		/// </summary>
		/// <param name="myDataAdapter"></param>
		/// <param name="mySqlParamter"></param>
		public static void AddDataAdapterParam(SqlDataAdapter myDataAdapter,SqlParameter[] mySqlParamter)
		{
			foreach(SqlParameter param in mySqlParamter)
			{
				myDataAdapter.SelectCommand.Parameters.Add(param);
			}
		}

		/// <summary>
		/// 从Cache中取到缓存参数数据
		/// </summary>
		/// <param name="cacheKey"></param>
		/// <returns></returns>
		public static SqlParameter[] GetCachedParameters(string cacheKey) 
		{
			SqlParameter[] cachedParms = (SqlParameter[])SQLHelper.paramCache[cacheKey];			
			if (cachedParms == null)
			{
				return null;
			}
			
			SqlParameter[] clonedParms = new SqlParameter[cachedParms.Length];
			for (int i = 0, j = cachedParms.Length; i < j; i++)
			{
				clonedParms[i] = (SqlParameter)((ICloneable)cachedParms[i]).Clone();
			}

			return clonedParms;
		}
	}
}