CC连接MySQL(GCC版)以及VC.docxVIP

1、从 mysql-noinstall-5.1.30-win32.zip 包中解压 include, lib 两个目录到?使用C:\vcprojects\mysql-5.1.30 中?2、参考本博客《Windows XP下MinGW的安装与配置》建好 Windows 下 GCC 的开发环境。?3、进入目录C:\vcprojects\mysql-5.1.30\lib\opt执行命令：?reimp -d libmysql.lib?dlltool -k -d libmysql.def -l libmysql.a?生成gcc所需链接的mysql库libmysql?4、在C:\vcprojects\learn目录下创建文件visitsql.c (网友代码修改版)?#include windows.h#include iostream#include mysql.h#include stdio.husing namespace std;int main(){ //connection params //FILE *file;char *host = localhost;char *user = root;char *pass = 12345;char *db = mysql; //sock MYSQL *sock; MYSQL_RES *results; MYSQL_ROW record;sock = mysql_init(0);if (sock) cout sock handle ok! endl;else {cout sock handle failed! mysql_error(sock) endl; } //connectionif (mysql_real_connect(sock, host, user, pass, db, 0, NULL, 0))cout connection ok! endl;else {cout connection fail: mysql_error(sock) endl; }mysql_set_character_set(sock,gb2312); //connection character setcout connection character set: mysql_character_set_name(sock) endl; //wait for posibility to check system/mysql socketsif(mysql_query(sock,select * from user)) {coutvery good!endl; }results=mysql_store_result(sock);printf(主机\t用户名\n);while(record = mysql_fetch_row(results)) {printf(%s\t%s \n,record[0],record[1]); }mysql_free_result(results); //system(PAUSE); //closing connectionmysql_close(sock);return EXIT_SUCCESS;}5、创建一个批处理文件 build.bat：?set MYSQL_CLIB=C:\vcprojects\mysql-5.1.30?set C_INCLUDE_PATH=%C_INCLUDE_PATH%;%MYSQL_CLIB%\include?set CPLUS_INCLUDE_PATH=%CPLUS_INCLUDE_PATH%;%MYSQL_CLIB%\include?set LIBRARY_PATH=%LIBRARY_PATH%;%MYSQL_CLIB%\lib\opt?g++ -ovisitsqlvisitsql.c -llibmysql?执行该批处理，生成 visitsql.exe 执行该程序结果：?sock handle ok!?connection ok!?connection character set: gb2312?主机??? 用户名?localhost?????? root?6、比较visitsql大小：?gcc版????????? 488KB?vc++ debug 版?? 40KB?vc++ release 版 10KB?7、另从网上摘抄?如果你的dlltool产生的libmysql.a是空文件的话，如下操作：?cd {mysql}/lib/opt?reimp li