ASP.NETÓëMySqlµÄÁ¬½Ó——Êý¾Ý¿â·ÃÎʲÙ×÷
1.¶Á³ö·½Ê½
DataReaderºÍDataSet¶¼¿ÉÒÔʵÏÖ¶ÔÊý¾Ý¿âÊý¾ÝµÄ²éѯ·µ»Ø£¬µ«Ç°ÕßÖ»ÄÜÌṩ¿ìËٵIJéѯ·½Ê½£¬ºóÕß»¹¿ÉÒÔʵÏÖ¶ÔÊý¾ÝµÄÌí¼Ó¡¢Ð޸ġ¢É¾³ý¹¦ÄÜ¡£
£¨1£©DataReader·½Ê½¶ÁÈ¡£º
string sConnString = "server=localhost;User Id=root;password=root;Persist Security Info=True;database=db_user";
MySqlConnection myConn = new MySqlConnection(sConnString);
myConn.Open();
string myCmd = "select * from login_user where User_Name='" + users + "' and User_Pwd='" + pwd + "'";
MySqlCommand mycm = new MySqlCommand(myCmd, myConn);
MySqlDataReader msdr = mycm.ExecuteReader();
£¨2£©DataSet·½Ê½¶ÁÈ¡£º
string sConnString = "Server=127.0.0.1;Port=3306;Database=db;Uid=user;Pwd=123;";
MySqlConnection myConn = new MySqlConnection(sConnString);
myConn.Open();
MySqlDataAdapter myAdapter = new MySqlDataAdapter("SELECT * from table n;",myConn);
DataSet ds = new DataSet();
myAdapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
2.MySqlCoomandµÄ·½·¨
£¨1£©ExecuteNoQuery()——SQLÓï¾äÖ´Ðк󲻷µ»ØÈκÎÖµ
£¨2£©ExecuteScalar()——SQLÓï¾äÖ´Ðк󲻷µ»ØÈκÎÖµ£¬·µ»Ø²éѯ½á¹û¼¯ÖеÚÒ»ÐеÚÒ»ÁеÄÊý¾ÝÖµ
£¨3£©ExecuteReader()——SQLÓï¾äÖ´Ðк󷵻ضàÐнá¹ûÊý¾Ý
3.ÈçºÎÅж϶Á³öµÄ¶Á³öµÄÊý¾ÝÊÇ·ñΪ¿Õ
£¨1£©DataReaderÊÇ·ñΪ¿Õ
if (msdr.Read())//msdr·Ç¿Õ
£¨2£©DataSetÊÇ·ñΪ¿Õ
if(ds == null)//dsΪ¿Õ
if(ds.Tables.Count == 0)//dsÖÐûÓбí
if(ds.Tables.Count == 1 && ds.Tables[0].Rows.Count == 0)//dsÖеıíûÓÐÊý¾Ý
Ïà¹ØÎĵµ£º
1.½«flex±àÒëºóµÄ³ÌÐò²åÈëµ½asp.netÒ³Ãæ
flexµÄ×îÖÕÊä³ö¾ÍÊÇÒ»ÕÅÍøÒ³+Ò»¸öflash(.swfÎļþ)
Õâô˵ÄãÃ÷°×Á˰ɣ¬Æäʵ¾ÍÊÇÓÃËûÉú³ÉµÄÍøÒ³µÄ·½Ê½°ÑÄǸö.swfÎļþ²åÈëµ½ÄãµÄasp.netÒ³Ãæ¾Í¿ÉÒÔÁË¡£
¼ÙÈçÄãµÄflex3ÏîÄ¿Ãû×Ö½ÐTestApp£¬×î¼òµ¥Ö±½ÓµÄ°ì·¨¾ÍÊÇ£¬
°Ñ"bin-debug"Ŀ¼Ïµģº
TestApp.html
TestApp.swf
AC_OETags.js ......
Ò»¡¢×Ô¶¨Òå FCKeditor µÄ BasePathBasePath ¼´FCKeditorÔÚÍøÕ¾ÖеÄÏà¶Ô·¾¶£¬Ä¬ÈÏÖµÊÇ /fckeditor/£¬×îºÃÔÚWeb.config appSettingsÖÐ¶ÔÆä½øÐÐÅäÖãº
<add key="FCKeditor:BasePath" value="/FCKeditor_2.6.3/"/>
ÕâÑù×öÓÐÖî¶àÓŵ㣺
1.¿ª·¢»·¾³ÓëÉú²ú»·¾³²»Í¬£¬¿ª·¢»·¾³Ò»°ãÊÇhttp://localhost/xxx.com/ÕâÖÖÇé¿öÏ ......
Ò».×Ö·û´®Àà
CHARSET(str) //·µ»Ø×Ö´®×Ö·û¼¯
CONCAT (string2 [,... ]) //Á¬½Ó×Ö´®
INSTR (string ,substring ) //·µ»ØsubstringÊ×´ÎÔÚstringÖгöÏÖµÄλÖÃ,²»´æÔÚ·µ»Ø0
LCASE (string2 ) //ת»»³ÉСд
LEFT (string2 ,length ) //´Óstring2ÖеÄ×ó±ßÆðÈ¡length¸ö×Ö·û
LENGTH (string ) //string³¤¶È
LO ......
mysqlÍü¼ÇrootÃÜÂëµÄ½â¾ö
Ò». MySQLÃÜÂëµÄ»Ö¸´·½·¨Ö®Ò»
Èç¹ûÍü¼ÇÁËMySQLµÄrootÃÜÂ룬¿ÉÒÔÓÃÒÔÏ·½·¨ÖØÐÂÉèÖãº
1. KILLµôϵͳÀïµÄMySQL½ø³Ì£»
killall -TERM mysqld
2. ÓÃÒÔÏÂÃüÁîÆô¶¯MySQL£¬ÒÔ²»¼ì²éȨÏ޵ķ½Ê½Æô¶¯£»
safe_mysqld --skip-grant-tables &
3. È»ºóÓÿÕÃÜÂ뷽ʽʹÓÃrootÓû§µÇ¼ MySQL£»
......
private bool IsPicture(string filePath)//filePathÊÇÎļþµÄÍêÕû·¾¶
{
try
......