没有度过,试一试下面的行不
TBlobField(ClientDataSet.FieldByName('data')).LoadFromFile(filename);
TBlobField(ClientDataSet.FieldByName('data')).LoadFromFile(filename);
解决方案 »
- 小弟对API不太熟,麻烦各位高手帮改写下,小弟可用真金来换取各位高手的帮助(2)!
- 谁帮我详细介绍一下varient类型和olevarient类型
- 我读一个旧程序总是在xpmenu控件代码段提示'Property CurrencyStyle does not exists.',请指教
- 请问delphi控件安装完后,还需要在哪个菜单下设置一下路径什么的,请指教,谢谢
- 北京急招DELPHI程序员
- 请问哪位有用Delphi7编写的进行MD5加密和解密的代码?
- ***** 刚刚结贴 又一个问题
- 利用DELPHI如何创建ACCESS数据库?
- 如何实现文字两端对齐。
- 在SQLSEVER中有Image字段,如何用Delphi添加图片?
- 请教web ISAPI应用程序的多线程问题
- 现在还有用DBASE或FOXPRO编程的吗?学校里还一直在考这些东西呢。请大家说一说。
at ocean617...
blackfiles(从来是我伤心)
请问怎么结合能否详细点,谢谢!
procedure PutImageintoDB(car_id:string;tempQuery:TQuery);
var //图片保存到数据库 注意这里是JPG格式的图片
buf2,buf:pchar;
f1:file;
filelen:integer;
begin
try
buf2:=pchar(car_id);;
assignfile(f1,car_id+'.jpg');
reset(f1,1);
filelen:=filesize(f1);
buf:=allocmem(filelen);
blockread(f1,buf^,filelen);
closefile(f1);
with tempQuery do begin
close;
with SQL do begin
Add('insert into carinimage values(:cim_id,:cim_image)');
end;
end;
try
tempQuery.ParamByName('cim_id').DataType:=ftString;
tempQuery.ParamByName('cim_id').SetData(buf2);
tempQuery.ParamByName('cim_image').SetBlobData(buf,filelen);
tempQuery.ExecSQL;
except
end;
buf2:=nil;
freemem(buf);
except
end;
end;
procedure GetImagefromDB(car_id:string;tempQuery:TQuery);
begin //从数据库中取出图片
with tempQuery do begin
close;
with SQL do begin
clear;
Add('select cim_image from carinimage where cim_id='''+car_id+'''');
end;
Open;
end;
(tempQuery.FieldByName('Cim_image') as tblobfield).savetofile(car_id+'.jpg');
end;
1 您来说说数据库是用来存什么的
2 您凭什么认为图片存入数据库没有价值呢?
3 调图片的方法您给举上几种,ok?
procedure TForm1.ImageIntoDBBitBtnClick(Sender: TObject);
begin
try
with Query1 do
begin
close;
sql.clear;
sql.add('insert into img (imga) values(:imag)');
end;
try
if FileName<>'' then
ParamByName('Img').LoadfromFile(FileName,ftGraphic)
else
ParamByName('Img') .asBlob:='';
Query1.ExecSQL;
except
ShowMessage('图片保存出错!');
exit;
end;
except
end;
end;
//读取
procedure TForm1.ImageFromDBBitBtnClick(Sender: TObject);
var
m_jpegstream:tmemorystream;
begin
with Query1 do
begin
close;
sql.clear;
sql.Add('select imga from img');
try
Open;
except
exit;
end;
end;
if (Query1.FieldByName('imga') as tblobfield).asstring='' then
begin
exit;
end
else
begin
try
try
m_jpegStream:=TMemoryStream.Create;
(Query1.fieldbyname('imga') as TBlobField).SaveToStream(m_JpegStream);
m_JpegStream.Position:=0;
try
image2.Picture.Graphic:=nil;
image2.Picture.Graphic:=TJpegImage.Create;
image2.Picture.Graphic.LoadFromStream(m_JpegStream); //读Jpeg
except
Image2.Picture.Bitmap.LoadFromStream(m_JpegStream); //读Bmp
end;
except
end;
finally
m_JpegStream.Free;
Query1.Close;
Query1.UnPrepare;
end;
end;
end;
//BMP转换为JPG
procedure TStuXXSLForm.LoadImageBitBtnClick(Sender: TObject);
var
MyJpeg:TJpegImage;
begin
inherited;
if OpenPictureDialog1.Execute then
begin
FileName:=OpenPictureDialog1.FileName;
Image1.Picture.LoadFromFile(FileName);
if ExtractFileExt(FileName)='.Bmp' then
begin
MyJpeg:= TJpegImage.Create;
MyJpeg.Assign(Image1.Picture.Bitmap);
FileName:='Photo.Jpg';
MyJpeg.SaveToFile(FileName);
MyJpeg.Free;
end;
end;
end;