MySQL£¨asp.net£© ÊÂÎñ
try
{
string _conStr = "Driver={MySQL ODBC 3.51
Driver};server=localhost;database=test;uid=test;password=1;option=3";
OdbcConnection _odbcCon = new OdbcConnection(_conStr);
_odbcCon.Open();
OdbcTransaction trans = _odbcCon.BeginTransaction
(IsolationLevel.ReadCommitted);
OdbcCommand cmd = new OdbcCommand();
cmd.Connection = trans.Connection;
cmd.Transaction = trans;
string _sqlStr = "";
try
{
_sqlStr = "update test ....."
cmd.CommandText = _sqlStr;
cmd.ExecuteNonQuery();
_sqlStr = "";
}
catch
{
&n
Ïà¹ØÎĵµ£º
1¡¢DateTime Êý×ÖÐÍ
System.DateTime currentTime=new System.DateTime();
¡¡¡¡1.1 È¡µ±Ç°ÄêÔÂÈÕʱ·ÖÃë
currentTime=System.DateTime.Now;
¡¡¡¡1.2 È¡µ±Ç°Äê
int Äê=currentTime.Year;
¡¡¡¡1.3 È¡µ±Ç°Ô &n ......
»º´æµÄÖØÒªÐԾͲ»ÓÃÔÙÇ¿µ÷ÁË£¬@OutputCache¸øÎÒÃÇÌṩÁËÒ»ÖÖÉùÃ÷µÄ·½Ê½(¶ÔÓ¦µÄ»¹Óбà³ÌµÄ·½Ê½)À´¿ØÖÆÒ³ÃæºÍÓû§¿Ø¼þµÄ»º´æ²ßÂÔ£¬ÕâÊÇÒ»ÖÖ×î¼òµ¥Ö±½ÓµÄÍøÕ¾ÓÅ»¯·½Ê½¡£
»¹ÊÇÏÈÀ´¹ýÒ»±é@OutpuCacheËùÓеÄÊôÐÔ£¬¹²ÓÃ11¸öÊôÐÔ£¬Õâ¸öÖ¸Áî¿ÉÒÔÓÃÓÚÒ³Ãæ(.aspx)ºÍÓû§¿Ø¼þ(.ascx)
ÊôÐÔ
Duration
Ò³»òÓû§¿Ø¼þ½øÐлº´æµÄʱ¼ä£¬µ¥Î ......
»º´æÊǰÑÓ¦ÓóÌÐòÖеÄÐèҪƵ·±¡¢¿ìËÙ·ÃÎʵÄÊý¾Ý±£´æÔÚÄÚ´æÖеıà³Ì¼¼Êõ£¬Í¨³£ÓÃÀ´Ìá¸ßÍøÂçµÄÏìÓ¦ËÙ¶È¡£ÔÚASP.NETÖÐʹÓÃCacheÀàÀ´¹ÜÀí»º´æ¡£ÏÂÃæÏêÊö¿Ø¼þ¼¶Êý¾Ý»º´æ¹¦ÄܺÍÒ³Ãæ¼¶Êý¾Ý»º´æ¹¦ÄܵÄʵÏÖ£º
(1)Êý¾Ý¿â»º´æÒÀÀµ
Êý¾Ý¿â»º´æÒÀÀµÓÉSqlCacheDependencyÀà¹ÜÀí£»
Êý¾Ý¿â»º´æÒÀÀµµÄÓŵ㣺
1¡¢Ìá¸ßÊý¾Ý³ÊÏÖËÙ¶È£¬Ã¿´Î»ñ ......
¿Í»§¶Ë´«ËÍÊý¾Ýµ½·þÎñÆ÷¶ËÓÐÈýÖÖ·½·¨£º
1.form
2.querystring
3.cookie
ÀûÓÃÕâЩ·½Ê½È¡µÃµÄÊý¾ÝÔÚ·þÎñÆ÷¶Ë¶¼ÊÇ×ֵ伯ºÏ,Èç¹ûÒª¾«È·È¡µ½Ä³¸ö¼¯ºÏµÄÖµ£¬ÔòÖ±½ÓʹÓöÔÓ¦µÄ¼¯ºÏµÄÃû³Æ£¬ÈýÖÖ·½Ê½¶ÔÓ¦µÄ¼¯ºÏÈçÏ£º
1.form:request.form
2.querystring:request.querystring
3.cookie:request.cookie
ÀûÓÃrequest.p ......