Question

MFC如何用数据库

Answer 1

你首先安装Mysql,然后使用下面代码
在MyProc类中增加MySqlConnect方法，strUSR,strPWD分别为用户名和密码，登陆数据库需要
BOOL MyPorc::MySqlConnect(CString strUSR,CString strPWD)
{
unsigned short Port = 3306; //端口
CString IPAddress ="127.0.0.1"; //本地数据库
CString UserName = strUSR;
CString Password = strPWD;

ssock=(MYSQL *)malloc(sizeof(MYSQL));
mysql_init(ssock);
if(ssock == NULL)
{
AfxMessageBox("连接失败,请稍后在试! ");
return FALSE;
}

ssock = mysql_real_connect(ssock, IPAddress, UserName, Password, NULL, Port, NULL, 0);
if(!ssock)
{
unsigned int mtint = mysql_errno(ssock);
AfxMessageBox("登陆失败! ");
return FALSE;
}
return TRUE;
}