coursechoseview.cpp

学生选课系统,功能齐全,什么登陆,查询,选课,删除课程,什么都有,有数据库

// CourseChoseView.cpp : CCourseChoseView 类的实现
//

#include "stdafx.h"
#include "CourseChose.h"

#include "CourseChoseDoc.h"
#include "CourseChoseView.h"
#include "LoadDialog.h"
#include "MysqlOperat.h"
#include ".\coursechoseview.h"
#include "TeacherDialog.h"
#include "StudentDialog.h"

#include <iostream>
using namespace std;

#ifdef _DEBUG
#define new DEBUG_NEW
#endif


extern CMysqlOperat MysqlOp;

// CCourseChoseView

IMPLEMENT_DYNCREATE(CCourseChoseView, CView)

BEGIN_MESSAGE_MAP(CCourseChoseView, CView)
	// 标准打印命令
	ON_COMMAND(ID_FILE_PRINT, CView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_DIRECT, CView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_PREVIEW, CView::OnFilePrintPreview)
	ON_COMMAND(IDM_COURSE_OPERATOR, OnCourseOperator)
	ON_COMMAND(IDM_COURSE_SHOW, OnCourseShow)
	ON_COMMAND(IDM_COURSE_CHOSE, OnCourseChose)
	ON_COMMAND(IDM_SHOW_ME, OnShowMe)
	ON_COMMAND(IDM_ALL_COURSE, OnAllCourse)
END_MESSAGE_MAP()

// CCourseChoseView 构造/析构

CCourseChoseView::CCourseChoseView()
{
	// TODO: 在此处添加构造代码
	m_bLoad = FALSE;
	m_dwID = 0;
}

CCourseChoseView::~CCourseChoseView()
{
}

BOOL CCourseChoseView::PreCreateWindow(CREATESTRUCT& cs)
{
	// TODO: 在此处通过修改 CREATESTRUCT cs 来修改窗口类或
	// 样式

	return CView::PreCreateWindow(cs);
}

// CCourseChoseView 绘制

void CCourseChoseView::OnDraw(CDC* pDC)
{
	CCourseChoseDoc* pDoc = GetDocument();
	ASSERT_VALID(pDoc);
	if (!pDoc)
		return;

	// TODO: 在此处为本机数据添加绘制代码
	char static	szTemp[100] = "\0";


	if (!m_bLoad)
	{
		Load();
	}

	switch (this->m_nLoadState)
	{
	case LOAD_STATE_STUDENT:
		sprintf(szTemp, "学生登入成功！学号：%ld", this->m_dwID);
		pDC->TextOut(10, 10, szTemp);

		break;

	case LOAD_STATE_TEACHER:
                sprintf(szTemp, "教师登入成功！教师ID：%ld", this->m_dwID);
		pDC->TextOut(10, 10, szTemp);

		break;

	default:
		pDC->TextOut(0, 0, "登入出错！！");
	}
}

void CCourseChoseView::Load()
{

	m_bLoad = TRUE;

	CLoadDialog	myLoad;

	myLoad.DoModal();

	this->m_dwID = myLoad.m_dwID;

	switch (myLoad.m_bState)
	{
	case LOAD_STATE_ERROR:

		exit(0);

		break;

	case LOAD_STATE_STUDENT:

		m_nLoadState = LOAD_STATE_STUDENT;

		break;

	case LOAD_STATE_TEACHER:

		m_nLoadState = LOAD_STATE_TEACHER;

		break;

	default:

		MessageBox(TEXT("程序遇到未知错误推出。。。"));
	}
}

// CCourseChoseView 打印

BOOL CCourseChoseView::OnPreparePrinting(CPrintInfo* pInfo)
{
	// 默认准备
	return DoPreparePrinting(pInfo);
}

void CCourseChoseView::OnBeginPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: 打印前添加额外的初始化
}

void CCourseChoseView::OnEndPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: 打印后添加清除过程
}


// CCourseChoseView 诊断

#ifdef _DEBUG
void CCourseChoseView::AssertValid() const
{
	CView::AssertValid();
}

void CCourseChoseView::Dump(CDumpContext& dc) const
{
	CView::Dump(dc);
}

CCourseChoseDoc* CCourseChoseView::GetDocument() const // 非调试版本是内联的
{
	ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CCourseChoseDoc)));
	return (CCourseChoseDoc*)m_pDocument;
}
#endif //_DEBUG


// CCourseChoseView 消息处理程序

//教师操作
void CCourseChoseView::OnCourseOperator()
{
	// TODO: Add your command handler code here

	CTeacherDialog myTeacherDialog;

	myTeacherDialog.DoModal();
}

