using System;
using System.Data;
using System.Xml;
using System.Data.OleDb ;
using System.Collections;
namespace ePhoto.AccessDAL
{
/// <summary>
/// DBUtil 操作Access数据库
/// </summary>
public class DBUtil
{
private Hashtable parmCache = Hashtable.Synchronized(new Hashtable()); //缓存用户参数
private static string path = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
System.Web.HttpContext.Current.Server.MapPath("")+"\\"+System.Configuration.ConfigurationSettings.AppSettings["AccessDataBase"] ; //Access 数据库文件地址
/// <summary>
/// 执行单向操作，返回数据库受影响的行数使用默认连接， 执行SQL语句，仅仅返回数据库受影响行数。
/// 所需参数：命令文本，参数列表。
/// </summary>
/// <param name="cmdText">命令文本</param>
/// <param name="cmdParms">参数列表</param>
/// <returns></returns>
public static int ExecuteNonQuery(string cmdText ,params OleDbParameter[] cmdParams)
{
OleDbCommand cmd = new OleDbCommand();
using(OleDbConnection conn = new OleDbConnection(path))
{
PrepareCommand(cmd,conn,null,CommandType.Text,cmdText,cmdParams);
int val = cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Dispose();
return val ;
}
}
/// <summary>
/// 执行一个sql查询语句，返回DataReader对象。使用默认连接。
/// 所需参数：命令文本，参数列表。
/// </summary>
/// <param name="cmdText"></param>
/// <param name="cmdParms"></param>
/// <returns></returns>
public static OleDbDataReader ExecuteReader(string cmdText,params OleDbParameter[] cmdParms)
{
OleDbCommand cmd = new OleDbCommand();
OleDbConnection conn = new OleDbConnection(path);
try
{
PrepareCommand(cmd,conn,null,CommandType.Text,cmdText,cmdParms);
OleDbDataReader read = cmd.ExecuteReader(CommandBehavior.CloseConnection);
cmd.Parameters.Clear();
return read ;
}
