MFC应用程序为Release版
1.拷贝libmysql.dll文件(在mysql安装路径lib\opt下)到项目的主目录,根目录里面的同名目录
2.添加两个目录路径,包含目录和库目录
添加两个目录路径,右键项目属性,VC++目录,
包含目录:D:\dev\mysql50\include;
库目录:D:\dev\mysql50\lib\opt;(因为创建的项目为Release版)
3.声明一个MYSQL实体,在头文件中#include "mysql.h"
在构造函数的public处:MYSQL m_ssock; //数据库连接句柄
4.在cpp文件中添加 #pragma comment(lib,"libmysql.lib")
初始化数据库,测试是否连接成功 void CmysqldemoDlg::InitMysql() { unsigned short Port = 3306; char *IPAddress = "localhost"; //char *IPAddress = "192.168.3.11"; char *UserName = "dev"; char *Password = "dev"; char *DBName = "forward_qutation"; unsigned long i; MYSQL_RES *res; MYSQL_ROW row; //char execsql[500]; //m_ssock = (MYSQL *)malloc(sizeof(MYSQL)); mysql_init(&m_ssock); if(&m_ssock == NULL){ ::AfxMessageBox("数据库初始出错!"); return; } if(!mysql_real_connect(&m_ssock, IPAddress, UserName, Password, DBName, Port, NULL, 0)){ ::AfxMessageBox("数据库链接失败!"); return; } ::AfxMessageBox("链接正确"); }