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
Ïà¹ØÎĵµ£º
ÏÂÔØÒ³Ãæ£º
<a href="download.ashx?url=<%=Server.UrlEncode("˵Ã÷.txt")%>">ÏÂÔØ</a>
------------------------------------------------------------------------------
download.ashx
<%@ WebHandler Language="C#" Class="download" %>
using System;
using System.Web;
public ......
»º´æµÄÖØÒªÐԾͲ»ÓÃÔÙÇ¿µ÷ÁË£¬@OutputCache¸øÎÒÃÇÌṩÁËÒ»ÖÖÉùÃ÷µÄ·½Ê½(¶ÔÓ¦µÄ»¹Óбà³ÌµÄ·½Ê½)À´¿ØÖÆÒ³ÃæºÍÓû§¿Ø¼þµÄ»º´æ²ßÂÔ£¬ÕâÊÇÒ»ÖÖ×î¼òµ¥Ö±½ÓµÄÍøÕ¾ÓÅ»¯·½Ê½¡£
»¹ÊÇÏÈÀ´¹ýÒ»±é@OutpuCacheËùÓеÄÊôÐÔ£¬¹²ÓÃ11¸öÊôÐÔ£¬Õâ¸öÖ¸Áî¿ÉÒÔÓÃÓÚÒ³Ãæ(.aspx)ºÍÓû§¿Ø¼þ(.ascx)
ÊôÐÔ
Duration
Ò³»òÓû§¿Ø¼þ½øÐлº´æµÄʱ¼ä£¬µ¥Î ......
ASP.NET±à³Ì¹æ·¶Ö®ÃüÃû¹æ·¶¶¼ÓÐÄÄÐ©ÄØ£¿¾ßÌåÓÖÓÐʲôÄÚÈÝÄØ£¿ÈÃÎÒÃÇ¿ªÊ¼°É£º
ASP.NET±à³Ì¹æ·¶Ö®ÃüÃû¹æ·¶1£®°´Å¥IDÃüÃû£º
btn+°´Å¥²Ù×÷¹¦ÄÜ£¨ÈçbtnSave£©
ASP.NET±à³Ì¹æ·¶Ö®ÃüÃû¹æ·¶2£®ÆäËü¿Ø¼þ£º
I£®ÓëÊý¾Ý²Ù×÷Ïà¹Ø£ºÆäID<.SPAN>ΪÏàÓ¦µÄ×Ö¶ÎÃû³Æ£¬Èç¹ûÓжà¸ö¿Ø¼þ¶ÔÓ¦Ò»¸ö×ֶΣ¬Ôò°´ÒÔϹ淶ÃüÃû£º
×Ö¶ÎÃû+&rdqu ......
MySQL FOR LINUX
Ïȼì²éϵͳÊÇ·ñ×°ÉÏÁËmysql£¬Èç¹ûÓн«ÆäÐ¶ÔØµô
rpm -qa | grep mysql
×¢ÒâmysqlµÄ´óСд£¬´óСд¶¼ÓпÉÄÜ
rpm -e --nodeps mysql*
Ò»¶¨ÒªÓÃ--nodepsÐ¶ÔØ£¬²»¼ì²éÒÀÀµÐÔ¹ØÏµ¡£
´´½¨Óû§mysql
groupadd mysql
useradd -g mysql mysql
passwd mysql
ÔÚ/usr/localϽ¨Á¢ mysql Îļþ¼Ð
È»ºó½«°²×°Î ......