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

¹ØÓÚc++¹ÜÀímysqlµÄº¯ÊýÎÊÌ⣨¼±£©

Èç¹ûÎÒÏëÓÃselect *  from mytable where ×Ö¶Î1=    and    ×Ö¶Î2=    and    ×Ö¶Î3=

ÆäÖÐ×Ö¶Î1£¬2£¬3¶¼ÒªÇó´ÓÒѶ¨ÒåµÄ±äÁ¿ÖÐÈ¡£¬ÒªÔõô×ö£¿

 

sprintfºÍmysql_queryËÆºõ¶¼²»Ðа¡ Çë¸÷λ°ï°ïæ


Èç¹û¶¼ÊÇÓñäÁ¿,¿ÉÒÔʹÓÃstl::map½â¾ö
map <string,string> m_data;
m_data["id"]="123456";
È»ºóʹÓõü´úÆ÷¹¹ÔìsqlÓï¾ä.
string query="select *  from mytable where ";
map <string,string>::iterator it=m_data.begin();
while(it!=m_data.end()){
query+=it->first;
query+="=";
query+=it->second;
it++;
}

²»ÖªµÀÊDz»ÊÇÄãÏëҪʵÏֵŦÄÜ.

char  szSqlText[500];
sprintf(szSqlText,"select *  from anchorid where xdid=%d  and  pointid=%d  and  xdupdw='up'",xd_id,anchorid1);
mysql_query(sock,szSqlText);
ÎÒÓõÄÕâ¸ö£¬Ð´µÄÓ¦¸Ã¶Ô°É£¬ ¿É»¹ÊDz»Ðа¡ acmain´ó¸çÔÙ°ï°ï棬ÎÒ¾ÍÊÇÒªÓÃÕâÖÖÓï¾äʵÏÖµÄ

looyaoµÄºÃÏñºÜ¸´ÔÓ£¬ÎÒ¿´²»¶® ¹þ  ÎÒÊDzËÄñ


char  szSqlText[500];
sprintf(szSqlText,"select *  from anchorid where xdid=%d  and  pointid=%d  and  xdupdw='up'",xd_id,anchorid1);

printf("%s",szSqlText);

mysql_query(sock,szSqlText);

¿´Ò»ÏÂÄãµÄSQLÓï¾äÊÇʲô£¿
ÁíÍâ½


Ïà¹ØÎÊ´ð£º

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

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

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

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

·ÖÖµ ......

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

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

mysql´¢´æ¹ý³ÌµÄÎÊÌâ

ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£

http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