海波无痕

环境win32、mingw、codelite
1、下载mysql Microsoft Windows 32. (ZIP format)
http://downloads.mysql.com/archives.php
获得mysql-noinstall-5.1.45-win32.zip，解压缩。
2、用 reimp.exe将libmysql.lib转换为libmysql.a
获取reimp.exe 从http://www.qtcn.org/download/mingw-utils-0.3.tar.gz解压缩
拷贝D:\mysql-5.1.45-win32\lib\opt\libmysql.lib到 reimp目录下。在cmd进入目录并执行
reimp libmysql.lib
执行完后产生liblibmysql.a和LIBMYSQL.def
将liblibmysql.a改名为libmysql.a,并拷贝回D:\mysql-5.1.45-win32\lib\opt\目录下
3、Complier-->Additional Search Path设置为
.;D:\mysql-5.1.45-win32\include;D:\MinGW\include\c++\3.4.5;D:\MinGW\include\c++\3.4.5\mingw32;D:\MinGW\include\c++\3.4.5\backward;D:\MinGW\include;
4、Linker-->Libray Path设置为
D:\MinGW\lib;D:\mysql-5.1.45-win32\lib\opt
      Linker-->Libraries设置为
libmysql;libwsock32;
5、编写程序
将D:\mysql-5.1.45-win32\lib\opt\libmysql.dll拷贝到C:\WINDOWS\system32目录下
main.cpp
#include "MySqlTestClass.h"
int main(int argc, char* argv[]){
 MySqlTestClass* myClass = new MySqlTestClass("127.0.0.1","3306","root","root","test1");
 myClass->testMysql();
    return 0;
}

MySqlTestClass.h
class MySqlTestClass
{
protected:
 char* dbAddress;
 char* dbPort;
 char* dbUser;
 char* dbPassword;
 char* dbName;
 
public:
 MySqlTestClass();
 MySqlTestClass(char* dbAddress,char* dbPort,char* dbUser,char* dbPassword,char* dbName);
 void testMysql();
};

MySqlTestClass.cpp
#include <MySqlTestClass.h>
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <windows.h>
#include <winsock.h>
#include <mysql.h>

MySqlTestClass::MySqlTestClass()
{
 
}

MySqlTestClass::MySqlTestClass(char* dbAddress,char* dbPort,char* dbUser,char* dbPassword,char* dbName)
{
 this->dbAddress=dbAddress;
 this->dbPassword=dbPort;
 this->dbUser=dbUser;
 this->dbPassword=dbPassword;
 this->dbName=dbName;
}

void MySqlTestClass::testMysql(){

 MYSQL mysql;
 MYSQL_RES *res;
 MYSQL_ROW row;
 char *query;
 int t,r;
 mysql_init(&mysql);
 if (!mysql_real_connect(&mysql,this->dbAddress,this->dbUser, this->dbPassword, this->dbName,0,NULL,CLIENT_MULTI_STATEMENTS))
 {
       printf( "Error connecting to database: %s\n",mysql_error(&mysql));
 }
 else printf("Connected...\n");
 query = "select * from user";

  
 t = mysql_real_query(&mysql,query,(unsigned int) strlen(query));
 if (t)
 {
  printf("Error making query: %s\n",
  mysql_error(&mysql));
 }else {
  printf("[%s] made...\n", query);
 }
 res = mysql_store_result(&mysql);
 while(row = mysql_fetch_row(res))
 {
  for(t=0;t<mysql_num_fields(res);t++)
  {
   printf("%s ",row[t]);
  }
 printf("\n");
 }
 
 printf("mysql_free_result...\n");
 mysql_free_result(res);

}