void CCourseChoseView::OnCourseShow()
{
	// TODO: Add your command handler code here
	SQLRETURN	retCode;
	DWORD		dwError	= 0;
	SQLINTEGER	dwSid = 0;
	
	SQLCHAR		szName[10]	= "\0";
	SQLCHAR		szPasswd[20]	= "\0";

	int		nResult		= 0;
	char		szSQL[100]	= "\0";

	sprintf(szSQL, "select tid, tname,tpassword from teacher where tid = %ld;", this->m_dwID);

	retCode = SQLAllocHandle(SQL_HANDLE_STMT, MysqlOp.hdbc, &MysqlOp.hstmt);
	if ( (retCode != SQL_SUCCESS) && (retCode != SQL_SUCCESS_WITH_INFO) )
	{
		dwError = GetLastError();

		cout << "SQLAllocHandle error = " << dwError << endl;

		return;
	}

	retCode = SQLExecDirect(MysqlOp.hstmt, (SQLCHAR*)szSQL, SQL_NTS);
	if ( (retCode != SQL_SUCCESS) && (retCode != SQL_SUCCESS_WITH_INFO) )
	{
		dwError = GetLastError();

		cout << "SQLExecDirectA error = " << dwError << endl;

		MessageBox("数据库操作失败");

		return;
	}

	retCode = SQLFetch(MysqlOp.hstmt);
	if (retCode == SQL_ERROR)
	{
		MessageBox("查询出错！");

		return;
	}	
	else if (retCode == SQL_NO_DATA)
	{	

	}
	else
	{		
		SQLGetData(MysqlOp.hstmt, 1, SQL_INTEGER, &dwSid, 8, (SQLINTEGER*)&nResult);
		SQLGetData(MysqlOp.hstmt, 2, SQL_CHAR, szName, 10, (SQLINTEGER*)&nResult);
		SQLGetData(MysqlOp.hstmt, 3, SQL_CHAR, szPasswd, 16, (SQLINTEGER*)&nResult);

		this->Invalidate();
		this->UpdateWindow();
		
		CClientDC dc(this);
		CString str;

		str.Format("sid = %ld\r\n", this->m_dwID);
		
		str.Append("sname = ");
		str.Append((char*)szName);
		str.Append("\r\n");

		str.Append("Password = ");
		str.Append((char*)szPasswd);

		TeacherShow(str);

		dc.DrawText(str, CRect(10,30, 400, 500), DT_LEFT );		
	}
}

void CCourseChoseView::TeacherShow(CString& str)
{
        SQLRETURN	retCode;
	DWORD		dwError	= 0;
	SQLINTEGER	dwSid = 0;
	
	SQLCHAR		szName[10]	= "\0";
	SQLCHAR		szTime[20]	= "\0";

	SQLINTEGER	dwFen		= 0;

	int		nResult		= 0;
	char		szSQL[100]	= "\0";
	char		szTemp[20]	= "\0";

	str.Append("\r\n教课信息");

	sprintf(szSQL, "select cid, cname, cfen, ctime from course where tid = %ld;", this->m_dwID);

	retCode = SQLAllocHandle(SQL_HANDLE_STMT, MysqlOp.hdbc, &MysqlOp.hstmt);
	if ( (retCode != SQL_SUCCESS) && (retCode != SQL_SUCCESS_WITH_INFO) )
	{
		dwError = GetLastError();

		cout << "SQLAllocHandle error = " << dwError << endl;

		return;
	}

	retCode = SQLExecDirect(MysqlOp.hstmt, (SQLCHAR*)szSQL, SQL_NTS);
	if ( (retCode != SQL_SUCCESS) && (retCode != SQL_SUCCESS_WITH_INFO) )
	{
		dwError = GetLastError();

		cout << "SQLExecDirectA error = " << dwError << endl;

		MessageBox("数据库操作失败");

		return;
	}

	while (true)
	{
		retCode = SQLFetch(MysqlOp.hstmt);
		if (retCode == SQL_ERROR)
		{
			MessageBox("查询出错！");

			return;
		}	
		else if (retCode == SQL_NO_DATA)
		{	
			break;
		}
		else
		{		
			SQLGetData(MysqlOp.hstmt, 1, SQL_INTEGER, &dwSid, 8, (SQLINTEGER*)&nResult);
			SQLGetData(MysqlOp.hstmt, 2, SQL_CHAR, szName, 10, (SQLINTEGER*)&nResult);
			SQLGetData(MysqlOp.hstmt, 3, SQL_INTEGER, &dwFen, 8, (SQLINTEGER*)&nResult);
			SQLGetData(MysqlOp.hstmt, 4, SQL_CHAR, szTime, 16, (SQLINTEGER*)&nResult);

			sprintf(szTemp, "sid = %ld\r\n", dwSid);
			str.Append(szTemp);
		
			str.Append("cname = ");
			str.Append((char*)szName);
			str.Append("\r\n");

			sprintf(szTemp, "cfen = %ld\r\n", dwFen);
			str.Append(szTemp);

			str.Append("ctime = ");
			str.Append((char*)szTime);
			str.Append("\r\n");

			str.Append("-------------------------------------\r\n\r\n");
		}

	}
}

