调用存储过程进行图片的插入或修改

//pass   blob   to   stored   procedure       //build   by   masterz   20050301   with   VC2003,   Windows   2003,   SQLServer   2000.     #include   "stdafx.h"     #import   "C:/PROGRA~1/COMMON~1/System/ado/msado15.dll"   rename(   "EOF",   "adoEOF"   )     struct   InitOle     {     InitOle()     {   ::CoInitialize(NULL);   }     ~InitOle()   {   ::CoUninitialize();     }     }   _init_InitOle_;     void   PrintProviderError(ADODB::_ConnectionPtr   pConnection);         void   print_properties(LPCTSTR   name,   ADODB::PropertiesPtr   Properties)     {     long   prop_count   =   Properties->GetCount();     printf("%s   property   count   =   %d/n",name,prop_count);     for(long   i=0;i<prop_count;i++)     {     printf("%s   property   [%d]:%s/n",name,i,(LPCSTR)Properties->GetItem(i)->Name);     }     }     int   main(int   argc,   char*   argv[])     {     ADODB::_ConnectionPtr     Conn1;     ADODB::_CommandPtr         Cmd1;     ADODB::_ParameterPtr     oldParam=   NULL;     ADODB::_ParameterPtr   inParam=NULL;     ADODB::_ParameterPtr   blobParam=NULL;     _variant_t     vtEmpty   (DISP_E_PARAMNOTFOUND,   VT_ERROR);     _variant_t     vtEmpty2   (DISP_E_PARAMNOTFOUND,   VT_ERROR);     //_bstr_t         bstrConnect="Provider=OraOLEDB.Oracle;Data   Source=orcl;User   Id=system;Password=oracle;";       _bstr_t         bstrConnect="Driver={SQL   Server};Server=localhost;Database=zxg;Uid=sa;Pwd=sa;"   ;       //create   procedure   dbo.insert_update_blob(@fn   varchar(9),@filecontent   image)   as     //   if   exists   (select   *   from   table1   where   filename=@fn   )     //   begin     //   update   table1   set   content=@filecontent   where   filename=@fn     //   end     //   else     //   begin     //   insert   table1   (filename,content)   values(@fn,@filecontent)     //   end     _bstr_t         bstrSP("{CALL   insert_update_blob(?,?)}"   );     try     {     _variant_t   varOptional(DISP_E_PARAMNOTFOUND,VT_ERROR);       ADODB::_StreamPtr   adostream;     adostream.CreateInstance(_T("ADODB.Stream"));     adostream->Type   =   ADODB::adTypeBinary;     adostream->Open(varOptional,ADODB::adModeUnknown,   ADODB::adOpenStreamUnspecified,   _T(""),   _T(""));       adostream->LoadFromFile("C://masterz//20041229.rar");     _variant_t   vReadTo   =   adostream->Read(ADODB::adReadAll);       long   blob_size   =   adostream->GetSize();     adostream->Close();         _bstr_t   bstrEmpty;     Conn1.CreateInstance(   __uuidof(   ADODB::Connection   )   );     Cmd1.CreateInstance(   __uuidof(   ADODB::Command   )   );     Conn1->ConnectionString   =   bstrConnect;     Conn1->Open(   bstrConnect,   bstrEmpty,   bstrEmpty,   -1   );     Cmd1->ActiveConnection   =   Conn1;     Cmd1->CommandText             =   bstrSP;     Cmd1->CommandType             =   ADODB::adCmdText;     Conn1->Properties->Refresh();     inParam   =   Cmd1->CreateParameter(_bstr_t("@fn"),ADODB::adChar,ADODB::adParamInput,2,_variant_t(   "a"   ));     Cmd1->Parameters->Append(inParam);     blobParam   =   Cmd1->CreateParameter(_bstr_t("@filecontent"),ADODB::adLongVarBinary,ADODB::adParamInput,blob_size,vReadTo);     Cmd1->Parameters->Append(blobParam);     Cmd1->Properties->Refresh();     print_properties("Cmd1",Cmd1->Properties);     Cmd1->Execute(NULL,NULL,ADODB::adExecuteNoRecords);     Conn1->Close();     //select   filename,datalength(content)   from   table1   where   datalength(content)>0     }     catch(_com_error   &e)     {     _bstr_t   bstrSource(e.Source());     _bstr_t   bstrDescription(e.Description());     printf("/nCOM   error   occurred,   Source   :   %s   /n   Description   :   %s   /n",(LPCSTR)bstrSource,(LPCSTR)bstrDescription);     PrintProviderError(Conn1);     }     printf("/nprogram   end/n");     return   0;     }     VOID   PrintProviderError(ADODB::_ConnectionPtr   pConnection)     {     ADODB::ErrorPtr     pErr   =   NULL;     long             nCount   =   0;     long             i   =   0;     if(   (pConnection->Errors->Count)   >   0)     {     nCount   =   pConnection->Errors->Count;     for(i   =   0;   i   <   nCount;   i++)     {     pErr   =   pConnection->Errors->GetItem(i);     printf("/n/t   Error   number:   %x/t%s",   pErr->Number,   (LPCSTR)pErr->Description);     }     }     }