Category

Development Platform
Home > SourceCode/Document > Windows Develop > ADO-ODBC > View Code
ADOConn.cpp
Package: salarysystem.rar　[view]
Upload User: xz12345
Upload Date: 2007-09-12
Package Size: 7437k
Code Size: 2k
Category:

ADO-ODBC

Development Platform:

Visual C++

ADOConn.cpp：Code Content
  1. // ADOConn.cpp: implementation of the ADOConn class.
  2. //
  3. //////////////////////////////////////////////////////////////////////
  5. #include "stdafx.h"
  6. #include "工资.h"
  9. #ifdef _DEBUG
  10. #undef THIS_FILE
  11. static char THIS_FILE[]=__FILE__;
  12. #define new DEBUG_NEW
  13. #endif
  15. //////////////////////////////////////////////////////////////////////
  16. // Construction/Destruction
  17. //////////////////////////////////////////////////////////////////////
  19. ADOConn::ADOConn()
  20. {
  22. }
  24. ADOConn::~ADOConn()
  25. {
  27. }
  29. void ADOConn::OnInitADOConn()
  30. {
  31. //初始化OLE/COM库环境
  32. //public:
  33. ::CoInitialize(NULL);
  35. try
  36. {
  37. m_pConnection.CreateInstance("ADODB.Connection");//创建Connection对象
  38. //m_pConnection.CreatInsancet
  39. //_bstr_t strConnect="Provider=SQLOLEDB;Sever=.;DataBase=airchina;uid=sa;pwd=;";
  40. _bstr_t strConnect="Provider=SQLOLEDB;Sever=.;DataBase=salarynew;Integrated Security=SSPI;";
  42. m_pConnection->Open(strConnect,"","",adModeUnknown);
  43. }
  45. catch(_com_error e){
  46. AfxMessageBox(e.Description());
  47. }
  49. }
  51. _RecordsetPtr& ADOConn::GetRecordSet(_bstr_t bstrSQL)
  52. {
  53. try
  54. {
  55. //连接数据库
  56. if(m_pConnection==NULL)
  57. OnInitADOConn();
  58. //创建记录集
  59. m_pRecordset.CreateInstance(__uuidof(Recordset));
  60. //取得表中记录
  61. m_pRecordset->Open( bstrSQL, m_pConnection.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText);
  62. }
  63. catch(_com_error e)
  64. {
  65. AfxMessageBox(e.Description());
  66. }
  67. return m_pRecordset;//返回记录集
  68. }
  70. BOOL ADOConn::ExecuteSQL(_bstr_t bstrSQL)
  71. {
  72. _variant_t RecordsAffected;
  73. try
  74. {
  75. if(m_pConnection==NULL)
  76. OnInitADOConn();
  77. m_pConnection->Execute(bstrSQL,0,adCmdText);
  78. return true;
  79. }
  80. catch(_com_error e)
  81. {
  82. AfxMessageBox(e.Description());
  83. return false;
  84. }
  85. }
  87. void ADOConn::ExitConnect()
  88. {
  89. //关闭记录集和链接
  90. if(m_pRecordset!=NULL)
  91. m_pRecordset->Close();
  92. m_pConnection->Close();
  94. ::CoUninitialize();//释放环境
  95. }