MYSQLÈçºÎʵÏÖ×Ô¶¯±¸·Ý
ÔÚXP»òÕßLinuxϵͳÏÂÈçºÎʵÏÖMYSQL ÔÚÿÌìijһʱ¶ÎµÄʱºò×Ô¶¯±¸·Ý¡£¡£!
¿ÉÒԲο¼Ò»ÏÂÊÖ²áÖÐÒÔÏÂÄÚÈÝ¡£
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
5.9. ±¸·ÝÓë»Ö¸´
5.9.1. Êý¾Ý¿â±¸·Ý
5.9.2. ʾÀýÓñ¸·ÝÓë»Ö¸´²ßÂÔ
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......
try
{
sql::Driver *driver;
sql::Connection *con;
//´´½¨Á¬½Ó
driver = get_driver_instance();
con = driver->connect("tcp://192.168.18.52:3306", "root", "1234 ......
ÏÖÔÚÎÒÏë°ÑmysqlÊý¾ÝÀïµÄÊý¾Ý¿âÃû£ºmysqlDB,±íÃû£ºcdb_members£¬×ֶΰüº¬name password headpic addtime jifen
SQLÊý¾Ý¿âÀï Êý¾Ý¿âÃû£ºsq_ha315a ±íÃû£ºfs_ms_user ×Ö¶ÎÒ²°üº¬name password headpic addti ......