Znn3bq.jpeg
²é¿´: 1917  |  »Ø¸´: 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µÄ»ØÌû

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µÄ»ØÌû
²é¿´È«²¿ 10 ¸ö»Ø´ð

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µÄ»ØÌû

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µÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] ²ÄÁϹ¤³Ì085601£¬270Çóµ÷¼Á +28 @ASDF1234 2026-04-08 30/1500 2026-04-10 19:28 by dick_runner
[¿¼ÑÐ] Çóµ÷¼Á +9 ôæôæÒ»ÊéÉú 2026-04-09 9/450 2026-04-10 11:43 by wp06
[¿¼ÑÐ] Çൺ¿Æ¼¼´óѧ²ÄÁÏѧԺ£¬»·¾³Ñ§Ôºµ÷¼Á²¹Â¼4ÔÂ10ÈÕÒÔǰ¶¼¿ÉÒÔ +3 1Çà¿Æ´ó¡£ 2026-04-09 5/250 2026-04-10 09:58 by ôæôæÒ»ÊéÉú
[¿¼ÑÐ] 087100³õÊÔ311Çóµ÷¼Á +3 ÈÎÑÅÇÙ 2026-04-09 3/150 2026-04-09 22:42 by lbsjt
[¿¼ÑÐ] Çóµ÷¼Á +5 archer.. 2026-04-09 7/350 2026-04-09 22:18 by lbsjt
[¿¼ÑÐ] ±¾¿Æ211 ¹¤¿Æ085400 280·ÖÇóµ÷¼Á ¿É¿çרҵ +3 LZH£¨µÈ´ýµ÷¼ÁÖÐ 2026-04-09 3/150 2026-04-09 21:29 by wutongshun
[¿¼ÑÐ] Çóµ÷¼Á +13 Æâluck 2026-04-07 13/650 2026-04-08 22:46 by Öí»á·É
[¿¼ÑÐ] 270Çóµ÷¼Á +3 031127 2026-04-06 4/200 2026-04-08 21:00 by ÄæË®³Ë·ç
[¿¼ÑÐ] Ò»Ö¾Ô¸Ö£ÖÝ´óѧ085600Çóµ÷¼Á +21 ³ÔµÄ²»ÉÙ 2026-04-05 24/1200 2026-04-08 16:47 by sunhuadong
[¿¼ÑÐ] 307·Ö²ÄÁÏרҵÇóµ÷¼Á +12 Hllºú 2026-04-05 12/600 2026-04-08 16:33 by luoyongfeng
[¿¼ÑÐ] 307Çóµ÷¼Á +14 ³¬¼¶ÒÁ°º´óÍõ 2026-04-06 14/700 2026-04-08 07:03 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] 331Çóµ÷¼Á +5 ÕÅÔªÒ» 2026-04-07 6/300 2026-04-07 22:13 by hemengdong
[¿¼ÑÐ] 301Çóµ÷¼Á +18 121. 2026-04-04 18/900 2026-04-07 17:49 by À¶ÔÆË¼Óê
[¿¼ÑÐ] Ò»Ö¾Ô¸Î÷µç085401Çóµ÷¼Á +4 sunw1306 2026-04-07 4/200 2026-04-07 16:40 by à£à£à£0119
[¿¼ÑÐ] 328Çóµ÷¼Á +4 ghhh88888 2026-04-06 5/250 2026-04-07 14:45 by ghhh88888
[¿¼ÑÐ] ¹¤¿Æ370Çóµ÷¼Á +3 äçÐļ弦µ° 2026-04-05 3/150 2026-04-06 10:55 by ÕâÊÇÒ»¸öÎÞÁĵÄê
[¿¼ÑÐ] Ò»Ö¾Ô¸ÉϺ£º£Ñó´óѧ083200ʳƷѧ˶£¬Çóµ÷¼Á£¬½ÓÊÜÆäËûרҵ083200 +4 whatÕÅ 2026-04-04 5/250 2026-04-05 14:07 by chw1980_0
[¿¼ÑÐ] 328·Öµ÷¼Á +6 ÃÅmen 2026-04-04 6/300 2026-04-05 13:40 by imissbao
[¿¼ÑÐ] Äܶ¯µ÷¼Á326ר˶ +4 wan112233 2026-04-04 4/200 2026-04-04 22:47 by yu221
[¿¼ÑÐ] 295Çóµ÷¼Á +4 AÄãºÃÑо¿Éú 2026-04-04 5/250 2026-04-04 22:46 by yu221
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û