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

1、从 mysql-noinstall-5.1.30-win32.zip 包中解压 include, lib 两个目录到使用C:vcprojectsmysql-5.1.30 中2、参考本博客Windows XP下MinGW的安装与配置 建好 Windows 下 GCC 的开发环境。3、进入目录C:vcprojectsmysql-5.1.30libopt执行命令：reimp -d libmysql.libdlltool -k -d libmysql.def -l libmysql.a生成gcc所需链接的mysql库 libmysql4、在C:vcprojectslearn目录下创建文件 visitsql.c (网友代码修改版)#include #include #include #include using 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; /connection if (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 set cout connection character set: mysql_character_set_name(sock) endl; /wait for posibility to check system/mysql sockets if(mysql_query(sock,select * from user) coutvery good!endl; results=mysql_store_result(sock); printf(主机t用户名n); while(record = mysql_fetch_row(results) printf(%st%s n,record0,record1); mysql_free_result(results); /system(PAUSE); /closing connection mysql_close(sock); return EXIT_SUCCESS;5、创建一个批处理文件 build.bat：set MYSQL_CLIB=C:vcprojectsmysql-5.1.30set C_INCLUDE_PATH=%C_INCLUDE_PATH%;%MYSQL_CLIB%includeset CPLUS_INCLUDE_PATH=%CPLUS_INCLUDE_PATH%;%MYSQL_CLIB%includeset LIBRARY_PATH=%LIBRARY_PATH%;%MYSQL_CLIB%liboptg+ -o visitsql visitsql.c -llibmysql执行该批处理，生成 visitsql.exe 执行该程序结果：sock handle ok!connection ok!connection character set: gb2312主机 用户名localhost root6、比较visitsql 大小：gcc 版 488KBvc+ debug 版 40KBvc+ release 版 10KB7、另从网上摘抄如果你的dlltool产生的libmysql.a是空文件的话，如下操作：cd mysql/lib/optreimp libmysql.libdlltool.exe -d mysql+/libmysqlclient.def -e mysqlclient.exp -l mysqlclient.a -S as备注：mingw-utils-0.3.t