studentinfomation.cpp

用vc实现的连接sql数据库程序

// StudentInfomation.cpp : implementation file
//

#include "stdafx.h"
#include "数据库作业.h"
#include "StudentInfomation.h"

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

/////////////////////////////////////////////////////////////////////////////
// CStudentInfomation dialog


CStudentInfomation::CStudentInfomation(CWnd* pParent /*=NULL*/)
	: CDialog(CStudentInfomation::IDD, pParent)
{
	//{{AFX_DATA_INIT(CStudentInfomation)
	m_sno = _T("");
	m_sname = _T("");
	m_sage = 0;
	m_ssex = _T("");
	m_sdept = _T("");
	m_bDateStatus = FALSE;
	m_sWindowTitle = _T("添加学生");
	//}}AFX_DATA_INIT
}


void CStudentInfomation::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CStudentInfomation)
	DDX_Text(pDX, IDC_EDIT1, m_sno);
	DDX_Text(pDX, IDC_EDIT2, m_sname);
	DDX_Text(pDX, IDC_EDIT3, m_sage);
	DDV_MinMaxInt(pDX, m_sage, 0, 120);
	DDX_Text(pDX, IDC_EDIT4, m_ssex);
	DDX_Text(pDX, IDC_EDIT5, m_sdept);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CStudentInfomation message handlers

void CStudentInfomation::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	if(CheckDate())
	{
		m_date.name = m_sname;
		m_date.no = m_sno;
		m_date.age = m_sage;
		m_date.sex = m_ssex;
		m_date.dept = m_sdept;
		m_bDateStatus = TRUE;  //标记数据以存储
		CDialog::OnOK();
	}
}

BOOL CStudentInfomation::CheckDate()
{
	CString sErr;
	if(m_sno.IsEmpty())
	{
		sErr += "学号必须输入";
		AfxMessageBox(sErr);
		return FALSE;
	}
	if(m_sname.IsEmpty())
	{
		sErr += "姓名必须输入";
		AfxMessageBox(sErr);
		return FALSE;
	}
	if (m_sage<0||m_sage>120)
	{
		sErr += "年龄输入有误";
		AfxMessageBox(sErr);
		return FALSE;
	}
	if (!m_ssex.IsEmpty())
	{
		if (m_ssex.Compare("男")!=0&&m_ssex.Compare("女")!=0)
		{
			sErr += "性别输入有误";
			AfxMessageBox(sErr);
			return FALSE;
		}
	}
	return TRUE;
}

studentinfo CStudentInfomation::GetDate() const
{
	return m_date;
}

BOOL CStudentInfomation::GetDateStatus() const
{
	return m_bDateStatus;
}

void CStudentInfomation::SetDate(studentinfo data)
{
	m_sno = data.no;
	m_sname = data.name;
	m_sage = data.age;
	m_ssex = data.sex;
	m_sdept = data.dept;
}

BOOL CStudentInfomation::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	SetWindowText(m_sWindowTitle);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}