cc連接mysql(gcc版)以及vc

《cc連接mysql(gcc版)以及vc》由會員上傳分享，免費在線閱讀，更多相關內(nèi)容在應用文檔-天天文庫。

1、1、從mysql-noinstall-5.1.30-win32.zip包中解壓include,lib兩個目錄到?使用C:vcprojectsmysql-5.1.30中?2、參考本博客《WindowsXP下MinGW的安裝與配置》建好Windows下GCC的開發(fā)環(huán)境。?3、進入目錄C:vcprojectsmysql-5.1.30libopt執(zhí)行命令：?reimp-dlibmysql.lib?dlltool-k-dlibmysql.def-llibmysql.a?生成gcc所需鏈接的mysql庫libmysql?4、在C:vcprojects

2、learn目錄下創(chuàng)建文件visitsql.c(網(wǎng)友代碼修改版)?#include#include#include#includeusingnamespacestd;intmain(){//connectionparams//FILE*file;char*host="localhost";char*user="root";char*pass="12345";char*db="mysql";//sockMYSQL*sock;MYSQL_RES*results;MYSQL_ROW

3、record;sock=mysql_init(0);if(sock)cout<<"sockhandleok!"<

4、character_set(sock,"gb2312");//connectioncharactersetcout<<"connectioncharacterset:"<

5、戶名");while(record=mysql_fetch_row(results)){printf("%st%s",record[0],record[1]);}mysql_free_result(results);//system("PAUSE");//closingconnectionmysql_close(sock);returnEXIT_SUCCESS;}5、創(chuàng)建一個批處理文件build.bat：?setMYSQL_CLIB=C:vcprojectsmysql-5.1.30?setC_INCLUDE_PATH=%C_INCLUDE

6、_PATH%;%MYSQL_CLIB%include?setCPLUS_INCLUDE_PATH=%CPLUS_INCLUDE_PATH%;%MYSQL_CLIB%include?setLIBRARY_PATH=%LIBRARY_PATH%;%MYSQL_CLIB%libopt?g++-ovisitsqlvisitsql.c-llibmysql?執(zhí)行該批處理，生成visitsql.exe執(zhí)行該程序結果：?sockhandleok!?connectionok!?connectioncharacterset:gb2312?主機???用戶名?loca

7、lhost??????root?6、比較visitsql大?。?gcc版?????????488KB?vc++debug版??40KB?vc++release版10KB?7、另從網(wǎng)上摘抄?如果你的dlltool產(chǎn)生的libmysql.a是空文件的話，如下操作：?cd{mysql}/lib/opt?reimplibmysql.lib?dlltool.exe-d{mysql++}/libmysqlclient.def-emysqlclient.exp-lmysqlclient.a-Sas?備注：?mingw-utils-0.3.tar.gz?binutil

8、s-2.17.50-20060824-1.tar.gz?//reimpmysqlclient.