ch15demo1dlg.cpp

零基础学Visual.C....教案PPT.随书光盘-452M.zip

// Ch15Demo1Dlg.cpp : implementation file
//

#include "stdafx.h"
#include "Ch15Demo1.h"
#include "Ch15Demo1Dlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App About

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// Dialog Data
	//{{AFX_DATA(CAboutDlg)
	enum { IDD = IDD_ABOUTBOX };
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CAboutDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	//{{AFX_MSG(CAboutDlg)
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
	//{{AFX_DATA_INIT(CAboutDlg)
	//}}AFX_DATA_INIT
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAboutDlg)
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
	//{{AFX_MSG_MAP(CAboutDlg)
		// No message handlers
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCh15Demo1Dlg dialog

CCh15Demo1Dlg::CCh15Demo1Dlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCh15Demo1Dlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCh15Demo1Dlg)
	m_StuNo = _T("");
	m_StuName = _T("");
	m_StuAddress = _T("");
	m_StuTel = _T("");
	m_Status = _T("");
	m_radio = 0;//添加记录单选按钮选中
	//}}AFX_DATA_INIT
	// Note that LoadIcon does not require a subsequent DestroyIcon in Win32
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}

void CCh15Demo1Dlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCh15Demo1Dlg)
	DDX_Text(pDX, IDC_EDIT1, m_StuNo);
	DDV_MaxChars(pDX, m_StuNo, 6);
	DDX_Text(pDX, IDC_EDIT2, m_StuName);
	DDV_MaxChars(pDX, m_StuName, 8);
	DDX_Text(pDX, IDC_EDIT3, m_StuAddress);
	DDV_MaxChars(pDX, m_StuAddress, 10);
	DDX_Text(pDX, IDC_EDIT4, m_StuTel);
	DDV_MaxChars(pDX, m_StuTel, 11);
	DDX_Text(pDX, IDC_EDIT5, m_Status);
	DDX_Radio(pDX, IDC_RADIO1, m_radio);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CCh15Demo1Dlg, CDialog)
	//{{AFX_MSG_MAP(CCh15Demo1Dlg)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	ON_BN_CLICKED(IDC_RADIO1, OnRadio1)
	ON_BN_CLICKED(IDC_RADIO2, OnRadio2)
	ON_BN_CLICKED(IDC_RADIO3, OnRadio3)
	ON_BN_CLICKED(IDC_ADD, OnAdd)
	ON_BN_CLICKED(IDC_CHECKIN, OnCheckin)
	ON_BN_CLICKED(IDC_REMOVE, OnRemove)
	ON_BN_CLICKED(IDC_FIRST, OnFirst)
	ON_BN_CLICKED(IDC_LAST, OnLast)
	ON_BN_CLICKED(IDC_NEXT, OnNext)
	ON_BN_CLICKED(IDC_PREV, OnPrev)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCh15Demo1Dlg message handlers

BOOL CCh15Demo1Dlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	// Add "About..." menu item to system menu.

	// IDM_ABOUTBOX must be in the system command range.
	ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
	ASSERT(IDM_ABOUTBOX < 0xF000);

	CMenu* pSysMenu = GetSystemMenu(FALSE);
	if (pSysMenu != NULL)
	{
		CString strAboutMenu;
		strAboutMenu.LoadString(IDS_ABOUTBOX);
		if (!strAboutMenu.IsEmpty())
		{
			pSysMenu->AppendMenu(MF_SEPARATOR);
			pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
		}
	}

	// Set the icon for this dialog.  The framework does this automatically
	//  when the application's main window is not a dialog
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon
	
	// TODO: Add extra initialization here
	GetDlgItem(IDC_REMOVE)->EnableWindow(false);//禁用删除按钮
	GetDlgItem(IDC_CHECKIN)->EnableWindow(false);//禁用提交按钮
	//禁用导航按钮控件
	GetDlgItem(IDC_FIRST)->EnableWindow(false);//禁用第一条按钮
	GetDlgItem(IDC_NEXT)->EnableWindow(false);//禁用下一条按钮
	GetDlgItem(IDC_PREV)->EnableWindow(false);//禁用上一条按钮
	GetDlgItem(IDC_LAST)->EnableWindow(false);//禁用最后一条按钮
	HRESULT hr; 
	try 
	{ 
		hr = m_pConnection.CreateInstance("ADODB.Connection");//创建Connection对象 
		if(SUCCEEDED(hr)) 
		{ 
			//hr = m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Student.mdb","","",adModeUnknown);///连接数据库
			hr = m_pConnection->Open("studb","","",adModeUnknown);
		}
	}
	catch(_com_error e)///捕捉异常 
	{ 
		CString errormessage; 
		errormessage.Format("连接数据库失败!\r\n错误信息:%s",e.ErrorMessage()); 
		AfxMessageBox(errormessage);///显示错误信息 
	} 
	_variant_t RecordsAffected; 
	//m_pConnection->Execute("CREATE TABLE studentinfo(stuNo TEXT,stuname TEXT,stuaddress TEXT,stuphone TEXT)",&RecordsAffected,adCmdText); 
	return TRUE;  // return TRUE  unless you set the focus to a control

}

