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++²é³öÀ´£¬²»ºÃÒâ˼£¬ÎÒÊÇÐÂÊÖ¡£»¹ÍûÖ¸½Ì¡£Ð»
·ÖÖµ ......
ÎÊÌâ:¹¤µØÉÏÐèÒª³¤¶ÈΪA1µÄ¸Ö½îX¸ù,³¤¶ÈΪA2µÄ¸Ö½îY¸ù,³¤¶ÈΪA3µÄ¸Ö½îZ¸ù......ÒÔ´ÎÀàÍÆ.
ÆäÖÐA1,A2,A3,...³¤¶ÈÈÎÒâÖ¸¶¨,X,Y,Z,...ÊýÁ¿Ò²ÈÎÒâÖ¸¶¨.
µ«²Ö¿âÖеĸֽîΪ±ê×¼³¤¶È,Ö»ÓÐ9Ã׺Í15Ã×Á½ÖÖ³¤¶È,ÊýÁ¿² ......
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......