C++¶ÔsqlµÄ²Ù×÷ - C/C++ / ÆäËü¼¼ÊõÎÊÌâ
ÎÒÏëͨ¹ýODBCÀ´²Ù×÷Êý¾Ý±í£¬µ«È´ÕÒ²»µ½×Ô¼ºÐ½¨µÄ±í£¬Ö»ÓÐн¨Êý¾Ý¿âʱ×Ô¶¯Éú³ÉµÄ±í
Ç¿µ÷£ºÔÚÆóÒµ¹ÜÀíÆ÷ÖÐÄÜÕÒµ½ÎÒ½¨µÄ±í
ÄÄλ³öÏÖ¹ýÀàËÆÎÊÌ⣿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¾È¾ÈÎÒ°É¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢
ÄãÈ·¶¨ÄǸöÊÇÔÚͬһ¸öÊý¾Ý¿âÖУ¿ ·ÃÎÊȨÏÞÄØ
Äãн¨µÄ±í±£´æÁËÂð£¿Ã»±£´æµÄ»°£¬Êǿ϶¨¿´²»µ½µÎ
²»¹ý²»ÖªµÀLZÊÇÕÒ²»µ½±í£¬»¹ÊÇÕÒ²»µ½Êý¾Ý¿â
±£´æÁË£¬Ò²ÔÚͬһ¿âÖУ¬¶øÇÒÎÒÖØÆôÖ®ºó»¹ÄÇÑù
ÔÚÆóÒµ¹ÜÀíÆ÷ÖпÉÒÔÕÒµ½£¬µ«Í¨¹ýODBC½øÈëÊý¾Ý¿â¾ÍÕÒ²»µ½×Ô¼º½¨µÄ±í
Äã½øÈ¥ÁËûÓУ¿
ÄÜÕÒµ½ÆäËû±íÂ𣿣¨SQLserver2000ºÃÏñ×Ô´øÒ»Ð©±í£©
ÊDz»ÊÇͬһ¸öÓû§°¢£¿
ÓпÉÄÜÊÇ·ÃÎÊȨÏÞµÄÎÊÌ⣬ÄãÔÚ×¢²áODBCÊý¾ÝԴʱһ¶¨ÒªÊǾßÓзÃÎʸñíȨÏÞµÄÕË»§
ÆäËû±í¶¼Õҵõ½£¬¾ÍÀàÐÍΪ¡°Óû§¡±µÄ±íÕÒ²»µ½
ÎÒÔçÉÏ»¹ÄÜÕÒµ½£¬µ«Ö®ºóÎÒ½«ÄǼ¸¸ö±íɾÁË£»ÔÙ½¨Á˼¸¸ö±íºó¾ÍÕÒ²»µ½ÁË
ÖØÐÂ×¢²áODBCÊý¾ÝÔ´ÊÔÊÔ
²âÊÔÒ»ÏÂODBCºÍÊý¾ÝÔ´µÄͨѶÕý³£Âð¡£»¹ÓÐÊý¾Ý¿âÓû§µÄȨÏÞÒ²ÔÚODBCÀï¼ì²âһϡ£
ÎÊÌâ³öÔÚͨѶºÍȨÏÞÉÏ£¬×Ðϸ¼ì²éһϿ϶¨ÄÜÕÒµ½£¡
½â¾öÁË£¬Ð»Ð»¸÷λ¡£¡£¡£
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
ÔھƵê¹ÜÀíϵͳÖÐ,ÓÐÒ»¸ö¶ÔÄÚµÄϵͳ,¹©Ç°Ì¨·þÎñÔ±ºÍ¾ÀíʹÓÃ
»¹ÓÐÒ»¸ö¾ÍÊǶÔÍâ,Èÿͻ§¿ÉÒÔÔÚÍøÉÏÔ¤¶©·¿¼ä,
ËüÃÇÖ®¼äÊÇÔõôͨѶµÄ.?µ±ÎÒÌá½»Ô¤¶©·¿¼äÐÅÏ¢µÄʱºò,
ÔÚ¶ÔÄÚµÄϵͳÖÐ,ÈçºÎÖªµÀÎÒÒѾÌá½»ÁËÐÅÏ¢¹ýÈ¥.Ê¹Ç ......
[align=center][/align]CÓïÑÔÖÐÈçºÎÅжÏÒ»¸ödoubleÐ͵ÄÊý×飨Èçdouble S[20]£»£©ÊÇÒ»¸ö¿ÕÊý×飬¼´Êý×éÖÐûÓзÅÈκÎÖµ¡£
û°ì·¨¡£
"ÈκÎÖµ" µÄ¶¨Òå?
¾ÍÊÇÊý×éÊǿյģ¬Ã»ÓÐΪËü¸³Öµ
¿ÉÒÔ¿¼Â ......