用VC++操作ACESS数据库(创建数据库、建立新表、连接、增删查改)

php中文网
发布: 2016-06-07 14:59:56
原创
1359人浏览过

首先在 StdAfx.h 中包含如下头文件 #import "C:Program FilesCommon Filessystemdomsadox.dll" // 创建数据库必用 #import"C:Program FilesCommon FilesSystemADOmsado15.dll" named_guids rename("EOF","adoEOF"), rename("BOF","adoBOF") msado

首先在stdafx.h中包含如下头文件
#import "c:program filescommon filessystemdomsadox.dll"  // 创建数据库必用
#import"c:program filescommon filessystemdomsado15.dll" named_guids rename("eof","adoeof"), rename("bof","adobof")

msadox.dll msado15.dll根据自己电脑上的位置进行加载,备注:两个#import位置不能调换,调换链接出错

1.      创建数据库
// 创建数据库
void CTestDlg::OnCreateAdoMdb() 
{
       HRESULT hr = S_OK;  CString filename="c:\test.mdb";
       //Set ActiveConnection of Catalog to this string 
       CString strcnn(_T("Provider=Microsoft.JET.OLEDB.4.0;Data source="+filename));
       try
       {
             ADOX::_CatalogPtr m_pCatalog = NULL;
              hr = m_pCatalog.CreateInstance(__uuidof (ADOX::Catalog));
              if(FAILED(hr))
              {
                    _com_issue_error(hr);
              }
              else
              {
                     m_pCatalog->Create(_bstr_t(strcnn));
                     //Create MDB
              }
              AfxMessageBox(_T("ok"));
       }
       catch(_com_error &e)
       {
              // Notify the user of errors if any.
              AfxMessageBox(_T("error"));
       }
}

2、  打开数据库
BOOL CTestApp::InitInstance()
{
       AfxEnableControlContainer();
       CoInitialize(NULL);
         .......
       
       return TRUE;
}