void CCh15Demo1Dlg::OnSysCommand(UINT nID, LPARAM lParam)
{
	if ((nID & 0xFFF0) == IDM_ABOUTBOX)
	{
		CAboutDlg dlgAbout;
		dlgAbout.DoModal();
	}
	else
	{
		CDialog::OnSysCommand(nID, lParam);
	}
}

// If you add a minimize button to your dialog, you will need the code below
//  to draw the icon.  For MFC applications using the document/view model,
//  this is automatically done for you by the framework.

void CCh15Demo1Dlg::OnPaint() 
{
	if (IsIconic())
	{
		CPaintDC dc(this); // device context for painting

		SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);

		// Center icon in client rectangle
		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;

		// Draw the icon
		dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
}

// The system calls this to obtain the cursor to display while the user drags
//  the minimized window.
HCURSOR CCh15Demo1Dlg::OnQueryDragIcon()
{
	return (HCURSOR) m_hIcon;
}

void CCh15Demo1Dlg::OnRadio1() 
{
	// TODO: Add your control notification handler code here
	m_radio=0;
	GetDlgItem(IDC_ADD)->EnableWindow(true);//激活添加按钮
	GetDlgItem(IDC_REMOVE)->EnableWindow(false);//禁用删除按钮
	GetDlgItem(IDC_CHECKIN)->EnableWindow(false);//禁用提交按钮
	//禁用导航按钮控件
	GetDlgItem(IDC_FIRST)->EnableWindow(false);//禁用第一条按钮
	GetDlgItem(IDC_NEXT)->EnableWindow(false);//禁用下一条按钮
	GetDlgItem(IDC_PREV)->EnableWindow(false);//禁用上一条按钮
	GetDlgItem(IDC_LAST)->EnableWindow(false);//禁用最后一条按钮
	m_StuNo=m_StuName=m_StuAddress=m_StuTel="";
	UpdateData(false);	
	
}

