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

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔCS¶þÑÔ£¬Èç¹ûÄãÒªÌá¸ßÐÔÄÜ£¬¾¡Á¿¼õÉÙDBÉϵĸ´ÔÓ²Ù×÷£¬°Ñ¼ÆËãѹÁ¦´«¸øCS³ÌÐò¡£ºÜ¶àÈ˶¼Ï°¹ß°ÑһЩ¸´ÔӵļÆËãͳ¼Æ¶¼×öÔÚDBÉÏ£¬Õâ¶ÔCS¶þÑÔÊǸö×îʧ°ÜµÄÉè¼Æ¡£
2.CSÉϵÄÐÔÄÜÌáÉý¹Ø¼üÔÚÓÚ2¸ö£¬1¸öÊÇËã·¨£¬Áí1¸ö¾ÍÊÇÌåÑéЧ¹û¡£Ëã·¨¹ýÓÚ¸´ÔӵĿÉÒÔ²ð·Ö¶àÏ̴߳¦Àí£¬¶ÔÓÚËã·¨¹ý¶àºÄʱµÄ£¬ÊµÔÚûÓÐÓÅ»¯µÄ¿ÉÄÜÁË£¬¶à¼ÓUIÌåÑéЧ¹û£¬±ÈÈç½ø¶ÈÌõµÈ´ý£¬ÌáÐÑ£¬ÕâЩ²Ù×÷¶¼ÓÐÀûÓÚÔö¼ÓÈËÃǶÔÄãµÄ³ÌÐòµÄºÃ¸Ð¶È

Êý¾Ý¿âÓÅ»¯, »º´æ, ¶àÏß³Ì ... ...

·¹ý


Ïà¹ØÎÊ´ð£º

Çó¾ÈMySqlÄ£ºý²éѯÎÊÌâ

Java code:

Ä£ºý²éѯÊé°´ÕÕÊéÃû-------------------
java.sql.SQLException: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
at com.mys ......

MySQL´´½¨´æ´¢¹ý³Ì³ö´í

ÔÚMySQL5.0Öд¬½¢´æ´¢¹ý³Ìͨ²»¹ý£¬Ìáʾ£º
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' ......

¹ØÓÚmysql´æ´¢¹ý³Ì±äÁ¿µÄÎÊÌ⣿

¹ØÓÚmysql´æ´¢¹ý³Ì±äÁ¿µÄÎÊÌ⣿±äÁ¿Ê²Ã´Ê±ºòÇ°ÃæÒª¼Ó@·ûºÅ£¬ÓÃdeclareÉùÃ÷µÄ±äÁ¿ÓëǰÕßÓкÍÇø±ð£¬ÎÒ²»¶®£¿
@ÊÇÓÃÀ´ÆÁ±Î´íÎó»ò¾¯¸æµÄ£¬µ±Ç°Ãæ¼ÓÁË@·ûºÅºó£¬Èô´Ë´¦Óдí»ò¾¯¸æ£¬ÍøÒ³½«²»ÏÔʾ³öÀ´¡£

Ç°Ãæ¼Ó@´ú±í»á»° ......

WindowsÏÂÐÞ¸ÄMySQL°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼ ʧ°Ü

ϵͳµÄʼþ²é¿´Æ÷ÖпÉÒÔ¿´µ½Å¶

ÔØ£ºTable 'mysql.host' doesn't existµÄ´íÎó
»¹ÊDz»Äܽâ¾öÎÊÌâ

²Î¿¼ÈçÏÂ
indowsÏÂÐÞ¸ÄMySQL°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼
2009-04-04 08:49:20
¡¡± ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