ADO比较好！
创建一个类！叫 ADOConn
ADOConn.cpp
#include "stdafx.h"
#include "Management.h"
#include "ADOConn.h"
#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif
//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////
ADOConn::ADOConn()
{
}
ADOConn::~ADOConn()
{
}
void ADOConn::OnInitADOConn()
{
::CoInitialize(NULL);
try
{
m_pCon.CreateInstance("ADODB.Connection");
m_pCon->ConnectionTimeout=3;
m_pCon->Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=lyl;Data Source=(local)","","",NULL);
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
}
}
void ADOConn::ExitConn()
{
if(m_pRs!=NULL)
m_pRs->Close();
m_pRs->Close();
::CoUninitialize();
}
_RecordsetPtr& ADOConn::GetRecordSet(_bstr_t bstrSQL)
{
try
{
if(m_pCon==NULL)
OnInitADOConn();
m_pRs.CreateInstance("ADODB.Recordset");
m_pRs->Open(bstrSQL,m_pCon.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
}
return m_pRs;
}
BOOL ADOConn::ExecuteSQL(_bstr_t bstrSQL)
{
try
{
if(m_pCon==NULL)
OnInitADOConn();
m_pCon->Execute(bstrSQL,NULL,adCmdText);
return true;
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
return false;
}
}
ADOConn.h
// ADOConn.h: interface for the ADOConn class.
//
//////////////////////////////////////////////////////////////////////
#if !defined(AFX_ADOCONN_H__2019F5C5_4C78_4579_AB77_543AE8C2A2FF__INCLUDED_)
#define AFX_ADOCONN_H__2019F5C5_4C78_4579_AB77_543AE8C2A2FF__INCLUDED_
#import "C:\Program Files\Common Files\System\ado\msado15.dll"no_namespace rename("EOF","adoEOF")
#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
class ADOConn
{
public:
BOOL ExecuteSQL(_bstr_t bstrSQL);
_RecordsetPtr& GetRecordSet(_bstr_t bstrSQL);
void ExitConn();
void OnInitADOConn();
_ConnectionPtr m_pCon;
_RecordsetPtr m_pRs;
// _RecordsetPtr& GetRecordSet(_bstr_t bstrSQL);
ADOConn();
virtual ~ADOConn();
};
#endif // !defined(AFX_ADOCONN_H__2019F5C5_4C78_4579_AB77_543AE8C2A2FF__INCLUDED_)