3.  创建新表
void CTestDlg::OnMainCreate() 
{
       try
       {
             _ConnectionPtr pConn;pConn.CreateInstance(__uuidof(Connection));
             _RecordsetPtr  pRs;  pRs.CreateInstance(__uuidof(Recordset));
             _CommandPtr    Cmd;  Cmd.CreateInstance( __uuidof( Command ) );
             try                 
              {     
                     CString dd;  CString file="c:\NXYH.mdb";
                     //CString dd;  CString file="NXYH.mdb";
                     dd.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s",file);
                    pConn->Open((_bstr_t)dd,"","",adModeUnknown); // 打开本地Access库Demo.mdb
              }
             catch(_com_error e)
              {
                    AfxMessageBox("数据库连接失败,确认数据库NXYH.mdb是否在当前路径下!");
              } 
              // 如果本表不存在时,可以创建本表,存在时无法创建.
              try
              {
                    _variant_t RecordsAffected;  CString command1,command2,myfilename="yours";
                     command1.Format("CREATE TABLE %s(ID INTEGER,username TEXT(5),old INTEGER,birthday

立即学习C++免费学习笔记(深入)”;

DATETIME)",myfilename);
                    pConn->Execute(_bstr_t(command1),&RecordsAffected,adCmdText);
                     command2.Format("INSERT INTO %s(ID,username,old,birthday) VALUES

(1,'washton',26,'1970/1/1')",myfilename);
                     pConn->Execute(_bstr_t(command2),&RecordsAffected,adCmdText);
                    AfxMessageBox("created.");
              }
             catch(...)
              {
                   AfxMessageBox("table  have already created.");
             }
       }
       catch(...)
       {
     }
}

4.  删除记录

void CTestDlg::OnMainDel() 
{
      try
       {
             _ConnectionPtr pConn;
             _RecordsetPtr  pRs;  
             pConn.CreateInstance(__uuidof(Connection));
             pRs.CreateInstance(__uuidof(Recordset));
             try                 
              {     
                     CString dd;  CString file="c:\NXYH.mdb";
                     dd.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s",file);
                    pConn->Open((_bstr_t)dd,"","",adModeUnknown); // 打开本地Access库Demo.mdb
              }
             catch(_com_error e)
              {
                    AfxMessageBox("数据库连接失败,确认数据库NXYH.mdb是否在当前路径下!");
              } 
             try
              {
                    pRs->Open("SELECT * FROM coordinate", // 查询DemoTable表中所有字段
                           pConn.GetInterfacePtr(),      // 获取库接库的IDispatch指针
                           adOpenDynamic,
                           adLockOptimistic,
                           adCmdText );
              }
             catch(_com_error *e)
              {
                    AfxMessageBox(e->ErrorMessage());
              }
              _variant_t var;
             while (!pRs->adoEOF)   
              {    
                    pRs->MoveFirst();
                     pRs->Delete(adAffectCurrent); //删除当前记录
                     pRs->MoveNext();   
              }     
             MessageBox("delete--over");  pRs->Update(); 
             pRs->Close(); pConn->Close(); pRs=NULL; pConn=NULL;
       }   
      catch (_com_error &e )  
    {    
             printf("Error: ");   
             printf("Code = %08lx ", e.Error());    
             printf("Meaning = %s ", e.ErrorMessage());  
             printf("Source = %s ", (LPCSTR) e.Source());    
      }
}
 
5.  增加记录

void CTestDlg::OnMainAdd() 
{
      try
       {
             _ConnectionPtr pConn;
             _RecordsetPtr  pRs;  
             pConn.CreateInstance(__uuidof(Connection));
             pRs.CreateInstance(__uuidof(Recordset));
             try                 
              {     
                    // 打开本地Access库Demo.mdb
                    pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=NXYH.mdb","","",adModeUnknown);
              }
             catch(_com_error e)
              {
                    AfxMessageBox("数据库连接失败,确认数据库NXYH.mdb是否在当前路径下!");
              } 
             try
              {
                    pRs->Open("SELECT * FROM coordinate", // 查询DemoTable表中所有字段
                           pConn.GetInterfacePtr(),      // 获取库接库的IDispatch指针
                           adOpenDynamic,
                           adLockOptimistic,
                           adCmdText );
              }
             catch(_com_error *e)
              {
                    AfxMessageBox(e->ErrorMessage());
              }
               // 增加新元素
              XX=123.345; YY=222.434; HH=1445;
              for(int i=0;i              {
                     m_Name.Format("D%d",i+1);
                    pRs->AddNew();
                    //pRs->PutCollect("ID",_variant_t((long)(i+10)));
                    pRs->PutCollect("Name", _variant_t(m_Name));
                    pRs->PutCollect("X",_variant_t((double)(XX)));
                    pRs->PutCollect("Y",_variant_t((double)(YY)));
                    pRs->PutCollect("H",_variant_t((double)(HH)));
              }
             pRs->Update();  MessageBox("add--over");
             pRs->Close(); pConn->Close(); pRs=NULL; pConn=NULL;
       }   
      catch (_com_error &e )  
    {    
             printf("Error: ");   
             printf("Code = %08lx ", e.Error());    
             printf("Meaning = %s ", e.ErrorMessage());  
             printf("Source = %s ", (LPCSTR) e.Source());    
       }
}

6.  修改记录
void CTestDlg::OnMainChange() 
{
      try
       {
             _ConnectionPtr pConn;
             _RecordsetPtr  pRs;  
             pConn.CreateInstance(__uuidof(Connection));
             pRs.CreateInstance(__uuidof(Recordset));
             try                 
              {     
                    // 打开本地Access库Demo.mdb
                    pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=NXYH.mdb","","",adModeUnknown);
              }
             catch(_com_error e)
              {
                    AfxMessageBox("数据库连接失败,确认数据库NXYH.mdb是否在当前路径下!");
              } 
             try
              {
                    pRs->Open("SELECT * FROM coordinate", // 查询DemoTable表中所有字段
                           pConn.GetInterfacePtr(),      // 获取库接库的IDispatch指针
                           adOpenDynamic,
                           adLockOptimistic,
                           adCmdText );
              }
             catch(_com_error *e)
              {
                    AfxMessageBox(e->ErrorMessage());
              }
             // 修改数据
             _variant_t var;
             while (!pRs->adoEOF)   
             {    
                    //var = pRs->GetCollect("Name");
                     //if(var.vt != VT_NULL) m_Name = (LPCSTR)_bstr_t(var);
                    //MessageBox(m_Name); //m_Name=m_Name.Left(2)+"*";
                    //m_Name+="main";
                     var = pRs->GetCollect("X"); 
                     if(var.vt != VT_NULL) m_X = (LPCSTR)_bstr_t(var);
                    double XX=100.789; //XX+=atof(m_X);
                    pRs->PutCollect("X",_variant_t((double)(XX)));
                   //pRs->PutCollect("Name", _variant_t(m_Name));
                    pRs->MoveNext();   
              }     
             MessageBox("change--over");
              pRs->Update(); 
             pRs->Close(); pConn->Close(); pRs=NULL; pConn=NULL;
       }   
      catch (_com_error &e )  
    {    
             printf("Error: ");   
             printf("Code = %08lx ", e.Error());    
             printf("Meaning = %s ", e.ErrorMessage());  
             printf("Source = %s ", (LPCSTR) e.Source());    
      }
}

 

c++速学教程(入门到精通)
c++速学教程(入门到精通)

c++怎么学习?c++怎么入门?c++在哪学?c++怎么学才快?不用担心,这里为大家提供了c++速学教程(入门到精通),有需要的小伙伴保存下载就能学习啦!

下载
来源:php中文网
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
最新问题
开源免费商场系统广告
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
关于我们 免责申明 意见反馈 讲师合作 广告合作 最新更新
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送
PHP中文网APP
随时随地碎片化学习
PHP中文网抖音号
发现有趣的

Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号