/**
Company:
Name:?Access數(shù)據(jù)庫(kù)訪問(wèn)助手類
Author:?lihaibo
DateTime:?2009-5-7?16:23:22
*/

using?System;
using?System.Collections.Generic;
using?System.Text;

using?System.Data;
using?System.Data.OleDb;
using?System.Configuration;

namespace?AccessDAL
{
????public?class?AccessHelper
????{
		//連接字符串
????????private?static?string?StrCon?=?ConfigurationManager.ConnectionStrings[“Access“].ConnectionString;
		
		#region?查詢返回OleDbDataReader
????????public?static?OleDbDataReader?GetReader（string?sql?OleDbParameter[]?parms）
????????{
			OleDbConnection?con?=?new?OleDbConnection（StrCon）;????????????
????????????OleDbCommand?com?=?new?OleDbCommand（sql?con）;
????????????com.CommandType?=?CommandType.Text;
????????????if?（parms?!=?null）
????????????{
????????????????com.Parameters.AddRange（parms）;
????????????}
			con.Open（）;
????????????OleDbDataReader?reader?=?com.ExecuteReader（CommandBehavior.CloseConnection）;
			//此處不能關(guān)con用完時(shí)記得關(guān)閉reader
????????????com.Parameters.Clear（）;
????????????return?reader;
????????}
		//重載
????????public?static?OleDbDataReader?GetReader（string?sql）
????????{
????????????return?GetReader（sql?null）;
????????}
		#endregion
		
		#region?查詢返回DataSet
????????public?static?DataSet?GetDataSet（string?sql?OleDbParameter[]?parms）
????????{
????????????DataSet?ds?=?new?DataSet（）;???
????????????????try
????????????????{
					using?（OleDbConnection?con?=?new?OleDbConnection（StrCon））
????????????		{
						OleDbCommand?com?=?new?OleDbCommand（sql?con）;
						com.CommandType?=?CommandType.Text;
						if?（parms?!=?null）
						{
							com.Parameters.AddRange（parms）;
						}
						OleDbDataAdapter?adapter?=?new?OleDbDataAdapter（com）;?
						con.Open（）;
						adapter.Fill（ds）;
						com.Parameters.Clear（）;?????
						con.Close（）;						???????????????
????????????????	}?
				}
????????????????catch?（Exception?e）
????????????????{
????????????????????string?ex?=?e.Message;
????????????????}???????????
????????????return?ds;
????????}
		//重載
????????public?static?DataSet?GetDataSet（string?sql）
????????{
????????????return?GetDataSet（sql?null）;
????????}
		#endregion
				
		#region?增、刪、改
????????public?static?int?ExcuteSQL（string?sql?OleDbParameter[]?parms）
????????{
????????????int?rows?=?-1;????????????
????????????????try
????????????????{
					using?（OleDbConnection?con?=?new?OleDbConnection（StrCon））
					{???????????????????
						OleDbCommand?com?=?new?OleDbCommand（sqlcon）;
						com.CommandType?=?CommandType.Text;
						if?（parms?!=?null）
						{
							com.Parameters.AddRange（parms）;
						}
						con.Open（）;
						rows?=?com.ExecuteNonQuery（）;
						com.Parameters.Clear（）;??????
						con.Close（）;						??????????????
????????????????	}
				}
				catch?（Exception?e）
????????????????{
????????????????????string?ex?=?e.Message;
????????????????}????????????
????????????return?rows?;
????????}
		//重載
????????public?static?int?ExcuteSQL（string?s