MySqlÖÐÎÄÂÒÂë
·¢Õâ¸öÌû×ӺܾÀ½á£¬ÒòΪÂŲ̂ÉÏÓкöàÕâÖÖÎÊÌâµÄÃèÊöºÍ½â¾ö·½·¨£¬µ«ÎÒÒ»Ò»ÊÔ¹ý¾ÍÊDz»ÐУ¬ÏÖ°ÑÎÊÌâÃèÊöÈçÏ£ºÒÀACMAIN_CHMÔÚhttp://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspxÖеÄÃèÊö£¬°Ñ¸ÄÌùµÄÌùÏ£º
SQL code:
mysql> show create table t_devicegroups;
+----------------+--------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-------------------------------------------------+
| Table | Create Table
|
+----------------+--------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
---------------------------------------------------------------------
Ïà¹ØÎÊ´ð£º
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
String SQL="insert into ѧÉúÐÅÏ¢±í values(StudentNumber,StudentName,StudentAge)";ÆäÖÐStudentNumber,StudentName,StudentAge¶¼ÊDZäÁ¿¡£ÕâÑùд²»¶Ô¡¡µ½µ×¸Ãզд°¡
Íò·Ö¸Ðл£¡
String SQL=&q ......
ÎÒÐèÒªÓÃCursorµü´ú±íA£¬½«±íAµÄËùÓÐÊý¾ÝÒ»ÌõÒ»Ìõ½øÐд¦Àíºó²åÈëµ½B±íÖУ¬B±í»á¶ÔA±íµÄÊý¾Ý½øÐÐUniqueÈ¥ÖØ¡£
µ«·¢ÏÖµ±A±í²åÈëB±íµÄÊý¾ÝÓÐÖØ¸´µÄʱºò£¬Cursor¾Í²»ÔÙµü´ú´¦Àí¶øÅ×Òì³££¬Ò²¾ÍÊÇÏÂÃæµÄÊý¾Ý²»»áÔÙµü´ú´¦À ......
try
{
sql::Driver *driver;
sql::Connection *con;
//´´½¨Á¬½Ó
driver = get_driver_instance();
con = driver->connect("tcp://192.168.18.52:3306", "root", "1234 ......