我用的是occi,只能供你借鉴一下。ResultSet *rset=stmt->executeQuery("SELECT ad_composite FROM print_media WHERE product_id=6666 FOR UPDATE"); while(rset->next()) { Blob blob=rset->getBlob(1); if(blob.isNull()) cerr <<"Null Blob"<<endl; else { char buffer[BUFSIZE]; Stream *outstream=blob.getStream(1,0); //writing from buffer beginning at offset 1 until //a writeLastBuffer() method is issued. //contents of buffer are replaced after each writeBuffer(), //typically with an fread() while(<fread "BUFSIZE" bytes into buffer succeeds>) outstream->writeBuffer(buffer,BUFSIZE); outstream->writeLastBuffer(buffer,<remaining amt>); blob.closeStream(outstream); } } stmt->closeResultSet(rset); conn->commit();
有人教我一下好吗?最好有代码?我再重赏100
WHERE product_id=6666 FOR UPDATE");
while(rset->next())
{
Blob blob=rset->getBlob(1);
if(blob.isNull())
cerr <<"Null Blob"<<endl;
else
{
char buffer[BUFSIZE];
Stream *outstream=blob.getStream(1,0); //writing from buffer beginning at offset 1 until
//a writeLastBuffer() method is issued.
//contents of buffer are replaced after each writeBuffer(),
//typically with an fread()
while(<fread "BUFSIZE" bytes into buffer succeeds>)
outstream->writeBuffer(buffer,BUFSIZE);
outstream->writeLastBuffer(buffer,<remaining amt>);
blob.closeStream(outstream);
}
}
stmt->closeResultSet(rset);
conn->commit();