¹ØÓÚ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-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£
http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......