用户登录的实现
class CLearn18Dlg : public CDialog
{
// 构造
public:
CLearn18Dlg(CWnd* pParent = NULL);// 标准构造函数
// 对话框数据
enum { IDD = IDD_LEARN18_DIALOG };
protected:
virtual void DoDataExchange(CDataExchange* pDX);// DDX/DDV 支持
public:
virtual void OnOK();
virtual void OnCancel();
// 实现
protected:
HICON m_hIcon;
// 生成的消息映射函数
virtual BOOL OnInitDialog();
afx_msg void OnPaint();
afx_msg HCURSOR OnQueryDragIcon();
DECLARE_MESSAGE_MAP()
public:
// 用户名 编辑框
CEdit m_wndUser;
// 用户密码 编辑框
CEdit m_wndPwd;
// 用户名 字符串
CString m_strUser;
// 用户密码 字符串
CString m_strPwd;
// 保存密码 多选框
CButton m_wndSave;
// 自动登录 多选框
CButton m_wndAuto;
// 保存密码 标志位
UINT nSave;
// 自动登录 标志位
UINT nAuto;
private:
_ConnectionPtr m_pCon;
_RecordsetPtr m_pRecordset;
};
// Learn18Dlg.cpp : 实现文件
CLearn18Dlg::CLearn18Dlg(CWnd* pParent /*=NULL*/)
: CDialog(CLearn18Dlg::IDD, pParent),nSave(0),nAuto(0)
{
m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
m_strUser = "";
m_strPwd = "";
}
void CLearn18Dlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
DDX_Control(pDX, IDC_NAME, m_wndUser);
DDX_Control(pDX, IDC_PWD, m_wndPwd);
DDX_Text(pDX, IDC_NAME, m_strUser);
DDX_Text(pDX, IDC_PWD, m_strPwd);
DDX_Control(pDX, IDC_SAVE, m_wndSave);
DDX_Control(pDX, IDC_AUTO, m_wndAuto);
}
BOOL CLearn18Dlg::OnInitDialog()
{
CDialog::OnInitDialog();
// 设置此对话框的图标。当应用程序主窗口不是对话框时，框架将自动
// 执行此操作
SetIcon(m_hIcon, TRUE);// 设置大图标
SetIcon(m_hIcon, FALSE);// 设置小图标
// TODO: 在此添加额外的初始化代码
AfxOleInit();
try
{
HRESULT hr = m_pCon.CreateInstance(__uuidof(Connection));
if(SUCCEEDED(hr))
{
_bstr_t ConnectionString = "Provider=MSDASQL.1;Data Source=user";
m_pCon->Open(ConnectionString,"","",adModeUnknown);
}
}
catch(_com_error e)
{
CString strError;
strError.Format("%s",e.ErrorMessage());
AfxMessageBox(strError);
}
LPSTR lpPath = new CHAR[MAX_PATH];
strcpy(lpPath,"C:\\admin.ini");
GetPrivateProfileString("LoginInfo","username","",(LPSTR)(LPCTSTR)m_strUser,m_strUser.GetLength(),lpPath);
GetPrivateProfileString("LoginInfo","userpwd","",(LPSTR)(LPCTSTR)m_strPwd,m_strPwd.GetLength(),lpPath);
nSave = GetPrivateProfileInt("LoginInfo","nSave",0,lpPath);
nAuto = GetPrivateProfileInt("LoginInfo","nAuto",0,lpPath);
if(1 == nSave)
m_wndSave.SetCheck(TRUE);
else
m_wndSave.SetCheck(FALSE);
if(1 == nAuto)
m_wndAuto.SetCheck(TRUE);
else
m_wndAuto.SetCheck(FALSE);
AfxMessageBox(m_strUser);
return TRUE; // 除非设置了控件的焦点，否则返回 TRUE
}
// 如果向对话框添加最小化按钮，则需要下面的代码
// 来绘制该图标。对于使用文档/视图模型的 MFC 应用程序，
// 这将由框架自动完成。
void CLearn18Dlg::OnPaint()
{
if (IsIconic())
{
CPaintDC dc(this); // 用于绘制的设备上下文
SendMessage(WM_ICONERASEBKGND, reinterpret_cast<WPARAM>(dc.GetSafeHdc()), 0);
// 使图标在工作矩形中居中
int cxIcon = GetSystemMetrics(SM_CXICON);
int cyIcon = GetSystemMetrics(SM_CYICON);
CRect rect;
GetClientRect(&rect);
int x = (rect.Width() - cxIcon + 1) / 2;
int y = (rect.Height() - cyIcon + 1) / 2;
// 绘制图标
dc.DrawIcon(x, y, m_hIcon);
}
else
{
CDialog::OnPaint();
}
}
//当用户拖动最小化窗口时系统调用此函数取得光标显示。
HCURSOR CLearn18Dlg::OnQueryDragIcon()
{
return static_cast<HCURSOR>(m_hIcon);
}
void CLearn18Dlg::OnOK()
{
UpdateData(TRUE);
LPSTR lpPath = new CHAR[MAX_PATH];
strcpy(lpPath,"C:\\admin.ini");
WritePrivateProfileString("LoginInfo","username",m_strUser,lpPath);
WritePrivateProfileString("LoginInfo","userpwd",m_strPwd,lpPath);
if(m_wndSave.GetCheck())
WritePrivateProfileString("LoginInfo","nSave","1",lpPath);
else
WritePrivateProfileString("LoginInfo","nSave","0",lpPath);
if(m_wndAuto.GetCheck())
WritePrivateProfileString("LoginInfo","nAuto","1",lpPath);
else
WritePrivateProfileString("LoginInfo","nAuto","0",lpPath);
CString vName;
CString vPass;
try
{
m_pRecordset.CreateInstance(__uuidof(Recordset));
_variant_t strSql = "select * from user";
m_pRecordset->Open(strSql,(IDispatch *)m_pCon,adOpenStatic,adLockOptimistic,adCmdText);
while(!m_pRecordset->adoEOF)
{
vName = m_pRecordset->Fields->GetItem("name")->Value;
if(vName == m_strUser)
{
vPass = m_pRecordset->Fields->GetItem("pwd")->Value;
if(vPass == m_strPwd)
{
AfxMessageBox("登录成功");
}
}
m_pRecordset->MoveNext();
}
m_pRecordset->Close();
}
catch(_com_error e)
{
CString strError;
strError.Format("%s",e.ErrorMessage());
AfxMessageBox(strError);
m_pRecordset->Close();
m_pCon->Close();
m_pRecordset = NULL;
m_pCon = NULL;
}
CDialog::OnOK();
}
void CLearn18Dlg::OnCancel()
{
CDialog::OnCancel();
}
