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 ......
Red Hat Linux ϰ²×°mysql°æ±¾³åÍ»ÎÊÌâ½â¾ö
¸ÕÅöµ½Ò»¸öÎÊÌ⣬ÓÉÓÚÔÚʹÓõÄlinux·þÎñÆ÷ÉÏÒѾ°²×°ÁËÒ»¸ö½ÏµÍ°æ±¾µÄMySql server£¬Ê¹ÓÃrpm°ü½øÐа²×°Ê±£¬Ìáʾ°æ±¾³åÍ»£¬°²×°²»ÄܼÌÐø½øÐС£
ÓÉÓھɵÄÊý¾Ý²»ÏëÒªÁË£¬½â¾ö°ì·¨ÊÇÕâÑùµÄ£º
[b]1¡¢ÏȰÑϵͳÀï°²×°µÄËùÓÐmysqlÕÒ³öÀ´[/b]
#rpm -qa | grep -i mysql ÔËÐдËÃüÁîº ......
»·¾³:
fedora11 , mysql5.1.34Ô´Âë°²×°£º
×°ÁËÒ»Ìì°ëһֱûÓгɹ¦£¬ºóÀ´·ÅÆúÁË£¬ÒòΪfedora11µÄԴϲ»µ½mysqlËùÒÔÖ»ÄÜ·ÅÆúÔÚfedora11ϵݲװ£¬×ª¶ø¸Äµ½unbuntu9.04Éϰ²×°£¬µ«ÊÇÏëÏëÎÊÌâÊÇûÓÐ
½â¾öµÄ£¬½ñÌìÓÖ×ªÒÆµ½fedoraϸ㣬·¢ÏÖ²»Êǰ²×°mysqlÄÑ£¬ÊÇӦΪ×Ô¼º¶Ôlinuxϵͳ²»Ê ......
protected void Page_Load(object sender, EventArgs e)
{
/*
sql½Å±¾-´´½¨Ñ§Éú±í
create table student(id int,name varchar(50))
......