VC之ADO访问类

Provider=SQLOLEDB.1 ------打开数据库用oledb的方式连接Persist Security Info ----是否保存安全信息User ID-------------------用户名PassWord------------------密码Initial Catalog-----------数据库的名称或者数据库ip或者目录Data Source---------------数据源

ADOConn.h

// ADOConn.h: interface for the ADOConn class.////////////////////////////////////////////////////////////////////////#if !defined(AFX_ADOCONN_H__882A9D58_0245_4730_BD10_F7EF1A902DA7__INCLUDED_)#define AFX_ADOCONN_H__882A9D58_0245_4730_BD10_F7EF1A902DA7__INCLUDED_#if _MSC_VER > 1000#pragma once#endif // _MSC_VER > 1000class ADOConn  {public:void ExitConnect();_RecordsetPtr& GetRecordSet(const _bstr_t& bstrSQL);void OnInitADOConn();BOOL ExecuteSQL(const _bstr_t& bstrSQL);_RecordsetPtr m_pRecordset;_ConnectionPtr m_pConnection;ADOConn();virtual ~ADOConn();};#endif // !defined(AFX_ADOCONN_H__882A9D58_0245_4730_BD10_F7EF1A902DA7__INCLUDED_) 

ADOConn.cpp

// ADOConn.cpp: implementation of the ADOConn class.////////////////////////////////////////////////////////////////////////#include "stdafx.h"#include "Project.h"#include "ADOConn.h"#ifdef _DEBUG#undef THIS_FILEstatic char THIS_FILE[]=__FILE__;#define new DEBUG_NEW#endif//////////////////////////////////////////////////////////////////////// Construction/Destruction//////////////////////////////////////////////////////////////////////ADOConn::ADOConn(){}ADOConn::~ADOConn(){}//连接数据库void ADOConn::OnInitADOConn(){::CoInitialize(NULL);try{m_pConnection.CreateInstance("ADODB.Connection");//        strname.Format("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=%s;Data Source=.",strsjk);  _bstr_t strConnect = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=school;User ID=sa;Data Source=.";// m_pConnection->Open(strConnect, "sa", "", adModeUnknown);m_pConnection->Open(strConnect, "", "", adModeUnknown);}catch(_com_error e){AfxMessageBox(e.Description());}}//执行SQL语句, Insert Update BOOL ADOConn::ExecuteSQL(const _bstr_t& bstrSQL){try{if (m_pConnection == NULL){OnInitADOConn();}m_pConnection->Execute(bstrSQL, NULL, adCmdText);return true;}catch(_com_error e){AfxMessageBox(e.Description());return false;}}//执行查询_RecordsetPtr& ADOConn::GetRecordSet(const _bstr_t& bstrSQL){try{if (m_pConnection == NULL){OnInitADOConn();}m_pRecordset.CreateInstance(__uuidof(Recordset));m_pRecordset->Open(bstrSQL, m_pConnection.GetInterfacePtr(), adOpenDynamic,adLockOptimistic,adCmdText);}catch(_com_error e){AfxMessageBox(e.Description());}return m_pRecordset;}//断开连接void ADOConn::ExitConnect(){if (m_pRecordset != NULL){m_pRecordset->Close();}m_pConnection->Close();::CoUninitialize();}