vc mfc 图片存储mssql数据库中及显示

2019-04-15 18:36发布

站内文章 / PIC单片机
14169 0 1680
//add pic to database; the column save image type must image void CBmpDlgDlg::WriteImage2DB(CString path) { ADOConn m_AdoConn; m_AdoConn.OnInitADOConn(); try { CFile fileAdd; if (fileAdd.Open ("Debug\nv.bmp",CFile::modeRead) == 0) // open the file return; _variant_t varChunk; long m_nFileLen = fileAdd.GetLength(); BYTE * m_pBMPBuffer; m_pBMPBuffer = new BYTE[m_nFileLen]; if (m_pBMPBuffer == NULL) return; fileAdd.Read(m_pBMPBuffer,m_nFileLen); char * pBuf = (char *)m_pBMPBuffer; VARIANT varBLOB; SAFEARRAY * psa; SAFEARRAYBOUND rgsabound[1]; /****/ CString strSQL; _bstr_t bstr; strSQL.Format(_T("select count(*) as num, Max(ID) as maxid from pic")); _RecordsetPtr m_pRecordset; try { m_pRecordset = m_AdoConn.GetRecordset((_bstr_t)strSQL); } catch (_com_error &e) { AfxMessageBox("获取最大id失败"); } //从RecordSet中获取数据数目和当前数据库中最大的ID。 long num =m_pRecordset->GetCollect("num"); long maxid; try { if (num != 0) { maxid = m_pRecordset->GetCollect("maxid"); } else { maxid = 0; } } catch (_com_error &e) { AfxMessageBox(e.Description()); } strSQL.Format(_T("Select * from pic where ID = %d"), maxid); m_pRecordset.CreateInstance(__uuidof(Recordset)); m_pRecordset = m_AdoConn.GetRecordset((_bstr_t)strSQL); m_pRecordset-> AddNew(); m_pRecordset-> PutCollect ("name", _variant_t ("Mike")); //add data to db by column if (pBuf) { rgsabound[0].lLbound = 0; rgsabound[0].cElements = m_nFileLen; psa = SafeArrayCreate (VT_UI1, 1, rgsabound); /// Create a SAFEARRAY object for (long i = 0; i<(long)m_nFileLen; i++) SafeArrayPutElement (psa,&i, pBuf++); /// pBuf point binary data saved to the SAFEARRAY object psa, varBLOB.vt = VT_ARRAY | VT_UI1; /// varBLOB type is set to an array of type BYTE varBLOB.parray = psa; /// for varBLOB variable assignment m_pRecordset->GetFields ()->GetItem ("pic")->AppendChunk(varBLOB) ;/// BLOB type data } m_pRecordset->Update(); //update data m_AdoConn.ExitConnect(); AfxMessageBox("添加数据成功!"); } } //get pic data from databse and path gen pic int CSS628DDlg::CreateImageByBinData(CString path,CString m_IDNum) { ADOConn m_AdoConn; m_AdoConn.OnInitADOConn(); int m_retv=0; try { CString strSQL; _bstr_t bstr; _RecordsetPtr m_pRecordset; /****************************************************/ //Read from the database out of the picture strSQL.Format(_T("Select * from IdCard where IDNum = '%s'"),m_IDNum); m_pRecordset.CreateInstance(__uuidof(Recordset)); m_pRecordset = m_AdoConn.GetRecordset((_bstr_t)strSQL); long lDataLength = m_pRecordset->GetFields()-> GetItem(_variant_t ("Img"))-> ActualSize; m_AdoConn.m_pRecordset->adoEOF; if(!m_AdoConn.m_pRecordset->adoEOF) { m_strIDNum=m_IDNum; if (lDataLength> 0) { _variant_t varBLOB; varBLOB = m_pRecordset->GetFields ()->GetItem(_variant_t ("Img"))->GetChunk (lDataLength); if (varBLOB.vt == (VT_ARRAY|VT_UI1) && varBLOB.vt != VT_EMPTY && varBLOB.vt != VT_NULL) { BYTE * pBuf = NULL; pBuf = (BYTE *) GlobalAlloc (GMEM_FIXED, lDataLength); SafeArrayAccessData (varBLOB.parray, (void **)&pBuf); CFile outFile(path,CFile::modeCreate | CFile::modeWrite); // construct a new file, if the file exists, the length becomes 0 outFile.Write(pBuf,lDataLength); outFile.Close(); SafeArrayUnaccessData (varBLOB.parray); } } else { //zb.bmp文件如果存在则删除 if(GetFileAttributes("zp.bmp")!=-1) DeleteFile("zp.bmp"); } m_retv=1; UpdateData(FALSE); } /***********************************/ m_AdoConn.ExitConnect(); } catch (_com_error &e) { //AfxMessageBox(e.Description()); } return m_retv; }

热门文章