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/ÕâÖÖÇé¿öÏ ......
×î½üÓöµ½Ò»¸öÐèÇóÒªÔÚlinuxÏÂÓÃjava µ÷ÓÃmysql¿Í»§¶ËÔ¶³ÌµÇ½mysql·þÎñÆ÷£¬´Ó¿Í»§¶Ë»úÆ÷µ¼Èëmysql½Å±¾£¬´Ómysql·þÎñÆ÷¶Ëµ¼³ö±íÖеÄÊý¾Ý¡£ÒÔÏÂÊÇÓõ½µÄÖ÷Òª·½·¨£º
Java ´úÂë
/**
* µ¼ÈëÊý¾Ý
* @param ½Å±¾µÄµØÖ·ºÍÃû³Æ
* @return ÊÇ·ñ³É¹¦&nb ......
¹ØÓÚMySQL±íÉè¼ÆÓ¦¸Ã×¢ÒâµÄÎÊÌâ(×öÁ˵ãÐÞ¸Ä)
¹Ø
ÓÚÉè¼Æ±íʱӦ¸Ã×¢ÒâµÄÎÊÌâ
ÈçÓдíÎó»¶Ó´ó¼ÒÖ¸³ö¡£Õâ
¶Îʱ¼äÔÚ¼ÒÀ×öÁ˵ãÐÞÕý¡£
1
¡¢É÷ÖØÑ¡Ôñ±íÃû¡£
ÓÐ
Á½ÖÖÑ¡Ôñ£º
°´ÕÕ ......
ÔÚÒìµØµÄ·þÎñÆ÷±¸·ÝMysqlʱ£¬ÒìµØµÄ·þÎñÆ÷ûÓа²×°MysqlÊý¾Ý¿â£¬±¸·ÝµÄmysqldumpÃüÁîÊDz»ÄÜÉúЧµÄ¡£ËùÒÔ¿ÉÒ԰Ѱ²×°mysqlÊý¾Ý¿âËùÔÚ·þÎñÆ÷ÖеÄmysqldump.exe£¨È磺C:\Program Files\MySQL\MySQL Server 5.0\binĿ¼ÖеÄmysqldump.exe£©¿½±´µ½ÒìµØ·þÎñÆ÷ÖеÄÒ»¸öĿ¼ÖУ¨È磺F:\MySQLBackup£©¡£
±ÈÈçÎļþà ......
1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿â
ÏÈÏÂÔØºÍ°²×°MySQLDriverCS£¬µØ
Ö·£º
http://sourceforge.net/projects/mysqldrivercs/
ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½
MySQLDriver.dll
£¬È»ºó½«
MySQLDriver.dll
Ìí¼ÓÒýÓõ½ÏîÄ¿ÖÐ
×¢£ºÎÒÏÂÔØµÄÊǰ汾ÊÇ
MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe
using
S ......