logindlg.cpp

图书管理系统,相对全面,ODBC学习的好材料,仅攻学习,谢绝抄袭

// LoginDlg.cpp : implementation file
//

#include "stdafx.h"
#include "MyLib.h"
#include "LoginDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CLoginDlg dialog


CLoginDlg::CLoginDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CLoginDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLoginDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CLoginDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLoginDlg)
		// NOTE: the ClassWizard will add DDX and DDV calls here
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CLoginDlg, CDialog)
	//{{AFX_MSG_MAP(CLoginDlg)
	ON_BN_CLICKED(IDC_SELECT, OnSelect)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLoginDlg message handlers

void CLoginDlg::OnSelect() 
{
	// TODO: Add your control notification handler code here
	CFileDialog f(TRUE);
	if(f.DoModal() == IDOK)
	{
		fPath = f.GetPathName();
		CString str = f.GetFileName();
		int len = str.GetLength();
		sPath = str.Left(fPath.GetLength()-len);

		CString szDesc;
		
		szDesc.Format( "DSN=%s; DESCRIPTION=TOC support source; DBQ=%s; DEFAULTDIR=%s; ",
			           "MyLib",fPath,sPath );
		
		if (FALSE == SQLConfigDataSource(NULL,ODBC_ADD_DSN,
			                             "Microsoft Access Driver (*.mdb)\0",szDesc))
		{
			AfxMessageBox("配置ODBC失败!");
		}
		SetDlgItemText(IDC_EDIT3,fPath);
	}
	
}

void CLoginDlg::OnOK() 
{
	CString m_Name;
	CString m_Pass;
	GetDlgItemText(IDC_EDIT1,m_Name);
	GetDlgItemText(IDC_EDIT2,m_Pass);
	if(m_Name.IsEmpty())
	{
		MessageBox("请输入用户名!");
		return;
	}
	CString sqlstr = "SELECT * FROM ADMI WHERE ID='";
	sqlstr += m_Name;
	sqlstr += "' AND PASSWORD='";
	sqlstr += m_Pass;
	sqlstr += "'";
	if(!clerkset.Open(AFX_DB_USE_DEFAULT_TYPE,sqlstr))
	{
		MessageBox("管理员表打开失败!");
		return;	
	}
	
	if(!clerkset.IsEOF())
	{
		clerkset.Close();
		CDialog::OnOK();
	}
	else
	{
		MessageBox("登陆失败!");
		SetDlgItemText(IDC_EDIT1,"");
		SetDlgItemText(IDC_EDIT2,"");
		clerkset.Close();
		return;
	}
}