access读取写入mysql数据库_c语言读写access数据库

以前的程序中用到的，记录下来做个备份。

1、import com库

#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename ("EOF", "adoEOF")

2、初始化调用接口

_ConnectionPtrpConnection;

_RecordsetPtrm_pRecordset;

CoInitialize(NULL);

pConnection.CreateInstance(__uuidof(Connection));

try{

pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=数据库绝对地址","","",adModeUnknown);

}

catch(_com_error e){

CoUninitialize();

return FALSE;

}

m_pRecordset.CreateInstance(__uuidof(Recordset));

3、执行sql语句

m_pRecordset->Open("sql语句",

pConnection.GetInterfacePtr(),

adOpenDynamic, //或adOpenForwardOnly

adLockOptimistic,

adCmdText);

4、读取数据

if(!m_pRecordset->BOF){

m_pRecordset->MoveFirst();

while(!m_pRecordset->adoEOF)

{

//读取int

_variant_t var =m_pRecordset->GetCollect("字段名");

int vi=(long)var;

//读取字符串

_variant_t var =m_pRecordset->GetCollect("字段名");

_bstr_t varbstr=_bstr_t(var);

char *vs=(LPTSTR)varbstr;

m_pRecordset->MoveNext();

}

｝

5、修改和插入数据

m_pRecordset->PutCollect("字段名",_variant_t(值));

//...

m_pRecordset->Update();

如果插入新的一行则先调用：

m_pRecordset->AddNew();

6、结束本次sql

m_pRecordset->Close();

7、释放接口

if (pConnection)

if (pConnection->State == adStateOpen)

pConnection->Close();

pConnection= NULL;

CoUninitialize();