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

c++ÖвéѯmysqlÊý¾Ý¿âµÄÎÊÌâ ¼±°¡£¡£¡£¡£¡£¡


ÎÒÔÚc++ÖвéѯmysqlÊý¾Ý¿âʱ


ÎÒÕâÑù×ö¾Í¿ÉÒÔ
char  szSqlText[500];
sprintf(szSqlText,"select * from anchorid where xdid='1' and pointid='1' and xdupdw='up'");

µ«ÏÂÃæÕâÑù¾Í²»ÐÐ
char  szSqlText[500];
sprintf(szSqlText,"select * from anchorid where xdid='%d' and  pointid='%d' and  xdupdw='up'",xd_id,anchorid1);

ÕâÊÇʲôԭÒò°¡£¿
ÄܰÑxd_idºÍanchorid1µÃÀàÐÍÌù³öÀ´Âð£¿Èç¹ûËûÃÇÀàÐÍÆ¥Å䣬ËûÃǵÃÖµÒ²ÕýÈ·Âð£¿

Ïëµ½µÃ¾ÍÒÔÉÏÁ½µãÁË

Ó¦¸Ã¾ÍÊÇÀàÐͲ»Æ¥ÅäÁË

int anchorid1='1',anchorid2='2',xd_id='1';
ÔÎ ²ËÄñÁË  ¶¨Òå´íÁË  ¶àÁ˵¥ÒýºÅ
ÏÖÔÚ¿ÉÒÔÁË ¡£¡£¡£  лл¸÷λ


Ïà¹ØÎÊ´ð£º

ÈçºÎ²éÕÒϵͳδ°²×°²¹¶¡C - C/C++ / ÐÂÊÖÀÖÔ°

ÇëÎʸ÷λ¸ßÊÖÈçºÎÓÃC/C++»ñµÃϵͳδ°²×°²¹¶¡
ºÃÏñºÜרҵµÄ¶«Î÷¡£¡£¡£

²é×¢²á±í
ÿ¸ö²¹¶¡Èç¹û°²×°Á˶¼»áÔÚ×¢²á±íÀïÃæµÇ¼Ç

ÇëÎÊÄܲ»ÄܸüÇåÎúЩ£¬ÎÒÏëÓÃc\c++²é³öÀ´£¬²»ºÃÒâ˼£¬ÎÒÊÇÐÂÊÖ¡£»¹ÍûÖ¸½Ì¡£Ð»

·ÖÖµ ......

[Çó¸Ö²ÄÇиîÎÊÌâµÄC/C++Ë㷨ʵÏÖ]

ÎÊÌâ:¹¤µØÉÏÐèÒª³¤¶ÈΪA1µÄ¸Ö½îX¸ù,³¤¶ÈΪA2µÄ¸Ö½îY¸ù,³¤¶ÈΪA3µÄ¸Ö½îZ¸ù......ÒÔ´ÎÀàÍÆ.
ÆäÖÐA1,A2,A3,...³¤¶ÈÈÎÒâÖ¸¶¨,X,Y,Z,...ÊýÁ¿Ò²ÈÎÒâÖ¸¶¨.

µ«²Ö¿âÖеĸֽîΪ±ê×¼³¤¶È,Ö»ÓÐ9Ã׺Í15Ã×Á½ÖÖ³¤¶È,ÊýÁ¿² ......

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

Çë½ÌÒ»¸ömysqlÁ©±íÁ¬½ÓµÄÎÊÌâ

ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