stutable.cpp

是学生管理系统,本年的数据库作业,是本人完成的第一个管理系统.

// stutable.cpp : implementation file
//

#include "stdafx.h"
#include "Database1.h"
#include "stutable.h"

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

/////////////////////////////////////////////////////////////////////////////
// stutable dialog


stutable::stutable(CWnd* pParent /*=NULL*/)
	: CDialog(stutable::IDD, pParent)
{
	//{{AFX_DATA_INIT(stutable)
	//}}AFX_DATA_INIT
}


void stutable::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(stutable)
	DDX_Control(pDX, IDC_LIST1, m_stutable);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(stutable, CDialog)
	//{{AFX_MSG_MAP(stutable)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// stutable message handlers
BOOL stutable::OnInitDialog()
{
	CDialog::OnInitDialog();
	long lStyleOld,lStyle;
	lStyle=LVS_REPORT;
	lStyleOld = GetWindowLong(m_stutable.m_hWnd, GWL_STYLE);
	lStyleOld &= ~(LVS_TYPEMASK);  // 取消所有显示风格
	lStyleOld |= lStyle;        // 设置新的风格
	SetWindowLong(m_stutable.m_hWnd, GWL_STYLE, lStyleOld);

	m_stutable.SetExtendedStyle(LVS_EX_FULLROWSELECT| LVS_EX_GRIDLINES);
	m_stutable.DeleteAllItems();
	m_stutable.InsertColumn(0,"学号",LVCFMT_LEFT,-1,-1);
	m_stutable.InsertColumn(1,"姓名",LVCFMT_LEFT,-1,-1);
	m_stutable.InsertColumn(2,"性别",LVCFMT_LEFT,-1,-1);
	m_stutable.InsertColumn(3,"年龄",LVCFMT_LEFT,-1,-1);
	m_stutable.InsertColumn(4,"班级",LVCFMT_LEFT,-1,-1);

	m_stutable.SetColumnWidth(0,80);
	m_stutable.SetColumnWidth(1,80);
	m_stutable.SetColumnWidth(2,80);
	m_stutable.SetColumnWidth(3,80);
	m_stutable.SetColumnWidth(4,80);
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set e focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE

}


//DEL void stutable::OnDisplay()
//DEL {
//DEL AfxMessageBox("如果要结束显示，请按回车（Enter）键\n THE ENTER KEY WILL END THE DISPLAY");
//DEL CRecordset rs(theApp.GetDBConnect());
//DEL 	//now i can receive the code or words from the dialog;
//DEL rs.Open(CRecordset::dynaset,"SELECT XH,XM,XB,NL,BJ FROM stutable",CRecordset::executeDirect);
//DEL 
//DEL CString sql;
//DEL int i = 0;
//DEL 	m_stutable.DeleteAllItems();
//DEL 	while(!rs.IsEOF())
//DEL 	{
//DEL 		CString sName;
//DEL 		CString sNumber;
//DEL 		CString sSex;
//DEL 		CString sAge;
//DEL 		CString sClass;
//DEL 
//DEL 		rs.GetFieldValue("XH",sNumber);
//DEL 		rs.GetFieldValue("XM",sName);
//DEL 		rs.GetFieldValue("XB",sSex);
//DEL 		rs.GetFieldValue("NL",sAge);
//DEL 		rs.GetFieldValue("BJ",sClass);
//DEL 
//DEL 		m_stutable.InsertItem(i,sNumber);
//DEL 		m_stutable.SetItemText(i,1,sName);
//DEL 		m_stutable.SetItemText(i,2,sSex);
//DEL 		m_stutable.SetItemText(i,3,sAge);
//DEL 		m_stutable.SetItemText(i++,4,sClass);
//DEL 
//DEL 		rs.MoveNext();
//DEL 	}
//DEL }

//DEL void stutable::OnShowStu()
//DEL {
//DEL 
//DEL AfxMessageBox("如果要结束显示，请按回车（Enter）键\n THE ENTER KEY WILL END THE DISPLAY");
//DEL CRecordset rs(theApp.GetDBConnect());
//DEL 	//now i can receive the code or words from the dialog;
//DEL rs.Open(CRecordset::dynaset,"SELECT XH,XM,XB,NL,BJ FROM stutable",CRecordset::executeDirect);
//DEL 
//DEL CString sql;
//DEL int i = 0;
//DEL 	m_stutable.DeleteAllItems();
//DEL 	while(!rs.IsEOF())
//DEL 	{
//DEL 		CString sName;
//DEL 		CString sNumber;
//DEL 		CString sSex;
//DEL 		CString sAge;
//DEL 		CString sClass;
//DEL 
//DEL 		rs.GetFieldValue("XH",sNumber);
//DEL 		rs.GetFieldValue("XM",sName);
//DEL 		rs.GetFieldValue("XB",sSex);
//DEL 		rs.GetFieldValue("NL",sAge);
//DEL 		rs.GetFieldValue("BJ",sClass);
//DEL 
//DEL 		m_stutable.InsertItem(i,sNumber);
//DEL 		m_stutable.SetItemText(i,1,sName);
//DEL 		m_stutable.SetItemText(i,2,sSex);
//DEL 		m_stutable.SetItemText(i,3,sAge);
//DEL 		m_stutable.SetItemText(i++,4,sClass);
//DEL 
//DEL 		rs.MoveNext();
//DEL 	}
//DEL }
/*显示学生表的函数*/
void stutable::OnButton1() 
{


CRecordset rs(theApp.GetDBConnect());
	//now i can receive the code or words from the dialog;
rs.Open(CRecordset::dynaset,"SELECT XH,XM,XB,NL,BJ FROM stutable",CRecordset::executeDirect);


    int i = 0;
	m_stutable.DeleteAllItems();
	while(!rs.IsEOF())
	{
		CString sName;
		CString sNumber;
		CString sSex;
		CString sAge;
		CString sClass;

		rs.GetFieldValue("XH",sNumber);
		rs.GetFieldValue("XM",sName);
		rs.GetFieldValue("XB",sSex);
		rs.GetFieldValue("NL",sAge);
		rs.GetFieldValue("BJ",sClass);

		m_stutable.InsertItem(i,sNumber);
		m_stutable.SetItemText(i,1,sName);
		m_stutable.SetItemText(i,2,sSex);
		m_stutable.SetItemText(i,3,sAge);
		m_stutable.SetItemText(i++,4,sClass);

		rs.MoveNext();
	}
	// TODO: Add your control notification handler code here
	
}