¹ØÓÚMySQLµÄ±àÂëÎÊÌâ
ÔÚmyeclipseÖÐʵÏÖÓëmysqlµÄÁ¬½Ó£¬µ«³öÏÖÁËÂÒÂëÏÖÏó£¬
mysqlÖеÄmy.iniÎļþÖÐĬÈϵͼÊÇlatin-1.ÎÊÔõôÑù²ÅÄÜÉèÖóÉutf-8»òÕßGBK¡£»¹ÓеľÍÊÇutf-8¡¢GBKºÍLatin-1ÈýÕßµÄÇø±ð
¸Ð¼¤²»¾¡
Â¥Ö÷×îºÃ»¹Êǽ«MysqlµÄ±àÂëÉèÖÃΪgb2312£¬ÖØ×°Ò»´ÎMysql£¬ÔÚÖØÐ½¨¸öÊý¾Ý¿â£¬
Latin-1²»Õ¦Ö§³ÖÖÐÎÄ£¬UTF-8Ö§³ÖÖÐÎÄ£¬GBKÖ§³ÖÖÐÎÄ£¬ÊÇ·±ÌåµÄ±àÂë
ÕâÖÖÎÊÌ⻹µÃ¿¿×Ô¼º Google.com.hk.............
latin-1 ¾ÍÊÇ ISO 8859-1 Ã÷°×ÁËô£¿
֨װ mysql ÅäÖÃÓïÑÔ»·¾³ÎªGBK
ʵÏÖmysqlÁ¬½Ó ÔÚÁ¬½Ó´Ê¼ÓÉÏ
?useEncoding=true&characterEncoding=UTF-8
¸ü¸ÄMySQLÊý¾Ý¿â±àÂ룺
ÔËÐÐMySQL Server Instance Confituration Wizard³ÌÐò£¬¸ù¾ÝÏòµ¼Ò»Ö±µã»÷¡°next¡±£¬µ±µ½ÅäÖÃÊý¾Ý¿â±àÂëÕâÒ»²½Ê±£¬×¢Ò⣬ѡÔñ×îºóÒ»¸öµ¥Ñ¡°´Å¥£¨Manual Selected Default Character Set/Collation£©£¬ÔÚÏÂÀ¿òÖÐÑ¡Ôñutf-8£¨Ä¬ÈϱàÂëΪlatin1£©£¬È»ºó°´Ïòµ¼Íê³ÉÅäÖü´¿É¡£
ÄãµÄJSPÎļþµÄÍ·ÎļþûÓÐÉèÖóÉutf-8°É£¿
Èç¹ûûÓеϰ¾Í²»Ö§³ÖÖÐÎÄ£¬¿Ï¶¨»áÂÒÂ룡
LZµÄÎÊÌâÎÒÓö¼û¹ý£¬ÄãÔÚ°²×°MYSQLµÄʱºò£¬ÓÐÒ»²½ÊÇ Please select the default set.Äã°ÑCharacter Set:Ñ¡ÔñΪGB2312¾ÍÐÐÁË
ÔÚ°²×°Ê±Óиö×Ö·ûÑ¡ÔñµÄÎÊÌâ £¬Ö»ÒªÑ¡ÎªGB2312¼´¿É
ÔËÐÐMySQL Server Instance Confituration WizardÀ´ÉèÖóÉutf-8£¬Êý¾Ý¿â¡¢±í¶¼ÒªÉèÖóÉutf-8¡£
°ÑÍøÒ³ÖеIJÎÊýת³Éutf-8¸ñʽ£¬´æÈëÊý¾Ý¿â¡£
Ö±½Ó²éѯ³öµÄÊý¾ÝÓ¦¸ÃÊÇutf-8µÄ¸ñʽ£¬²»ÓÃת»»¡£
ÒªÊÇÓô¿javaµÄ´úÂë´æÈëÊý¾ÝµÄ»°£¬Ò²ÓгöÏÖÂÒÂëµÄÇé¿ö¡£
ÍøÒ³ÖнÓÊܵÄÊý¾Ýת³Égb2312Ò²¿ÉÒÔ´æÈëÊý¾Ý¿âµÄ¡£
ÖØÐÂÅäÖÃmysql
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
try
{
sql::Driver *driver;
sql::Connection *con;
//´´½¨Á¬½Ó
driver = get_driver_instance();
con = driver->connect("tcp://192.168.18.52:3306", "root", "1234 ......