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²»»áÕâÑù°É Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£ http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx 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µÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿ ÃÜÂëÐ޸ķ½·¨£º 1.ÒÔϵͳ¹ ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿ PHP code: <?php $str="select * from product wh ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......