mysql客户端的Windows C/C++编程实现（★firecat推荐★）

// mysqltest.cpp : 定义控制台应用程序的入口点。
//
#include "stdafx.h"
#include <mysql.h> //win32建议定义宏 #define WIN32_LEAN_AND_MEAN
#include <string>  
#include <iostream> 
using namespace std;
#pragma comment(lib, "../lib/libmysql.lib")
int main()
{
  //必备数据结构  
  MYSQL mydata;  //=mysql_init((MYSQL*)0);  
           //初始化数据结构  
  if (NULL != mysql_init(&mydata)) {
    cout << "mysql_init()succeed" << endl;
  }
  else {
    cout << "mysql_init()failed" << endl;
    return -1;
  }
  //初始化数据库  
  if (0 == mysql_library_init(0, NULL, NULL)) {
    cout << "mysql_library_init()succeed" << endl;
  }
  else {
    cout << "mysql_library_init()failed" << endl;
    return -1;
  }
  //连接数据库  
  if (NULL != mysql_real_connect(&mydata, "localhost", "root", "", "test", 3306, NULL, 0))
    //这里的地址，用户名，密码，数据库，端口可以根据自己本地的情况更改  
  {
    cout << "mysql_real_connect()succeed" << endl;
  }
  else
  {
    cout << "mysql_real_connect()failed" << endl;
    return -1;
  }
  //操作……  
  mysql_close(&mydata);
  system("pause");
    return 0;
}