//学生操作
void CCourseChoseView::OnCourseChose()
{
	// TODO: Add your command handler code here

	CStudentDialog mystuDialog;

	mystuDialog.DoModal();
}

void CCourseChoseView::OnShowMe()
{
	// TODO: Add your command handler code here
	SQLRETURN	retCode;
	DWORD		dwError	= 0;
	SQLINTEGER	dwSid = 0;
	
	SQLCHAR		szName[10]	= "\0";
	SQLCHAR		szClass[10]	= "\0";
	SQLCHAR		szPasswd[20]	= "\0";

	int		nResult		= 0;
	char		szSQL[100]	= "\0";

	sprintf(szSQL, "select sid, sname, sclass, password from student where sid = %ld;", this->m_dwID);

	retCode = SQLAllocHandle(SQL_HANDLE_STMT, MysqlOp.hdbc, &MysqlOp.hstmt);
	if ( (retCode != SQL_SUCCESS) && (retCode != SQL_SUCCESS_WITH_INFO) )
	{
		dwError = GetLastError();

		cout << "SQLAllocHandle error = " << dwError << endl;

		return;
	}

	retCode = SQLExecDirect(MysqlOp.hstmt, (SQLCHAR*)szSQL, SQL_NTS);
	if ( (retCode != SQL_SUCCESS) && (retCode != SQL_SUCCESS_WITH_INFO) )
	{
		dwError = GetLastError();

		cout << "SQLExecDirectA error = " << dwError << endl;

		MessageBox("数据库操作失败");

		return;
	}

	retCode = SQLFetch(MysqlOp.hstmt);
	if (retCode == SQL_ERROR)
	{
		MessageBox("查询出错！");

		return;
	}	
	else if (retCode == SQL_NO_DATA)
	{	

	}
	else
	{		
		SQLGetData(MysqlOp.hstmt, 1, SQL_INTEGER, &dwSid, 8, (SQLINTEGER*)&nResult);
		SQLGetData(MysqlOp.hstmt, 2, SQL_CHAR, szName, 10, (SQLINTEGER*)&nResult);
		SQLGetData(MysqlOp.hstmt, 3, SQL_CHAR, szClass, 10, (SQLINTEGER*)&nResult);
		SQLGetData(MysqlOp.hstmt, 4, SQL_CHAR, szPasswd, 16, (SQLINTEGER*)&nResult);

		this->Invalidate();
		this->UpdateWindow();
		
		CClientDC dc(this);
		CString str;

		str.Format("sid = %ld\r\n", this->m_dwID);
		
		str.Append("sname = ");
		str.Append((char*)szName);
		str.Append("\r\n");

		str.Append("sclass = ");
		str.Append((char*)szClass);
		str.Append("\r\n");

		str.Append("Password = ");
		str.Append((char*)szPasswd);

		StudentShow(str);

		dc.DrawText(str, CRect(10,30, 400, 500), DT_LEFT );		
	}
}

