MySQL MFC编程_MFC+Mysql 编程

// TODO: Add extra initialization here

m_db.OpenEx(_T("DSN=mydb;UID=root;PWD=deathnote"),CDatabase::noOdbcDialog);

MessageBox(_T("连接成功！"),_T("登入系统"),MB_OK|MB_ICONINFORMATION);

在登入按钮函数 OnBnClickedOk中添加如下代码

void CmydbDlg::OnBnClickedOk()

{

// TODO: Add your control notification handler code here

UpdateData();

Cadmin_info *m_pLogset = new Cadmin_info(&m_db);

CString strSQL;

strSQL.Format(_T("select * from Admin_Info where User_Name='%s' AND Password='%s'"),m_uer_name,m_password);

m_pLogset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);

if(m_pLogset->GetRecordCount()==0)

{

if(count<2)

{

count++;

MessageBox(_T("用户名或密码错误，请重新输入！"),_T("登入系统"),MB_OK|MB_ICONERROR);

m_uer_name.Empty();

m_password.Empty();

UpdateData(FALSE);

return ;

}

else

{

m_db.Close();

MessageBox(_T("登入失败超过3次，请于管理员联系！"),_T("登入系统"),MB_OK|MB_ICONERROR);

CDialogEx::OnOK();

}

}

else

{

MessageBox(_T("恭喜，登入成功！"),_T("登入系统"),MB_OK|MB_ICONINFORMATION);

//CDialogEx::OnOK();

DialogMain dlgmain;

dlgmain.m_name = m_uer_name;

dlgmain.DoModal();

OnCancel();

}

}

到此为止，登入界面完成，编译，运行.