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ÖеıíûÓÐÊý¾Ý
Ïà¹ØÎĵµ£º
Ò»¡¢×Ô¶¨Òå FCKeditor µÄ BasePathBasePath ¼´FCKeditorÔÚÍøÕ¾ÖеÄÏà¶Ô·¾¶£¬Ä¬ÈÏÖµÊÇ /fckeditor/£¬×îºÃÔÚWeb.config appSettingsÖÐ¶ÔÆä½øÐÐÅäÖãº
<add key="FCKeditor:BasePath" value="/FCKeditor_2.6.3/"/>
ÕâÑù×öÓÐÖî¶àÓŵ㣺
1.¿ª·¢»·¾³ÓëÉú²ú»·¾³²»Í¬£¬¿ª·¢»·¾³Ò»°ãÊÇhttp://localhost/xxx.com/ÕâÖÖÇé¿öÏ ......
PHP·ÃÎÊMySQLÊý¾Ý¿âº¯Êý¼ò½é
1. ½øÐÐÊý¾Ý¿âÁ¬½Ó
Á¬½ÓÊý¾Ý¿â·þÎñÆ÷£¬¾ÍÊǿͻ§¶ËÏò¼ºÔËÐеÄÊý¾Ý¿â·þÎñÆ÷·¢³öÁ¬½ÓÇëÇó£¬
³É¹¦ÒÔºó¾Í¿ÉÒÔ¶ÔÊý¾Ý¿â½øÐÐÏàÓ¦²Ù×÷£¬ÓÉÓÚÓû§µÄȨÏÞ²»Í¬£¬ËùÄܽø
ÐеIJÙ×÷Ò²²»Ò»Ñù¡£PHPÌṩÁËһϵÁÐMySQL ......
ÂÒÂëÕæÊǸöÁîÈËÌÖÑáµÄÎÊÌâ~
¸Õ²ÅÖÕÓÚ°ÑMySQLÓëJSP½»»¥µÄÂÒÂëÎÊÌâ½â¾öÁË¡£
°ì·¨ÈçÏ£º
1.ÔÚurl´¦¼ÓÉϾä×Ó "&useUnicode=true&characterEncoding=GBK" £»
2.ÎÒÓÃNavicat Lite¿ÉÊÓ»¯¹¤¾ß´´½¨MySQLÊý¾Ý¿âʱ£¬¿ÉÑ¡¶¨Êý¾Ý¿â±àÂ룬ҲÊÇ GBK £»
3.Ò³ÃæµÄ±àÂë¿ÉÒÔÑ¡GBKÒÔÍâµÄ±àÂ뷽ʽ£¬ÈçUTF-8¡£Èô²Ù×÷Ò³ÃæµÄ±àÂëÊÇUTF- ......
×î½üÓöµ½Ò»¸öÐèÇóÒªÔÚlinuxÏÂÓÃjava µ÷ÓÃmysql¿Í»§¶ËÔ¶³ÌµÇ½mysql·þÎñÆ÷£¬´Ó¿Í»§¶Ë»úÆ÷µ¼Èëmysql½Å±¾£¬´Ómysql·þÎñÆ÷¶Ëµ¼³ö±íÖеÄÊý¾Ý¡£ÒÔÏÂÊÇÓõ½µÄÖ÷Òª·½·¨£º
Java ´úÂë
/**
* µ¼ÈëÊý¾Ý
* @param ½Å±¾µÄµØÖ·ºÍÃû³Æ
* @return ÊÇ·ñ³É¹¦&nb ......
mysql±àÂëӦעÒâµÄ»·½Ú£º
Õ⼸¸ö»·½Ú±àÂ붼ͳһÁË£¬Ò»°ã²»»á³öÏÖÂÒÂë¡£BTW:
¿ÉÒÔÓÃSET NAMES xÁÙʱÉèÖÃmysql±àÂ룺
Ï൱ÓÚ
SET character_set_client = x;
SET character_set_results = x;
SET character_set_connection = x;
È磺
mysql_query("SET NAMES 'gb2312'") or die("Query failed : " . mysql_er ......