void CCourseChoseView::StudentShow(CString& str)
{
	SQLRETURN	retCode;
	DWORD		dwError	= 0;
	
	SQLINTEGER	dwCid = 0;
	SQLINTEGER	dwTid = 0;		

	int		nResult		= 0;
	char		szSQL[100]	= "\0";
	char		szTemp[20]	= "\0";

	str.Append("\r\n选课信息");

	sprintf(szSQL, "select cid, tid from C_student where sid = %ld;", this->m_dwID);

	retCode = SQLAllocHandle(SQL_HANDLE_STMT, MysqlOp.hdbc, &MysqlOp.hstmt);
	if ( (retCode != SQL_SUCCESS) && (retCode != SQL_SUCCESS_WITH_INFO) )
	{
		dwError = GetLastError();

		cout << "SQLAllocHandle error = " << dwError << endl;

		return;
	}

	retCode = SQLExecDirect(MysqlOp.hstmt, (SQLCHAR*)szSQL, SQL_NTS);
	if ( (retCode != SQL_SUCCESS) && (retCode != SQL_SUCCESS_WITH_INFO) )
	{
		dwError = GetLastError();

		cout << "SQLExecDirectA error = " << dwError << endl;

		MessageBox("数据库操作失败");

		return;
	}

	while (true)
	{
		retCode = SQLFetch(MysqlOp.hstmt);
		if (retCode == SQL_ERROR)
		{
			MessageBox("查询出错！");

			return;
		}	
		else if (retCode == SQL_NO_DATA)
		{	
			break;
		}
		else
		{		
			SQLGetData(MysqlOp.hstmt, 1, SQL_INTEGER, &dwCid, 8, (SQLINTEGER*)&nResult);
			SQLGetData(MysqlOp.hstmt, 1, SQL_INTEGER, &dwTid, 8, (SQLINTEGER*)&nResult);
			
			sprintf(szTemp, "cid = %ld\r\n", dwCid);
			str.Append(szTemp);
		
			sprintf(szTemp, "tid = %ld\r\n", dwTid);
			str.Append(szTemp);

			str.Append("-------------------------------------\r\n\r\n");
		}

	}

}
void CCourseChoseView::OnAllCourse()
{
	// TODO: Add your command handler code here
	SQLRETURN	retCode;
	DWORD		dwError	= 0;
	SQLINTEGER	dwSid = 0;
	SQLINTEGER	dwTid = 0;
	
	SQLCHAR		szName[10]	= "\0";
	SQLCHAR		szTime[20]	= "\0";

	SQLINTEGER	dwFen		= 0;

	int		nResult		= 0;
	char		szSQL[100]	= "\0";
	char		szTemp[20]	= "\0";

	CString	str;

	str.Append("\r\n所有信息");

	sprintf(szSQL, "select cid, cname, cfen, ctime, tid from course;", this->m_dwID);

	retCode = SQLAllocHandle(SQL_HANDLE_STMT, MysqlOp.hdbc, &MysqlOp.hstmt);
	if ( (retCode != SQL_SUCCESS) && (retCode != SQL_SUCCESS_WITH_INFO) )
	{
		dwError = GetLastError();

		cout << "SQLAllocHandle error = " << dwError << endl;

		return;
	}

	retCode = SQLExecDirect(MysqlOp.hstmt, (SQLCHAR*)szSQL, SQL_NTS);
	if ( (retCode != SQL_SUCCESS) && (retCode != SQL_SUCCESS_WITH_INFO) )
	{
		dwError = GetLastError();

		cout << "SQLExecDirectA error = " << dwError << endl;

		MessageBox("数据库操作失败");

		return;
	}

	while (true)
	{
		retCode = SQLFetch(MysqlOp.hstmt);
		if (retCode == SQL_ERROR)
		{
			MessageBox("查询出错！");

			return;
		}	
		else if (retCode == SQL_NO_DATA)
		{	
			break;
		}
		else
		{		
			SQLGetData(MysqlOp.hstmt, 1, SQL_INTEGER, &dwSid, 8, (SQLINTEGER*)&nResult);
			SQLGetData(MysqlOp.hstmt, 2, SQL_CHAR, szName, 10, (SQLINTEGER*)&nResult);
			SQLGetData(MysqlOp.hstmt, 3, SQL_INTEGER, &dwFen, 8, (SQLINTEGER*)&nResult);
			SQLGetData(MysqlOp.hstmt, 4, SQL_CHAR, szTime, 16, (SQLINTEGER*)&nResult);
			SQLGetData(MysqlOp.hstmt, 5, SQL_INTEGER, &dwTid, 8, (SQLINTEGER*)&nResult);

			sprintf(szTemp, "sid = %ld\r\n", dwSid);
			str.Append(szTemp);
		
			str.Append("cname = ");
			str.Append((char*)szName);
			str.Append("\r\n");

			sprintf(szTemp, "cfen = %ld\r\n", dwFen);
			str.Append(szTemp);

			str.Append("ctime = ");
			str.Append((char*)szTime);
			str.Append("\r\n");

			sprintf(szTemp, "tid = %ld\r\n", dwTid);
			str.Append(szTemp);

			str.Append("-------------------------------------\r\n\r\n");
		}
	}

	this->Invalidate();
	this->UpdateWindow();

	CClientDC dc(this);
	
	dc.DrawText(str, CRect(10,30, 400, 500), DT_LEFT );	
}