testview.cpp

跟数据库密切相关的各种典型操作VC例程源代码

// TestView.cpp : CTestView 类的实现
//

#include "stdafx.h"
#include "Test.h"

#include "TestDoc.h"
#include "TestView.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#endif


// CTestView

IMPLEMENT_DYNCREATE(CTestView, CView)

BEGIN_MESSAGE_MAP(CTestView, 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_WM_RBUTTONDOWN()
END_MESSAGE_MAP()

// CTestView 构造/销毁

CTestView::CTestView()
{
	// TODO: 在此处添加构造代码

}

CTestView::~CTestView()
{
}

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

	return CView::PreCreateWindow(cs);
}

// CTestView 绘制

void CTestView::OnDraw(CDC* /*pDC*/)
{
	CTestDoc* pDoc = GetDocument();
	ASSERT_VALID(pDoc);

	// TODO: 在此处为本机数据添加绘制代码
}


// CTestView 打印

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

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

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


// CTestView 诊断

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

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

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


// CTestView 消息处理程序
#using <mscorlib.dll>
#using <System.dll>
#using <System.Data.dll>
using namespace System;
using namespace System::Data;
using namespace System::Data::OleDb;
void CTestView::OnRButtonDown(UINT nFlags, CPoint point)
{
		String* strSQL="SELECT * FROM 雇员";
		OleDbConnection* pConnection;	
		OleDbCommand* pCommand;			
		OleDbDataReader* pDataReader;	
		String *StrResult;
		try
		{
		  pConnection = new OleDbConnection();
		  pConnection->set_ConnectionString(S"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MyDBAccess.mdb;Persist Security Info=False");
		  pConnection->Open();
		  pCommand = new OleDbCommand(strSQL, pConnection);
		  pDataReader = pCommand->ExecuteReader();
		  StrResult = "";
		  pDataReader->Read();
		  do
		  {
			StrResult = String::Concat(StrResult,"\n");
			StrResult = String::Concat(StrResult,
            Convert::ToString(pDataReader->GetInt32(0),10));
			StrResult = String::Concat(StrResult,"    ");
			StrResult = String::Concat(StrResult,pDataReader->GetString(1));
			StrResult = String::Concat(StrResult,"    ");
			StrResult = String::Concat(StrResult,pDataReader->GetString(2));
			StrResult = String::Concat(StrResult,"    ");
			StrResult = String::Concat(StrResult,pDataReader->GetString(3));
			StrResult = String::Concat(StrResult,"    ");
			StrResult = String::Concat(StrResult,pDataReader->GetString(4));
			StrResult = String::Concat(StrResult,"    ");
			StrResult = String::Concat(StrResult,pDataReader->GetString(5));
			StrResult = String::Concat(StrResult,"    ");
			StrResult = String::Concat(StrResult,pDataReader->GetString(6));
			StrResult = String::Concat(StrResult,"    ");
			StrResult = String::Concat(StrResult,pDataReader->GetString(7));
			StrResult = String::Concat(StrResult,"    ");
			StrResult = String::Concat(StrResult,pDataReader->GetString(8));
			StrResult = String::Concat(StrResult,"    ");
			StrResult = String::Concat(StrResult,pDataReader->GetString(9));
			StrResult = String::Concat(StrResult,"    ");
			StrResult = String::Concat(StrResult,pDataReader->GetString(10));
			StrResult = String::Concat(StrResult,"    ");
			StrResult = String::Concat(StrResult,pDataReader->GetString(11));
			StrResult = String::Concat(StrResult,"    ");
			StrResult = String::Concat(StrResult,pDataReader->GetString(12));
			StrResult = String::Concat(StrResult,"    ");
			StrResult = String::Concat(StrResult,pDataReader->GetString(13));
			StrResult = String::Concat(StrResult,"    ");
			StrResult = String::Concat(StrResult,pDataReader->GetString(14));			  }while(pDataReader->Read());		  
		  pDataReader->Close();
		  pConnection->Close();
		}
	    catch(Exception* e)
	   {
			StrResult = e->Message;
			if (pDataReader && !pDataReader->IsClosed) 
				pDataReader->Close();
			if (pConnection->State == ConnectionState::Open) 
				pConnection->Close();
		}
	   CString StrInfo=StrResult;
	   MessageBox(StrInfo,"查询数据库结果",MB_OK);
	CView::OnRButtonDown(nFlags, point);
}