Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MYSQLÔÚvisual studioÏÂÔõôÁ¬½ÓÄØ£¿

ÎÒн¨ÁËÒ»¸öÍøÕ¾£¬ÔÚweb.configÀïÃæµÄ
  <appSettings>
    <!--
ÉèÖÃÊý¾Ý¿âÁ¬½Ó×Ö·û´®ÅäÖÃ
-->
    <add key="ConnectionString" value="server=localhost;uid=root;pwd=;database=proto_management" />
  </appSettings>

µ«ÊÇÌáʾÎÒ£ºÓû§ 'root' µÇ¼ʧ°Ü¡£

ÕâÊÇʲôԭÒòÄØ£¿ÊÇVS²»Ö§³ÖMYSQLµÄÁ¬½ÓÂ𣿻¹ÊÇÎÒͬʱװÁËMSSQL Ëû²»ÖªµÀÁ´½ÓÄĸöÊý¾Ý¿âÂð£¿ÒªÔÚ¹ÜÀí¹¤¾ßµÄÊý¾ÝÔ´ÀïÃæÉèÖÃϵͳDSNÂð£¿


ÎÒ¿´ÁíÍâÒ»¸ö¹ÜÀí³ÌÐò È˼ÒÀïÃæµÄÊý¾Ý¿âÁ´½ÓÒ²ÊÇÕâÑùдµÄ°¡¡£ÎÒ³¢ÊÔÁËÏÂÒ²ÊÇÁ¬½Ó²»ÁË¡£
<add name="conn" connectionString="server=hostName(ip); user id=user; password=password; database=dbName;" providerName="MySql.Data.MySqlClient"/>

string dbConnectionString = ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;

MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = dbConnectionString ;
oMySqlConn.Open();
ʹÓÃÊý¾Ý¿â²Ù×÷Àà



ÎÒÏëÎÊÏÂMySql.Data.MySqlClientÊÇÒªÒýÓõÄÂð£¿ÎÒÕÒ²»µ½Õâ¸öÎļþŶ¡£ÎÒÓõÄÊÇMYSQL5.1

ÐÐ 15:            connectingstring = ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;
±àÒë´íÎóÊÇÔõô»ØÊÂÄØ£¿

ÒýÓÃ
ÎÒÏëÎÊÏÂMySql.Data.MySqlClientÊÇÒª


Ïà¹ØÎÊ´ð£º

ΪʲôMySQL²»Ö§³ÖÖÐÎİ¡£¿£¿

ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë

Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ

Ö§³Ö£¬¼ì² ......

mysql ÔõÑù²ÅÄܶÔͬһÕűí²éѯºóÔÙ¸üÐÂ?

Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
You can't specify target table 'a_table' for update in from clause
ÍêÕûSQLÓï¾äÊÇ
UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......

mysql root¸ÄÁËÃÜÂ룬ÓÖ×Ô¶¯±äÁË

¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
  1.ÒÔϵͳ¹ ......

´Ómysql¶ÁͼƬ·¾¶µ«ÊÇÎÞ·¨ÏÔʾ

´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:

<?php
$str="select * from product wh ......

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