C++¶ÔsqlµÄ²Ù×÷ - C/C++ / ÆäËü¼¼ÊõÎÊÌâ
ÎÒÏëͨ¹ýODBCÀ´²Ù×÷Êý¾Ý±í£¬µ«È´ÕÒ²»µ½×Ô¼ºÐ½¨µÄ±í£¬Ö»ÓÐн¨Êý¾Ý¿âʱ×Ô¶¯Éú³ÉµÄ±í
Ç¿µ÷£ºÔÚÆóÒµ¹ÜÀíÆ÷ÖÐÄÜÕÒµ½ÎÒ½¨µÄ±í
ÄÄλ³öÏÖ¹ýÀàËÆÎÊÌ⣿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¾È¾ÈÎÒ°É¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢
ÄãÈ·¶¨ÄǸöÊÇÔÚͬһ¸öÊý¾Ý¿âÖУ¿ ·ÃÎÊȨÏÞÄØ
Äãн¨µÄ±í±£´æÁËÂð£¿Ã»±£´æµÄ»°£¬Êǿ϶¨¿´²»µ½µÎ
²»¹ý²»ÖªµÀLZÊÇÕÒ²»µ½±í£¬»¹ÊÇÕÒ²»µ½Êý¾Ý¿â
±£´æÁË£¬Ò²ÔÚͬһ¿âÖУ¬¶øÇÒÎÒÖØÆôÖ®ºó»¹ÄÇÑù
ÔÚÆóÒµ¹ÜÀíÆ÷ÖпÉÒÔÕÒµ½£¬µ«Í¨¹ýODBC½øÈëÊý¾Ý¿â¾ÍÕÒ²»µ½×Ô¼º½¨µÄ±í
Äã½øÈ¥ÁËûÓУ¿
ÄÜÕÒµ½ÆäËû±íÂ𣿣¨SQLserver2000ºÃÏñ×Ô´øÒ»Ð©±í£©
ÊDz»ÊÇͬһ¸öÓû§°¢£¿
ÓпÉÄÜÊÇ·ÃÎÊȨÏÞµÄÎÊÌ⣬ÄãÔÚ×¢²áODBCÊý¾ÝԴʱһ¶¨ÒªÊǾßÓзÃÎʸñíȨÏÞµÄÕË»§
ÆäËû±í¶¼Õҵõ½£¬¾ÍÀàÐÍΪ¡°Óû§¡±µÄ±íÕÒ²»µ½
ÎÒÔçÉÏ»¹ÄÜÕÒµ½£¬µ«Ö®ºóÎÒ½«ÄǼ¸¸ö±íɾÁË£»ÔÙ½¨Á˼¸¸ö±íºó¾ÍÕÒ²»µ½ÁË
ÖØÐÂ×¢²áODBCÊý¾ÝÔ´ÊÔÊÔ
²âÊÔÒ»ÏÂODBCºÍÊý¾ÝÔ´µÄͨѶÕý³£Âð¡£»¹ÓÐÊý¾Ý¿âÓû§µÄȨÏÞÒ²ÔÚODBCÀï¼ì²âһϡ£
ÎÊÌâ³öÔÚͨѶºÍȨÏÞÉÏ£¬×Ðϸ¼ì²éһϿ϶¨ÄÜÕÒµ½£¡
½â¾öÁË£¬Ð»Ð»¸÷λ¡£¡£¡£
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......
ÈçºÎ½«Ò»¸öListBoxÖеÄÊý¾Ý´æÔÚÊý¾Ý¿âÖеÄÒ»¸ö×Ö¶ÎÏÂÃæ£¬²¢ÇÒÿÌõ¼Ç¼µÄ×Ö·û´®¸öÊý²»Ò»¶¨ ÒÔ¼°ÈçºÎ´ÓÊý¾Ý¿âÖжÁÈ¡¸ÃListBoxÖеÄËùÓмǼ
C/C++ code:
//´æÈëÊý¾Ý¿â
void __fastcall TForm1::Button5Click(TO ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......