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("链接正确");
}