本文為大家分享了4種常見的ASP.NET頁面緩存方式，供大家參考，具體內容如下
1、分布式緩存Memcached，教程下載
2、內存緩存，此占用服務器資源
#region 內存緩存
public class MemoryCache
{
#region 寫
/// <summary>
/// 向內存寫入數據緩存
/// </summary>
/// <remarks>TOMMYHU2011-7-28 10:25創建</remarks>
/// <param name="cachekey">緩存標識關鍵字</param>
/// <param name="cacheresult">需要存放的數據</param>
/// <param name="cachetime">單位秒</param>
public static void InertMemoryCache(string cachekey, object cacheresult, int cachetime)
{
if (cacheresult != null)
{
System.Web.HttpRuntime.Cache.Insert(cachekey, cacheresult, null
, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromSeconds(cachetime));
}
}
#endregion
#region 讀
/// <summary>
/// 根據緩存標識讀取內存緩存信息
/// </summary>
/// <remarks>TOMMYHU2011-7-28 10:25創建</remarks>
/// <param name="cachekey">緩存標識關鍵字</param>
/// <returns>內存緩存數據</returns>
public static object ReadMemoryCache(string cachekey)
{
object obj = System.Web.HttpRuntime.Cache.Get(cachekey);
if (obj != null)
{
return obj;
}
return null;
}
#endregion
}
#endregion 3、XML緩存，這種最為常見
#region xml緩存
public static class XmlCache
{
private static string m_CacheFolderName = null;
#region 獲取/生成緩存文件方法(無cmdParams)
/// <summary>
/// 獲取/生成緩存文件方法(DataTable)
/// </summary>
/// <param name="SQL">用于將Sql轉化為MD5字符串</param>
/// <param name="CacheFilePath">存放Xml文件的相對路徑(根目錄已預置)</param>
/// <param name="CacheTime">緩存時間</param>
/// <param name="DataUsed">使用的數據庫的鏈接字符串</param>
/// <returns></returns>
public static DataTable CacheFileByDataTable(string SQL, string CacheFilePath, int CacheTime)
{
SQLHelper.SQLHelper QuerySql = new SQLHelper.SQLHelper();
if (CacheFilePath != string.Empty && CacheFilePath.StartsWith("/"))
{
CacheFilePath = CacheFilePath.Remove(0, 1);
}
string SqlMd5 = SQL;//用于將Sql轉化為MD5字符串
string StrSqlByMd5 = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(SqlMd5, "MD5");//生成的Md5文件名
string MyCacheFilePath = "";
if (CacheTime >= 10000)//如果大于20天的話系統默認為持久
{
MyCacheFilePath = XmlCache.CacheFolderNameP + CacheFilePath;//用于存放Xml文件的相對路徑
}
else
{
MyCacheFilePath = XmlCache.CacheFolderName + CacheFilePath;//用于存放Xml文件的相對路徑
}
int MyCacheTime = CacheTime;//緩存時間(分)
DataTable dt = new DataTable();//存放數據記錄的DataTable
DataTable CacheDt = new DataTable();//獲取緩存數據記錄的DataTable
//嘗試獲取緩存數據記錄
try
{
CacheDt = DataTableCache.GetDTCache(MyCacheTime, MyCacheFilePath, StrSqlByMd5);
}
catch
{
CacheDt = null;
}
if (CacheDt != null)//獲取到緩存的XML文件
{
dt = CacheDt;
}
else//未獲取到緩存的XML文件
{
//生成DataTable(如果用Query查詢請用Query.ProcessSql方法)
//dt = Query.ProcessSql(SqlMd5, DataUsed);
dt = QuerySql.retDT(SQL);
//將DataTable存為XML文件
try
{
if (dt.DataSet != null)
{
dt.DataSet.Tables.Remove(dt);
}
DataTableCache.SetDTCache(MyCacheFilePath, StrSqlByMd5, dt);
}
catch (Exception ex)
{
//Log.GetComLogger().Error("將DataTable存為XML文件出錯：" + ex.Message);
}
}
return dt;
}
/// <summary>
/// 獲取/生成緩存文件方法(DataSet) Add By WJ 08-10-23
/// </summary>
/// <param name="SQL">用于將Sql轉化為MD5字符串</param>
/// <param name="CacheFilePath">存放Xml文件的相對路徑(根目錄已預置)</param>
/// <param name="CacheTime">緩存時間</param>
/// <param name="DBName">使用的數據庫的鏈接字符串</param>
/// <returns></returns>
public static DataSet CacheFileByDataSet(string SQL, string CacheFilePath, int CacheTime)
{
SQLHelper.SQLHelper QuerySql = new SQLHelper.SQLHelper();
if (CacheFilePath != string.Empty && CacheFilePath.StartsWith("/"))
{
CacheFilePath = CacheFilePath.Remove(0, 1);
}
string SqlMd5 = SQL;//用于將Sql轉化為MD5字符串
string StrSqlByMd5 = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(SqlMd5, "MD5");//生成的Md5文件名
string MyCacheFilePath = XmlCache.CacheFolderName + CacheFilePath;//用于存放Xml文件的相對路徑
int MyCacheTime = CacheTime;//緩存時間(分)
DataSet ds = new DataSet();//存放數據記錄的DataSet
DataSet CacheDs = new DataSet();//獲取緩存數據記錄的DataSet
//嘗試獲取緩存數據記錄
try
{
CacheDs = DataTableCache.GetDSCache(MyCacheTime, MyCacheFilePath, StrSqlByMd5);
}
catch
{
CacheDs = null;
}
if (CacheDs != null)//獲取到緩存的XML文件
{
ds = CacheDs;
}
else//未獲取到緩存的XML文件
{
//生成DataSet
//ds = Query.ProcessMultiSql(SqlMd5, DBName);
ds = QuerySql.retDS(SQL);
//將DataSet存為XML文件
try
{
DataTableCache.SetDSCache(MyCacheFilePath, StrSqlByMd5, ds);
}
catch
{ }
}
return ds;
}
#endregion
#region 獲取/生成緩存文件方法(有cmdParams)
/// <summary>
/// 獲取/生成緩存文件方法(DataTable)
/// </summary>
/// <param name="SQL">用于將Sql轉化為MD5字符串</param>
/// <param name="CacheFilePath">存放Xml文件的相對路徑(根目錄已預置)</param>
/// <param name="CacheTime">緩存時間</param>
/// <param name="DataUsed">使用的數據庫的鏈接字符串</param>
/// <param name="cmdParams">以數組形式提供SqlCommand命令中用到的參數列表</param>
/// <returns></returns>
public static DataTable CacheFileByDataTable(string SQL, string CacheFilePath, int CacheTime, string DBConstr, params SqlParameter[] cmdParams)
{
SQLHelper.SQLHelper QuerySql = new SQLHelper.SQLHelper();
if (CacheFilePath != string.Empty && CacheFilePath.StartsWith("/"))
{
CacheFilePath = CacheFilePath.Remove(0, 1);
}
string SqlMd5 = SQL;//用于將Sql轉化為MD5字符串
string sqlmd5params = SQL;
if (cmdParams != null)
{
for (int i = 0; i < cmdParams.Length; i++)
{
if (cmdParams[i].Value != null)
sqlmd5params += cmdParams[i].Value.ToString();
}
}
string StrSqlByMd5 = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(sqlmd5params, "MD5");//生成的Md5文件名
string MyCacheFilePath = "";
if (CacheTime >= 10000)//如果大于20天的話系統默認為持久
{
MyCacheFilePath = XmlCache.CacheFolderNameP + CacheFilePath;//用于存放Xml文件的相對路徑
}
else
{
MyCacheFilePath = XmlCache.CacheFolderName + CacheFilePath;//用于存放Xml文件的相對路徑
}
int MyCacheTime = CacheTime;//緩存時間(分)
DataTable dt = new DataTable();//存放數據記錄的DataTable
DataTable CacheDt = new DataTable();//獲取緩存數據記錄的DataTable
//嘗試獲取緩存數據記錄
CacheDt = DataTableCache.GetDTCache(MyCacheTime, MyCacheFilePath, StrSqlByMd5);
if (CacheDt != null)//獲取到緩存的XML文件
{
dt = CacheDt;
}
else//未獲取到緩存的XML文件
{
//生成DataTable(如果用Query查詢請用Query.ProcessSql方法)
//dt = Query.ProcessSql(SqlMd5, DataUsed);
dt = QuerySql.retDT(SqlMd5);
DataTable dt1 = new DataTable();
if (dt != null)
{
dt1 = dt.Copy();
}
//將DataTable存為XML文件
DataTableCache.SetDTCache(MyCacheFilePath, StrSqlByMd5, dt1);
}
return dt;
}
/// <summary>
/// 獲取/生成緩存文件方法(DataSet) Add By wjf
/// </summary>
/// <param name="SQL">用于將Sql轉化為MD5字符串</param>
/// <param name="CacheFilePath">存放Xml文件的相對路徑(根目錄已預置)</param>
/// <param name="CacheTime">緩存時間</param>
/// <param name="DBName">使用的數據庫的鏈接字符串</param>
/// <param name="cmdParams">以數組形式提供SqlCommand命令中用到的參數列表</param>
/// <returns></returns>
public static DataSet CacheFileByDataSet(string SQL, string CacheFilePath, int CacheTime, string DBConstr, params SqlParameter[] cmdParams)
{
SQLHelper.SQLHelper QuerySql = new SQLHelper.SQLHelper();
string SqlMd5 = SQL;//用于將Sql轉化為MD5字符串
string sqlmd5params = SQL;
if (cmdParams != null)
{
for (int i = 0; i < cmdParams.Length; i++)
{
if (cmdParams[i].Value != null)
sqlmd5params += cmdParams[i].Value.ToString();
}
}
string StrSqlByMd5 = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(sqlmd5params, "MD5");//生成的Md5文件名
string MyCacheFilePath = XmlCache.CacheFolderName + CacheFilePath;//用于存放Xml文件的相對路徑
int MyCacheTime = CacheTime;//緩存時間(分)
DataSet ds = new DataSet();//存放數據記錄的DataSet
DataSet CacheDs = new DataSet();//獲取緩存數據記錄的DataSet
//嘗試獲取緩存數據記錄
CacheDs = DataTableCache.GetDSCache(MyCacheTime, MyCacheFilePath, StrSqlByMd5);
if (CacheDs != null)//獲取到緩存的XML文件
{
ds = CacheDs;
}
else//未獲取到緩存的XML文件
{
//生成DataSet
//ds = Query.ProcessMultiSql(SqlMd5, DBName);
ds = QuerySql.retDS(SqlMd5);
DataSet ds1 = new DataSet();
if (ds != null)
{
ds1 = ds.Copy();
}
//將DataSet存為XML文件
DataTableCache.SetDSCache(MyCacheFilePath, StrSqlByMd5, ds1);
}
return ds;
}
#endregion
#region 非持久保持
/// <summary>
/// 非持久保持
/// </summary>
public static string CacheFolderName
{
get
{
if (m_CacheFolderName == null)//如果Global.asax中未定義路徑
{
m_CacheFolderName = System.Configuration.ConfigurationManager.AppSettings.GetValues("CachePathRoot")[0];
if (m_CacheFolderName == null)//如果Web.Config中未定義路徑
{
return "/CacheData/" + DateTime.Now.ToString("yyyyMMdd") + "/";
}
else
{
return m_CacheFolderName + DateTime.Now.ToString("yyyyMMdd") + "/";
}
}
else
{
return m_CacheFolderName + DateTime.Now.ToString("yyyyMMdd") + "/";
}
}
set
{
m_CacheFolderName = value;
}
}
#endregion
#region 持久保存(例如存放MapBar緩存的數據或需要3個月以上更新的數據等)
/// <summary>
/// 持久保存(例如存放MapBar緩存的數據或需要3個月以上更新的數據等)
/// </summary>
public static string CacheFolderNameP
{
get
{
if (m_CacheFolderName == null)//如果Global.asax中未定義路徑
{
m_CacheFolderName = System.Configuration.ConfigurationManager.AppSettings.GetValues("CachePathRoot")[0];
if (m_CacheFolderName == null)//如果Web.Config中未定義路徑
{
return "/CacheData/";
}
else
{
return m_CacheFolderName;
}
}
else
{
return m_CacheFolderName;
}
}
set
{
m_CacheFolderName = value;
}
}
#endregion
}
#endregion
4、DATATABLE緩存
聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
Copyright ? 2019-2025 www.alabama37th.com 版權所有
違法及侵權請聯系：TEL:177 7030 7066 E-MAIL:11247931@qq.com 本站由北京市萬商天勤律師事務所王興未律師提供法律服務
