librarydlg.cpp

< Visual C+++SQL Server数据库开发与实例>>一书中的实例核心源程序提供了几个案例的编程源代码。

// LibraryDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LibDBS.h"
#include "LibraryDlg.h"
#include "LoginSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CLibraryDlg dialog


CLibraryDlg::CLibraryDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CLibraryDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLibraryDlg)
	m_strUsername = _T("lib");
	m_strPassword = _T("lib");
	//}}AFX_DATA_INIT
}


void CLibraryDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLibraryDlg)
	DDX_Text(pDX, IDC_EDIT_USER, m_strUsername);
	DDX_Text(pDX, IDC_EDIT_PASSWD, m_strPassword);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CLibraryDlg, CDialog)
	//{{AFX_MSG_MAP(CLibraryDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLibraryDlg message handlers

void CLibraryDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	if(m_strUsername.IsEmpty())
	{
		MessageBox("Please input your username!","登录系统",MB_OK|MB_ICONEXCLAMATION);
		m_strUsername.Empty();
		UpdateData(FALSE);
		return;
	}

	if(!m_database.IsOpen())
	{
		//连接数据源
		if(!m_database.Open(_T("Library")))
		{
			MessageBox("连接数据库失败!","图书管理系统",MB_OK|MB_ICONINFORMATION);
			return;
		}
	}
	
	CLoginSet *m_pLogset=new CLoginSet(&m_database);

	//编写SQL语句
	CString strSQL;
	strSQL.Format("select * from Admin_Info where User_Name='%s' AND Password='%s'",m_strUsername,m_strPassword);
	//编写SQL语句结束

	m_pLogset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	
	if(m_pLogset->GetRecordCount()==0)
	{
		if(count<5)
		{
			MessageBox("登录失败!","图书管理系统",MB_OK|MB_ICONERROR);
			count++;
			m_strPassword.Empty();
			m_strUsername.Empty();
			UpdateData(FALSE);
		}
		else
		{
			m_database.Close();
			MessageBox("您登录失败超过5次，请与管理员联系!","图书管理系统");
			OnOK();
		}
	}
	else
	{
		m_database.Close();
		*b_Login = 0;
		CDialog::OnOK();
	}
	
	
}

void CLibraryDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
}