Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÓïÑÔ

ÎÊһϣº
#include <stdio.h>
int main()
{
  char x, y, z;
  int i;
  int a[16];
  for(i=0; i<=16; i++)
  {
  a[i] = 0;
  ......

ÓÃC»òC++ÈçºÎ±àдÇó½â3Dħ·½³ÌÐò - C/C++ / C++ ÓïÑÔ

ÇëÎÊÓÃC»òC++ÈçºÎ±àдÇó½â3Dħ·½µÄ³ÌÐò£¬¸Ã´ÓºÎ¿ªÊ¼£¿
лл¸÷룬°ïæÌáµã½¨Òé°É¡£

http://www.mofang.net/code/176/182/6581.html

ÎÒÖ»ÄÜÍ»ÆÆ60Ã룡°¦¡£

ÎÒ¸Õ¹ý40Ãë

googleµÄandroidÖÐÓиöOpenGL ES + ......

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

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ºÅ