1,178
社区成员
发帖
与我相关
我的任务
分享
//保存的代码
void __fastcall TForm1::Button1Click(TObject *Sender)
{
TADOQuery *Query = new TADOQuery(Application);
Query->ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExtractFilePath(Application->ExeName) + "1.mdb;";
Query->SQL->Text = "insert into table1(ee)values('asddasd')";
Query->ExecSQL();
TMemoryStream *Inifile = new TMemoryStream();
Inifile->LoadFromFile("123.ini");
Query->SQL->Text = "update table1 set asd =:PHOTO where ee ='asddasd'" ;
Query->Parameters->Items[0]->LoadFromStream(Inifile,ftBlob) ;
Query->ExecSQL();
Query->Close();
delete Query;
delete Inifile;
}
//读取的代码
void __fastcall TForm1::Button2Click(TObject *Sender)
{
TADOQuery *Query = new TADOQuery(Application);
Query->ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExtractFilePath(Application->ExeName) + "1.mdb;";
Query->SQL->Text = "select * from table1 where ee ='asddasd'";
Query->Open();
TBlobField * pField1=(TBlobField *)Query->FieldByName("asd");
if(!pField1->IsNull)
{
TADOBlobStream* pmem=new TADOBlobStream (pField1,bmRead);
pmem->Seek(0,soFromBeginning);
TMemoryStream *Inifile = new TMemoryStream();
Inifile->LoadFromStream(pmem);
Inifile->SaveToFile("12345.ini");
delete Inifile;
delete pmem;
}
Query->Close();
delete Query;
}
//将字段内容存为文件
TMemoryStream *temp=new TMemoryStream();
((TBlobField *)ADOQuery1->FieldByName("Package"))->SaveToStream(temp);
temp->Position=0;
temp->SaveToFile("123.ini");