void CCh15Demo1Dlg::OnRadio2() 
{
	// TODO: Add your control notification handler code here
	m_radio=1;
	GetDlgItem(IDC_ADD)->EnableWindow(false);//禁用添加按钮
	GetDlgItem(IDC_REMOVE)->EnableWindow(true);//激活删除按钮
	GetDlgItem(IDC_CHECKIN)->EnableWindow(false);//禁用提交按钮
	//激活导航按钮控件
	GetDlgItem(IDC_FIRST)->EnableWindow(true);//激活第一条按钮
	GetDlgItem(IDC_NEXT)->EnableWindow(true);//激活下一条按钮
	GetDlgItem(IDC_PREV)->EnableWindow(true);//激活上一条按钮
	GetDlgItem(IDC_LAST)->EnableWindow(true);//激活最后一条按钮
	_variant_t RecordsAffected; 
	m_pRecordset =m_pConnection->Execute("SELECT COUNT(*) FROM studentinfo",&RecordsAffected,adCmdText); 
	_variant_t vIndex = (long)0; 
	_variant_t vCount = m_pRecordset->GetCollect(vIndex); //取得第一个字段的值放入vCount变量 
	count=vCount.lVal;//获取记录集的
	m_pRecordset->Close();///关闭记录集 
	if(count==0)//记录为0
	{
		GetDlgItem(IDC_REMOVE)->EnableWindow(false);//禁用删除按钮
		//禁用导航按钮控件
		GetDlgItem(IDC_FIRST)->EnableWindow(false);//禁用第一条按钮
		GetDlgItem(IDC_NEXT)->EnableWindow(false);//禁用下一条按钮
		GetDlgItem(IDC_PREV)->EnableWindow(false);//禁用上一条按钮
		GetDlgItem(IDC_LAST)->EnableWindow(false);//禁用最后一条按钮
		m_Status="表中没有数据！";
		UpdateData(false);
		return;
	}
	m_pRecordset.CreateInstance(__uuidof(Recordset));//创建记录集对象
	CString strSQL="SELECT * FROM studentinfo";
	try
	{
		//从数据库中打开表
		m_pRecordset->Open(_bstr_t(strSQL), m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
	}
	catch (_com_error e)
	{
		CString strError;
		strError.Format("警告：打开数据表时发生异常。错误信息：%s",e.ErrorMessage());
		AfxMessageBox(strError);
		return;
	}
	m_pRecordset->MoveFirst();//移到第一条记录
	curNo=1;
	m_Status.Format("共有%d条记录，当前第%d条",count,curNo);
	UpdateData(false);
	ShowRecord();//显示记录
	
}

void CCh15Demo1Dlg::OnRadio3() 
{
	// TODO: Add your control notification handler code here
	m_radio=2;
	GetDlgItem(IDC_ADD)->EnableWindow(false);//禁用添加按钮
	GetDlgItem(IDC_REMOVE)->EnableWindow(false);//禁用删除按钮
	GetDlgItem(IDC_CHECKIN)->EnableWindow(true);//激活提交按钮
	//激活导航按钮控件
	GetDlgItem(IDC_FIRST)->EnableWindow(true);//激活第一条按钮
	GetDlgItem(IDC_NEXT)->EnableWindow(true);//激活下一条按钮
	GetDlgItem(IDC_PREV)->EnableWindow(true);//激活上一条按钮
	GetDlgItem(IDC_LAST)->EnableWindow(true);//激活最后一条按钮
	_variant_t RecordsAffected; 
	m_pRecordset =m_pConnection->Execute("SELECT COUNT(*) FROM studentinfo",&RecordsAffected,adCmdText); 
	_variant_t vIndex = (long)0; 
	_variant_t vCount = m_pRecordset->GetCollect(vIndex); //取得第一个字段的值放入vCount变量 
	count=vCount.lVal;
	m_pRecordset->Close();///关闭记录集 
	if(count==0)//记录为0
	{
		GetDlgItem(IDC_CHECKIN)->EnableWindow(false);//禁用提交按钮
		//禁用导航按钮控件
		GetDlgItem(IDC_FIRST)->EnableWindow(false);//禁用第一条按钮
		GetDlgItem(IDC_NEXT)->EnableWindow(false);//禁用下一条按钮
		GetDlgItem(IDC_PREV)->EnableWindow(false);//禁用上一条按钮
		GetDlgItem(IDC_LAST)->EnableWindow(false);//禁用最后一条按钮
		return;
	}
	m_pRecordset.CreateInstance(__uuidof(Recordset));
	CString strSQL="SELECT * FROM studentinfo";
	try
	{
		//从数据库中打开表
		m_pRecordset->Open(_bstr_t(strSQL), m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
	}
	catch (_com_error e)
	{
		CString strError;
		strError.Format("警告：打开数据表时发生异常。 错误信息： %s",e.ErrorMessage());
		AfxMessageBox(strError);
		return;
	}
	m_pRecordset->MoveFirst();//移到第一条记录
	curNo=1;
	m_Status.Format("共有%d条记录，当前第%d条",count,curNo);
	UpdateData(false);
	ShowRecord();//显示记录	
}

void CCh15Demo1Dlg::OnAdd() 
{
	// TODO: Add your control notification handler code here
	_variant_t RecordsAffected; 
	UpdateData();
	if(m_StuNo.IsEmpty())
	{
		AfxMessageBox("学号不能为空！");
		return;
	}
	CString strSQL; 
	strSQL.Format("INSERT INTO studentinfo(stuNo,stuname,stuaddress,stuphone) VALUES ('%s', '%s','%s','%s')",m_StuNo,m_StuName,m_StuAddress,m_StuTel); 
	m_pConnection->Execute((_bstr_t)strSQL,&RecordsAffected,adCmdText); 
	m_Status="成功添加了一行记录！";
	m_StuNo=m_StuName=m_StuAddress=m_StuTel="";
	UpdateData(false);	
}

void CCh15Demo1Dlg::OnCheckin() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	m_pRecordset->PutCollect("stuNo",_variant_t(m_StuNo));
	m_pRecordset->PutCollect("stuname",_variant_t(m_StuName));
	m_pRecordset->PutCollect("stuaddress",_variant_t(m_StuAddress));
	m_pRecordset->PutCollect("stuphone",_variant_t(m_StuTel));
	m_pRecordset->Update();//提交记录
	m_Status="成功修改了一条记录！";
	UpdateData(false);
}

void CCh15Demo1Dlg::OnRemove() 
{
	// TODO: Add your control notification handler code here
	m_pRecordset->Delete(adAffectCurrent);
	m_Status="成功删除了一行记录！";
	count=count-1;
	UpdateData(false);
	OnFirst();
}

void CCh15Demo1Dlg::OnFirst() 
{
	// TODO: Add your control notification handler code here
	if(count==0)//记录为0
	{
		m_StuNo=m_StuName=m_StuAddress=m_StuTel="";
		UpdateData(false);	
		GetDlgItem(IDC_REMOVE)->EnableWindow(false);//禁用删除按钮
		//禁用导航按钮控件
		GetDlgItem(IDC_FIRST)->EnableWindow(false);//禁用第一条按钮
		GetDlgItem(IDC_NEXT)->EnableWindow(false);//禁用下一条按钮
		GetDlgItem(IDC_PREV)->EnableWindow(false);//禁用上一条按钮
		GetDlgItem(IDC_LAST)->EnableWindow(false);//禁用最后一条按钮
		return;
	}
	m_pRecordset->MoveFirst();//移到第一条记录
	curNo=1;
	m_Status.Format("共有%d条记录，当前第%d条",count,curNo);
	UpdateData(false);
	ShowRecord();//显示记录	
}

void CCh15Demo1Dlg::OnLast() 
{
	// TODO: Add your control notification handler code here
	m_pRecordset->MoveLast();//移到最后一条记录
	curNo=count;
	m_Status.Format("共有%d条记录，当前第%d条",count,curNo);
	UpdateData(false);
	ShowRecord();//显示记录
}

void CCh15Demo1Dlg::OnNext() 
{
	// TODO: Add your control notification handler code here
	if(curNo<count)
	{
		m_pRecordset->MoveNext();//移到下一条记录
		curNo++;
		if(m_pRecordset->adoEOF)
		{
			m_pRecordset->MoveLast();
		}
		m_Status.Format("共有%d条记录，当前第%d条",count,curNo);
		UpdateData(false);
		ShowRecord();//显示记录
	}	
}

void CCh15Demo1Dlg::OnPrev() 
{
	// TODO: Add your control notification handler code here
	if(curNo>1)
	{
		m_pRecordset->MovePrevious();//移到上一条记录
		curNo--;
		if(m_pRecordset->BOF)
		{
			m_pRecordset->MoveFirst();
		}
		m_Status.Format("共有%d条记录，当前第%d条",count,curNo);
		UpdateData(false);
		ShowRecord();//显示记录
	}	
	
}
void CCh15Demo1Dlg::ShowRecord()
{
	m_StuNo=(char*)_bstr_t(m_pRecordset->GetCollect("stuNo"));
	m_StuName=(char*)_bstr_t(m_pRecordset->GetCollect("stuname"));
	m_StuAddress=(char*)_bstr_t(m_pRecordset->GetCollect("stuaddress"));
	m_StuTel=(char*)_bstr_t(m_pRecordset->GetCollect("stuphone"));
	UpdateData(false);
}

BOOL CCh15Demo1Dlg::DestroyWindow() 
{
	// TODO: Add your specialized code here and/or call the base class
	if(m_pRecordset!=NULL)
	{
		m_pRecordset->Close();//关闭记录集对象
		m_pRecordset=NULL;
	}
	if(m_pConnection->State)
	{
		m_pConnection->Close();//关闭连接对象
		m_pConnection=NULL;
	}	
	return CDialog::DestroyWindow();
}