用Stream,以前有很多这样的帖子,搜索一下看。
解决方案 »
- 在线等,非常急。。。TMultiP这个库那里有下载。大家帮帮我。我快被老板板逼疯了!!!
- 我想把窗体上的所有EDIT清空怎么做?
- 用Delphi连接MSSQL
- 请问如何用网站提供的搜索引擎,知道查找关键字,我用的是WebBrowser1,100分呀
- 怎么用fastreport实现小计和合计?
- 怎么没有人知道吗?二级转向域名吗????
- sql server中表如何加密?
- StringGrid控件,如何按CTRL键行多选(不连续的行),将其设成选中状态
- 有谁知道在bmp中夹带txt的算法
- 我该如何写呢?
- 在Delphi中如何使用第三方控件?
- delphi 中如何判断一个*.ocx 或 *.dll是否注册....
FileName:TFileName;
begin
....
FileName:='c:\test.bmp'; // .jpg..
with Query do
begin
Close;
SQL.Clear;
SQL.Add('Insert into tablename (zp) values (:img) ');
if FileName<>'' then
ParamByName('Img').LoadfromFile(FileName,ftGraphic)
else
ParamByName('Img').Asstring:='';
ExecSQL;
end;
end;
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;