Category

Development Platform
Home > SourceCode/Document > Windows Develop > ADO-ODBC > View Code
ImageDBDoc.cpp
Package: ImageDB.rar　[view]
Upload User: bst807
Upload Date: 2022-07-10
Package Size: 74k
Code Size: 3k
Category:

ADO-ODBC

Development Platform:

Visual C++

ImageDBDoc.cpp：Code Content
  1. // ImageDBDoc.cpp : implementation of the CImageDBDoc class
  2. //
  4. #include "stdafx.h"
  5. #include "ImageDB.h"
  7. #include "ImageDBDoc.h"
  9. #ifdef _DEBUG
  10. #define new DEBUG_NEW
  11. #undef THIS_FILE
  12. static char THIS_FILE[] = __FILE__;
  13. #endif
  15. /////////////////////////////////////////////////////////////////////////////
  16. // CImageDBDoc
  18. IMPLEMENT_DYNCREATE(CImageDBDoc, CDocument)
  20. BEGIN_MESSAGE_MAP(CImageDBDoc, CDocument)
  21. //{{AFX_MSG_MAP(CImageDBDoc)
  22. // NOTE - the ClassWizard will add and remove mapping macros here.
  23. //    DO NOT EDIT what you see in these blocks of generated code!
  24. //}}AFX_MSG_MAP
  25. END_MESSAGE_MAP()
  27. /////////////////////////////////////////////////////////////////////////////
  28. // CImageDBDoc construction/destruction
  30. CImageDBDoc::CImageDBDoc()
  31. {
  32. // TODO: add one-time construction code here
  34. }
  36. CImageDBDoc::~CImageDBDoc()
  37. {
  38. }
  40. BOOL CImageDBDoc::OnNewDocument()
  41. {
  42. if (!CDocument::OnNewDocument())
  43. return FALSE;
  45. // TODO: add reinitialization code here
  46. m_pConnection.CreateInstance(__uuidof(Connection));
  47. m_pConnection->ConnectionString="File Name=image.udl";
  48. m_pConnection->ConnectionTimeout=20;
  49. m_pConnection->Open("","Admin","",adConnectUnspecified);
  50. /*m_pConnection->Execute("insert player values('04','vc++',0x)",NULL,adCmdText);
  51. _variant_t varSQL;
  52. varSQL="select photo from player where pno='04'";
  53. m_pRecordset.CreateInstance(__uuidof(Recordset));
  54. m_pRecordset->Open(varSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
  56. _StreamPtr pStm; 
  57. pStm.CreateInstance("ADODB.Stream");
  58. _variant_t varOptional(DISP_E_PARAMNOTFOUND,VT_ERROR);
  59. long lDataSize = m_pRecordset->GetFields()->GetItem("photo")->ActualSize;
  60. pStm->PutType(adTypeBinary); 
  61. pStm->Open( varOptional,adModeUnknown,adOpenStreamUnspecified, _bstr_t(), _bstr_t()); 
  62. pStm->LoadFromFile("e:\folder.jpg");//读入文件 
  63. _variant_t varBLOB=pStm->Read(adReadAll); 
  64. m_pRecordset->GetFields()->GetItem("photo")->Value = varBLOB;
  65. m_pRecordset->Update();
  66. m_pRecordset->Close();*/
  68. // (SDI documents will reuse this document)
  70. return TRUE;
  71. }
  75. /////////////////////////////////////////////////////////////////////////////
  76. // CImageDBDoc serialization
  78. void CImageDBDoc::Serialize(CArchive& ar)
  79. {
  80. if (ar.IsStoring())
  81. {
  82. // TODO: add storing code here
  83. }
  84. else
  85. {
  86. // TODO: add loading code here
  87. }
  88. }
  90. /////////////////////////////////////////////////////////////////////////////
  91. // CImageDBDoc diagnostics
  93. #ifdef _DEBUG
  94. void CImageDBDoc::AssertValid() const
  95. {
  96. CDocument::AssertValid();
  97. }
  99. void CImageDBDoc::Dump(CDumpContext& dc) const
  100. {
  101. CDocument::Dump(dc);
  102. }
  103. #endif //_DEBUG
  105. /////////////////////////////////////////////////////////////////////////////
  106. // CImageDBDoc commands