Znn3bq.jpeg
²é¿´: 1904  |  »Ø¸´: 9

cr153

гæ (³õÈëÎÄ̳)

[ÇóÖú] C++µ÷ÓÃmysql£¬ÏëÍê³ÉÒ»¸öÈçϵIJéѯ£¬È´²éѯʧ°Ü¡£¼±Çó½â¾ö·½·¨

case 3:     int paper_id;
                  cout<<"ÇëÊäÈëID"<                   cin>>paper_id;
                  res=mysql_query(&myCont,"select * from id_table where id=paper_id¡°);//²éѯ



----------------------------------------------------------------------------------------------------
ÒÔÉÏΪ¾Ö²¿´úÂë
´Ë¹¦Äܼܺòµ¥¾ÍÊÇ£¬Óû§ÊäÈëÏëÒª²éѯµÄID£¬È»ºóÊý¾Ý¿â²éѯ֮ºó·µ»Ø¸ÃIDµÄÐÅÏ¢
ÎÊÌâºÃÏñÊÇÔÚ´úÂëÖж¨ÒåµÄint paper_idÎÞ·¨´«Èëµ½mysql_queryÕâ¸ö½Ó¿ÚÖÐ
ÆäʵԭÒòÒ²ºÜ¼òµ¥£¬Õû¸öSQL²éѯÓï¾ä¶¼ÔÚÒýºÅÖУ¬Õû¸öÓï¾äµ±×÷×Ö·û´®¡£µ±È»paper_idÒ²µ±³ÉÁË×Ö·û
  
  ÇëÎÊ£¬ÏëʵÏÖÕâ¸ö¹¦ÄÜ£¬Ó¦¸ÃÔõôÐ޸ģ¿
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

chw521

ľ³æ (ÕýʽдÊÖ)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
"select * from id_table where id=paper_id¡° ¸ÄΪ "select * from id_table where id=" + paper_id
2Â¥2012-05-30 15:35:04
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

wudao99

½û³æ (³õÈëÎÄ̳)

¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
±¾ÌûÄÚÈݱ»ÆÁ±Î

3Â¥2012-05-30 16:37:57
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

bobobobo_8888

гæ (³õÈëÎÄ̳)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
int paper_id;
string paper_id;
                  cout<<"ÇëÊäÈëID"<                   cin>>paper_id;
                  res=mysql_query(&myCont,"select * from id_table where id=" + paper_id);//²éѯ
4Â¥2012-05-30 16:44:14
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

cr153

гæ (³õÈëÎÄ̳)

???????:
2?: Originally posted by chw521 at 2012-05-30 15:35:04
"select * from id_table where id=paper_id¡° ¸ÄΪ "select * from id_table where id=" + paper_id

????????????????
5Â¥2012-05-30 21:47:51
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

cr153

гæ (³õÈëÎÄ̳)

ÒýÓûØÌû:
4Â¥: Originally posted by bobobobo_8888 at 2012-05-30 16:44:14
int paper_id;
string paper_id;
                  cout<<"ÇëÊäÈëID"<<endl;
                  cin>>paper_id;
                  res=mysql_query(&myCont,"select *  ...

ϵͳ±¨´í£¬Öض¨Òå
6Â¥2012-05-30 21:48:18
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

onluy

Òø³æ (СÓÐÃûÆø)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¡ï
conanwj: ½ð±Ò+1, Ó¦ÖúÖ¸Êý+1, ¸ÐлÑÐÌÖ 2012-05-31 13:31:15
Ê×ÏÈÄãÒª¿´ÏÂÔÚ±íid_tableÖÐÊôÐÔÁÐidµÄÊý¾ÝÀàÐÍ¡£
Èç¹ûÊÇ×Ö·û´®¡£
res=mysql_query(&myCont,"select * from id_table where id=¡®" + paper_id+¡°¡¯¡±);
Ò²¾ÍÊÇÕâ¸ö²éѯÓï¾äÓ¦¸ÃÊÇ3¸ö×Ö·û´®¹¹³ÉµÄ
1¡¢"select * from id_table where id=¡®"
2¡¢ paper_id
3¡¢"'"
ÒòΪÔÚsqlÓï¾äÖÐ×Ö·û´®ÒªÓõ¥ÒýºÅ
ÌìÐн¡£¬¾ý×ÓÒÔ×ÔÇ¿²»Ï¢
7Â¥2012-05-30 23:02:14
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

cr153

гæ (³õÈëÎÄ̳)

ÒýÓûØÌû:
7Â¥: Originally posted by onluy at 2012-05-30 23:02:14
Ê×ÏÈÄãÒª¿´ÏÂÔÚ±íid_tableÖÐÊôÐÔÁÐidµÄÊý¾ÝÀàÐÍ¡£
Èç¹ûÊÇ×Ö·û´®¡£
res=mysql_query(&myCont,"select * from id_table where id=¡®" + paper_id+¡°¡¯¡±);
Ò²¾ÍÊÇÕâ¸ö²éѯÓï¾äÓ¦¸ÃÊÇ3¸ö×Ö·û´®¹¹³ÉµÄ ...

±íÖÐidµÄÀàÐÍΪint
8Â¥2012-05-31 11:20:18
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

nlyang

½û³æ (ÖøÃûдÊÖ)

¡ï ¡ï
¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
conanwj: ½ð±Ò+1, ר¼Ò¿¼ºË, ¸ÐлÑÐÌÖ 2012-05-31 13:31:36
cr153: »ØÌûÖö¥ 2012-05-31 21:52:32
cr153: ½ð±Ò+1, ¡ï¡ï¡ï¡ï¡ï×î¼Ñ´ð°¸, ³É¹¦ÊµÏÖÁ˹¦ÄÜ~¸Ðл 2012-05-31 21:52:49
±¾ÌûÄÚÈݱ»ÆÁ±Î

9Â¥2012-05-31 13:02:01
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

cr153

гæ (³õÈëÎÄ̳)

ÒýÓûØÌû:
9Â¥: Originally posted by nlyang at 2012-05-31 13:02:01
intµÄ»°£¬¾Í±ØÐë°Ñintת³É×Ö·û´®£¬´ó¸Å˼·ÈçÏ£º
char * sql=new char;
memset(sql,'\0',100);
sprintf(sql,"select * from id_table where id=%d;",paper_id);
ÔÙÖ´ÐÐsql£¬

Èç¹û»¹ÊDz»¶Ô£¬Äã¾ÍÖ± ...

¹òл°¡~
¸Õ²ÅÓÃÄúµÄ´úÂëÊÔÁËһϣ¬¹¦Äܳɹ¦ÊµÏÖÁË~
ÎÒ²»ÊÇ֪ʶ²»Ì«Á˽Ⱑ£¬Ñ¹¸ù¾Í²»Á˽⣬¹Ò¿ÆÉú°¡~....
ÕâÊÇÃ÷ÌìÒª½ÐµÄ´ó×÷ÒµÀïµÄÒ»²¿·Ö
  ÔٴθÐл£¬ºÃÈËÒ»Éúƽ°²~
10Â¥2012-05-31 21:52:14
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ cr153 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤µ÷¼Á 10+10 ÏÂÒ»Õ¾Éϰ¶@ 2026-04-10 29/1450 2026-04-10 20:58 by zhouxiaoyu
[¿¼ÑÐ] 085404 298·ÖÇóµ÷¼Á +10 ºôÀ²ºôÀ²ºôºôºô 2026-04-10 11/550 2026-04-10 16:44 by wangy0907
[¿¼ÑÐ] 0854Çóµ÷¼Á +5 assdll 2026-04-05 5/250 2026-04-10 15:32 by ¸ßά´º
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +13 Ò»ÑùYWY 2026-04-04 13/650 2026-04-10 11:07 by mattzhming
[¿¼ÑÐ] 316Çóµ÷¼Á +3 Ïë¶ÁÑо¿Éú( ?¡ß 2026-04-07 3/150 2026-04-09 17:31 by wp06
[¿¼ÑÐ] 332£¬085601Çóµ÷¼Á +12 ydfyh 2026-04-09 14/700 2026-04-09 17:28 by wp06
[¿¼ÑÐ] 085501»úеר˶ 302·Ö ²»ÌôרҵÇóµ÷¼Á +5 Íôij. 2026-04-09 5/250 2026-04-09 15:38 by ½¯ð©Óí
[¿¼ÑÐ] 262Çóµ÷¼Á +10 ÌìϵÚÒ»ÎÄ 2026-04-04 13/650 2026-04-09 15:16 by ̽123
[¿¼ÑÐ] 349ѧ¿Æ»¯Ñ§045106Çóµ÷¼Á£¬»¯Ñ§Àà¶¼¿ÉÒÔ +8 ±£ºÃ¶®¶® 2026-04-08 8/400 2026-04-09 14:03 by xulei3024
[¿¼ÑÐ] 086000µ÷¼Á +4 Ê®Æßsa 2026-04-07 4/200 2026-04-09 09:27 by Ò¼ÍùŸoǰ
[¿¼ÑÐ] ¿¼ÑÐÇóµ÷¼Á +4 ö©??? 2026-04-08 4/200 2026-04-08 21:44 by ÍÁľ˶ʿÕÐÉú
[¿¼ÑÐ] 307Çóµ÷¼Á +14 ³¬¼¶ÒÁ°º´óÍõ 2026-04-06 14/700 2026-04-08 07:03 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] 0854µç×ÓÐÅÏ¢319Çóµ÷¼Á£¨½ÓÊÜ¿çרҵµ÷¼Á£© +5 ÐÇÐDz»Õ£ÑÛà¶ 2026-04-05 6/300 2026-04-07 22:16 by hemengdong
[¿¼ÑÐ] 285Çóµ÷¼Á +15 ŶßϺôo 2026-04-04 17/850 2026-04-06 23:02 by chenzhimin
[¿¼ÑÐ] ¿¼Ñе÷¼Á +3 WwwwwwwÍÛ 2026-04-06 3/150 2026-04-06 20:55 by lbsjt
[¿¼ÑÐ] Ò»Ö¾Ô¸Î人Àí¹¤´óѧ080200»úе¹¤³Ì308·Ö£¬Çóµ÷¼Á +4 ÖÕ²»ËÆ´Óǰ 2026-04-05 4/200 2026-04-06 11:46 by ¿¼ÑÐѧУÕеãÈË
[¿¼ÑÐ] ¹¤¿Æ370Çóµ÷¼Á +3 äçÐļ弦µ° 2026-04-05 3/150 2026-04-06 10:55 by ÕâÊÇÒ»¸öÎÞÁĵÄê
[¿¼ÑÐ] 348Çóµ÷¼Á +3 ³µÀå×Ózzz 2026-04-05 3/150 2026-04-05 20:30 by à£à£à£0119
[¿¼ÑÐ] 348Çóµ÷¼Á +6 wukira 2026-04-04 6/300 2026-04-05 18:11 by Öí»á·É
[¿¼ÑÐ] 305Çóµ÷¼Á +3 77Qi 2026-04-03 3/150 2026-04-03 23:01 by qzxyhcsy
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û