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ÊÇÒª
Ïà¹ØÎÊ´ð£º
echo %~dp0 CD %~dp0 mysqld.exe --defaults-file=..\my.ini --console pause ´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£ ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£ echo %~dp0 ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû CD %~dp0 ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡ ±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿ Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......