你在数据中数据类型定义要正确!
(Adoquery1.FieldByName('图片') as TBlobField).assign(图片的路径及文件名)
(Adoquery1.FieldByName('图片') as TBlobField).assign(图片的路径及文件名)
解决方案 »
- 开发外贸管理软件如何设计编码
- 我想判断一个edit.text里面输入的是不是日期类型的数据,delphi里面有没有相关的函数?谢谢
- 如何在delphi里面调用其他的exe程序???
- 在delphi7中如何判断一个网址或页面是否存在?急急急!
- 如何将一笔数据同时存入两个数据库?
- 这样的sql语句该怎样写??急
- 请教!关于配置三层结构中字串连接信息的INI文件问题,各位高手帮帮忙!
- 怎樣才能使query支持sql server的特有語法
- 以各位开发数据库程序的经验看,这种问题应该怎么样处理?
- 菜鸟提问:哪有FastReport 下载?我要做复杂报表好苦的!
- 帮帮忙忙了
- 请教:在 TEDIT 中输入时,把 TAB 的功能转给 ENTER
m_BitMap: TBitMap;
m_Jpeg: TJpegImage;
m_JpegStream: TMemoryStream;
begin
m_BitMap := TBitmap.Create;
m_Jpeg := TJpegImage.Create;
m_JpegStream := TMemoryStream.Create;
try
//VideoCap1.GrabFrameNoStop;
m_BitMap.LoadFromFile('capture.bmp');
m_Jpeg.Compress;
m_Jpeg.Assign(m_Bitmap);
m_Jpeg.SaveToStream(m_JpegStream); query1.Close;
query1.SQL.Clear;
query1.SQL.Add('pr_image :id,:test,:image');
query1.ParamByName('id').asinteger:=12;
query1.ParamByName('test').asstring:='图片';
query1.ParamByName('image').LoadFromStream(m_JpegStream,ftblob);
query1.ExecSQL; finally
m_Bitmap.Free;
m_Jpeg.free;
m_JpegStream.Free;
query1.close;
end;
读
var
m_JpegStream:TMemoryStream;
begin
m_JpegStream:=TMemoryStream.Create;
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from image_table where id_im=12');
query1.Prepare;
query1.Open;
(query1.FieldByName('image_im') as TBlobField).SaveToStream(m_JpegStream);
image1.Picture.Graphic:=nil;
image1.Picture.Graphic:=TJpegImage.Create;
m_JpegStream.Position:=0;
image1.Picture.Graphic.LoadFromStream(m_JpegStream);
能解释一下你写的sql语句吗?
说不认识TJpegImage
你所说的图片是什么类型的?
只能用bitmap
这是怎么回事?
我这个是用视频捕捉卡存的,你改一下就可以了,
不认识TJpegImage , 可能是你没有引用 jpeg 吧
MS_JpegStream:TMemoryStream;
M_BitMap:TBitMap;
M_Jpeg:TJpegImage;
begin
try
MS_JpegStream:=TMemoryStream.Create;
M_BitMap:=TBitMap.Create;
M_Jpeg:=TJpegImage.Create;
if extractfileext(filename)='.bmp' then
begin
M_BitMap.LoadFromFile(filename);
M_Jpeg.Compress;
M_Jpeg.Assign(M_BitMap);
end
else if extractfileext(filename)='.jpg' then
begin
M_Jpeg.LoadFromFile(filename);
end;
M_Jpeg.SaveToStream(MS_JpegStream);
with tempQuery do
begin
close;
sql.clear;
sql.Add('update userinfo set userphoto_ui=:IMage where userno_ui=:empid');
ParamByName('empid').asstring:=empid;
ParamByName('image').LoadFromStream(MS_JpegStream,ftblob);
ExecSQL;
end;
finally
MS_JpegStream.Free;
M_BitMap.Free;
M_Jpeg.Free;
end;
end;procedure TEmp_Form.GetPicture(EmpID: string; TempQuery: TQuery);
var
MS_JpegStream:TMemoryStream;
begin
try
MS_JpegStream:=TMemoryStream.Create;
with tempQuery do
begin
close;
sql.clear;
sql.Add('select userphoto_ui from userinfo where userno_ui=:empid');
parambyname('empid').asstring:=empid;
Open;
end;
if tempquery.FieldByName('userphoto_ui').isnull then
begin
emp_image.Picture.Graphic:=nil;
end
else
begin
(tempQuery.FieldByName('userphoto_ui') as tblobfield).savetostream(MS_JpegStream);
emp_image.Picture.Graphic:=nil;
emp_image.Picture.Graphic:=TJpegImage.Create;
MS_JpegStream.Position:=0;
emp_image.Picture.Graphic.LoadFromStream(MS_JpegStream);
end; finally
MS_JpegStream.Free;
end;这个够详细了吧?
不过,还有一个问题,dbimage好像就不能浏览以jpeg形式存放的图片,而image倒是可以的,不知道这里面有没有什么技巧?dbimage能浏览以jpeg形式存放的图片吗?