ÓÖÊÇQTÓëMySQLÁ¬½ÓµÄÎÊÌâ - ÒÆ¶¯Æ½Ì¨ / Qt¿ª·¢
»·¾³£º
windows XP
Qt 4.6.2
vs2008
±¨´íÄÚÈÝ£ºÇý¶¯Ã»¼ÓÔØ
ÔÚÍøÉÏËÑÁ˺ðëÌ죬×îºóÕÒµ½
http://blog.csdn.net/do_fork/archive/2009/11/18/4825143.aspx
°´ÕÕÉÏÃæµÄ·½·¨½øÐÐÁ˱àÒ룬±àÒëÒ²³É¹¦ÁË£¬ÔÚ\plugins\sqldriversÏÂÄܹ»ÕÒµ½Ïà¹ØµÄ¿âÎļþ£¬¿ÉÊdzÌÐòÔËÐÐʱÒÀ¾É˵Çý¶¯Ã»¼ÓÔØ£¨proÖмÓÁËQT += sql£©£¬²»ÖªÊDz»ÊÇ»¹µÃÒªÔÚ±ðµÄµØ·½×öһЩÉèÖ㬻¹Íû¸ßÊÖÖ¸½Ì¡£
http://blog.csdn.net/MicroSky2813/archive/2010/03/02/5338040.aspx
д¹ýÕâô¸ö¶«Î÷
¼Óû¼ÓÔØÔÚbebugÔËÐÐʱÔÚQtCreatorÀïÃæÓÐÊä³öËùÓõÄSQL¿â³É²»³É¹¦¡£²»³É¹¦µÄ»°»áÊä³öÒѾÓÐʲôSQLÇý¶¯µÄ
Äܲ»ÄÜÏêϸ˵˵£¿ÉÏÃæµÄÄǾ仰ûÄÜÃ÷°×
¾ÍÊÇÇý¶¯×ö³É¹¦µÄ»°Ó¦¸Ã¾Í²»»áÓÐÎÊÌâÁË£¬Ôõô¿´Çý¶¯³Éû³É¹¦ÄØ£¿
Èç¹ûʹÓõÄQtCreatorµÄ»°£¬ÔÚÔËÐеÄʱºò×¢ÒâһЩ³ÌÐòµÄÊä³ö¿´ÓÐûÓе±Ç°µÄMySQLÇý¶¯²»ÔÚ¡£
ÎÒûװQtCreate£¬Ë³±ãÔÙÎÊÎÊÎÒÇý¶¯±àÒëÍê³ÉºóÊÇ·ñ»¹ÐèÒªÆäËûµÄÉèÖã¬ÏÂÃæÊÇÎÒ²âÊԵĴúÂ룬ҲÂé·³¿´¿´
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÈçÌâ¡£Äܲ»Äܸø¸öÀý×Ó£¬·Ç³£¸Ðл
°²×°mysqlʱ¼ÇµÃ×° Àà¿â£¬ÀïÃæÓÐ mysqlÌṩµÄº¯Êý½è¿Ú£¬ÓÃËüÀ´Á¬mysqlºÜ·½±ã
ºÃ¶«Î÷£¬¹²Í¬Ñ§Ï°
mysql++ À࣬ºÜ·½±ãºÜºÃÓã¡
ÌùÓÊÏ䣬·¢Äã
1.mysql api
2.myodbc
......
hql = "select left('adfsadfasgsadgagsda',2)";
¾ÍÓÃÕâ¾äÓï¾ä ÔÚÊý¾Ý¿âÖÐÖ´ÐÐ
µ«ÊÇÔÚjava´úÂëÖÐ ÓÃHibernate Ö´ÐÐ ¾Í²»ÄÜÖ´ÐÐ £¿
ÕâÊÇʲôÎÊÌ⣡£¡£¡
ÎÒÒѾ֪µÀÁË£¡
&n ......