mysql 流读取文件_流文件读写数据库方法

采用_StreamPtr处理Loadfromfile，savetofile，open来处理。

/*

测试插入流文件，

*/

void insert_flow1()

{

_StreamPtr    pwStream;

_bstr_t        strPath("D:\\my\\21.wav");

_bstr_t        strOpen("");

_variant_t    varBLOB;

_variant_t  varOptional(DISP_E_PARAMNOTFOUND,VT_ERROR);

HRESULT hr = pwStream.CreateInstance(_uuidof(Stream));

if(SUCCEEDED(hr))

{

pwStream->Type = adTypeBinary;

hr = pwStream->Open(varOptional, adModeUnknown, adOpenStreamUnspecified, strOpen, strOpen);

}

_bstr_t strSql("select (max(id) +1) as id from t_mov1");

m_pRecordset->Open(strSql, _variant_t((IDispatch*)m_pConnection,true),

adOpenDynamic, adLockOptimistic, adCmdText);

variant_t vRet = m_pRecordset->GetCollect("id");