vc链接数据库和操作数据库的函数清单

雨点打透心脏的1/2处 2022-04-10 01:27 213阅读 0赞

vc链接数据库和操作数据库的函数清单

这是我写的一个类，类名是ADOConn.cpp和ADOConn.h，主要作用就是把vc链接数据库和操作数据库的函数清单写在了这里面。把这个类加进vc中是可以直接运行的，你直接调用就行了。改一些路径，他可以对access，SqlServer等数据库进行很好的操作。

第一个是ADOConn.cpp

![InBlock.gif][] // ADOConn.cpp: implementation of the ADOConn class.   
///   
![InBlock.gif][]  
![InBlock.gif][]\#include "stdafx.h"  
![InBlock.gif][]\#include "myshoujiDlg.h" //主函数   
![InBlock.gif][]\#include "ADOConn.h"  
![InBlock.gif][]  
![InBlock.gif][]\#ifdef \_DEBUG  
![InBlock.gif][]\#undef THIS\_FILE  
![InBlock.gif][] static char THIS\_FILE\[\]=\_\_FILE\_\_;  
![InBlock.gif][]\#define new DEBUG\_NEW  
![InBlock.gif][]\#endif  
///   
![InBlock.gif][] // Construction/Destruction   
  
![InBlock.gif][]  
![InBlock.gif][]ADOConn::ADOConn()  
![InBlock.gif][]\{  
![InBlock.gif][]  
![InBlock.gif][]\}  
![InBlock.gif][]  
![InBlock.gif][]ADOConn::~ADOConn()  
![InBlock.gif][]\{  
![InBlock.gif][]  
![InBlock.gif][]\}  
![InBlock.gif][]  
![InBlock.gif][] void ADOConn::OnInitADOConn() //以调用access为例，其实调用SqlServer等也是一样的   
![InBlock.gif][]\{  
![InBlock.gif][] ::CoInitialize(NULL); //初始化COM组件   
![InBlock.gif][] try  
![InBlock.gif][] \{  
![InBlock.gif][] m\_pConnection.CreateInstance( "ADODB.Connection");  
![InBlock.gif][] \_bstr\_t strConnect= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=shouji.mdb"; //链接数据库，这里是shouji数据库，可以根据具体情况改   
![InBlock.gif][] m\_pConnection->Open(strConnect, "","",adModeUnknown);  
![InBlock.gif][] \}  
![InBlock.gif][] catch(\_com\_error e)  
![InBlock.gif][] \{  
![InBlock.gif][] AfxMessageBox(e.Description());  
![InBlock.gif][] \}  
![InBlock.gif][]\}  
![InBlock.gif][]  
![InBlock.gif][]\_RecordsetPtr& ADOConn::GetRecordSet(\_bstr\_t bstrSQL)  
![InBlock.gif][]\{  
![InBlock.gif][] try  
![InBlock.gif][] \{  
![InBlock.gif][] if(m\_pConnection==NULL)  
![InBlock.gif][] OnInitADOConn();  
![InBlock.gif][] m\_pRecordset.CreateInstance(\_\_uuidof(Recordset));  
![InBlock.gif][] m\_pRecordset->Open(bstrSQL,m\_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);  
![InBlock.gif][] \}  
![InBlock.gif][] catch(\_com\_error e) //捕捉异常   
![InBlock.gif][] \{  
![InBlock.gif][] e.Description();  
![InBlock.gif][] \}  
![InBlock.gif][] return m\_pRecordset;  
![InBlock.gif][]\}  
![InBlock.gif][]  
![InBlock.gif][]BOOL ADOConn::ExecuteSQL(\_bstr\_t bstrSQL) //再打开数据库后，执行Sql语句   
![InBlock.gif][]\{  
![InBlock.gif][] \_variant\_t RecordsAffected;  
![InBlock.gif][] try  
![InBlock.gif][] \{  
![InBlock.gif][] if(m\_pConnection==NULL)  
![InBlock.gif][] OnInitADOConn();  
![InBlock.gif][] m\_pConnection->Execute(bstrSQL,NULL,adCmdText);  
![InBlock.gif][] return true;  
![InBlock.gif][] \}  
![InBlock.gif][] catch(\_com\_error e)  
![InBlock.gif][] \{  
![InBlock.gif][] e.Description();  
![InBlock.gif][] return false;  
![InBlock.gif][] \}  
![InBlock.gif][]\}  
![InBlock.gif][]  
![InBlock.gif][] void ADOConn::ExitConnect() //退出链接   
![InBlock.gif][]\{  
![InBlock.gif][] if(m\_pRecordset!=NULL)  
![InBlock.gif][] m\_pRecordset->Close();  
![InBlock.gif][] m\_pConnection->Close();  
![InBlock.gif][] ::CoUninitialize();  
![InBlock.gif][]\}

第二个是ADOConn.h

![InBlock.gif][] // ADOConn.h: interface for the ADOConn class.   
  
![InBlock.gif][]  
![InBlock.gif][]\# if !defined(AFX\_ADOCONN\_H\_\_A2B6E8CE\_2220\_4830\_95F8\_2911D1EAC453\_\_INCLUDED\_)  
![InBlock.gif][]\#define AFX\_ADOCONN\_H\_\_A2B6E8CE\_2220\_4830\_95F8\_2911D1EAC453\_\_INCLUDED\_  
![InBlock.gif][]\#import "C:\\program files\\common files\\system\\ado\\msado15.dll" no\_namespace rename( "EOF", "adoEOF")  
![InBlock.gif][]  
![InBlock.gif][]\# if \_MSC\_VER > 1000  
![InBlock.gif][]\#pragma once  
![InBlock.gif][]\#endif // \_MSC\_VER > 1000   
![InBlock.gif][]  
![InBlock.gif][] class ADOConn  
![InBlock.gif][]\{  
![InBlock.gif][] public:  
![InBlock.gif][] \_ConnectionPtr m\_pConnection;  
![InBlock.gif][] \_RecordsetPtr m\_pRecordset;  
![InBlock.gif][] public:  
![InBlock.gif][] ADOConn();  
![InBlock.gif][] virtual ~ADOConn();  
![InBlock.gif][]  
![InBlock.gif][] void OnInitADOConn();  
![InBlock.gif][] \_RecordsetPtr&GetRecordSet(\_bstr\_t bstrSQL);  
![InBlock.gif][] BOOL ExecuteSQL(\_bstr\_t bstrSQL);  
![InBlock.gif][] void ExitConnect();  
![InBlock.gif][]  
![InBlock.gif][]\};  
![InBlock.gif][]  
![InBlock.gif][]\#endif // !defined(AFX\_ADOCONN\_H\_\_A2B6E8CE\_2220\_4830\_95F8\_2911D1EAC453\_\_INCLUDED\_)

希望对你有所帮助。

[InBlock.gif]: /images/20220404/ae74f6e4fb3f4051a38068500efde003.png