|
源代码网整理以下 using System;
using System.Web;
using System.Web.Caching;
using System.Configuration;
using System.Data;
using System.Data.OleDb;
using NGuestBook.Utility;
namespace NGuestBook.AccessDAL
{
/**//// <summary>
/// Access数据库操作助手
/// </summary>
public sealed class AccessDALHelper
{
/**//// <summary>
/// 读取Access数据库的连接字符串
/// 首先从缓存里读取，如果不存在则到配置文件中读取，并放入缓存
/// </summary>
/// <returns>Access数据库的连接字符串</returns>
private static string GetConnectionString()
{
if (CacheAccess.GetFromCache("AccessConnectionString") != null)
{
return CacheAccess.GetFromCache("AccessConnectionString").ToString();
}
else
{
string dbPath = ConfigurationManager.AppSettings["AccessPath"];
string dbAbsolutePath = HttpContext.Current.Server.MapPath(dbPath);
string connectionString = ConfigurationManager.AppSettings["AccessConnectionString"];
源代码网整理以下 CacheDependency fileDependency = new CacheDependency(HttpContext.Current.Server.MapPath("Web.Config"));
CacheAccess.SaveToCache("AccessConnectionString", connectionString.Replace("{DBPath}", dbAbsolutePath), fileDependency);
源代码网整理以下 return connectionString.Replace("{DBPath}", dbAbsolutePath);
}
}
源代码网整理以下 /**//// <summary>
/// 执行SQL语句并且不返回任何值
/// </summary>
/// <param name="SQLCommand">所执行的SQL命令</param>
/// <param name="parameters">参数集合</param>
public static void ExecuteSQLNonQuery(string SQLCommand,OleDbParameter[] parameters)
{
OleDbConnection connection = new OleDbConnection(GetConnectionString());
OleDbCommand command = new OleDbCommand(SQLCommand, connection);
源代码网整理以下 for (int i = 0; i < parameters.Length; i++)
{
command.Parameters.Add(parameters[i]);
}
源代码网整理以下 connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
源代码网整理以下 /**//// <summary>
/// 执行SQL语句并返回包含查询结果的DataReader
/// </summary>
/// <param name="SQLCommand">所执行的SQL命令</param>
/// <param name="parameters">参数集合</param>
/// <returns></returns>
public static OleDbDataReader ExecuteSQLDataReader(string SQLCommand,OleDbParameter[] parameters)
{
OleDbConnection connection = new OleDbConnection(GetConnectionString());
OleDbCommand command = new OleDbCommand(SQLCommand, connection);
源代码网整理以下 for (int i = 0; i < parameters.Length; i++)
{
command.Parameters.Add(parameters[i]);
}
源代码网整理以下 connection.Open();
OleDbDataReader dataReader = command.ExecuteReader();
//connection.Close();
源代码网整理以下 return dataReader;
}
}
}
|
