怎样实现数据库中图片存储？？？

cmdImg.CommandText := 'update images set imageinfo = :v1, ImgType = :v2 where imgID =:v3';
    cmdImg.Parameters.ParamByName('v1').Assign(Image1.Picture.Graphic);
    cmdImg.Parameters.ParamByName('v2').Value := imageType;
    cmdImg.Parameters.ParamByName('v3').Value := dtimg.fieldbyname('imgID').Value;
    cmdImg.Execute;

或者这样TBlobField(FieldByName('pic')).LoadFromStream(imgStream);

TBlobField(FieldByName('pic')).LoadFromStream(imgStream);
这样是最科学的
要先建个流

//保存图片到数据库的话，下边可以考虑。。//记得加上uses jpeg ;
//其中有些地方不是太严密，回去修改下。。
//delphi7+ sql2000通过.可以保存jpeg,jpg,bmp三种格式。unit Unit1;interfaceuses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, jpeg,DB, ADODB, ExtCtrls, Buttons, Grids, DBGrids,
  DBCtrls;type
  TForm1 = class(TForm)
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    Button1: TButton;
    OpenDialog1: TOpenDialog;
    Edit1: TEdit;
    Image1: TImage;
    Image2: TImage;
    BitBtn1: TBitBtn;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    ADOQuery1pic: TBlobField;
    ADOQuery1borj: TStringField;
    procedure Button1Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);  private
    { Private declarations }
  public
    { Public declarations }
  end;var
  Form1: TForm1;
  s:string;
  s1:string;
implementation{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);
var
bitmap1:tbitmap;
pjpg:tjpegimage;
pic:TMemoryStream;begin
pjpg:=tjpegimage.Create;
if opendialog1.Execute
    then
     s:=opendialog1.FileName ;
     s1:=extractfileext(s);

     if (uppercase(s1) ='.JPG' ) or (uppercase(s1)='.JPEG') // 图片格式一定要大写
       THEN
         begin
              pjpg.LoadFromFile(s );
              pic:=TMemoryStream.Create;
              pjpg.SaveToStream(pic);
              image1.Picture.Bitmap.Assign(pjpg);              pic.Position:=0;
              adoquery1.Insert ;
              adoquery1.FieldByName('borj').VALUE := 2;
              TBlobField(adoquery1.FieldByName('pic')).LoadFromStream(pic);
              adoquery1.post;
              pic.Free;
              pjpg.free;
        end ;    if (uppercase(s1)='.BMP')    then           begin
              edit1.Text :=uppercase(s1);             image1.Picture.LoadFromFile(s);
             adoquery1.Insert ;
             adoquery1.FieldByName('pic').Assign(image1.Picture.Graphic);
             adoquery1.FieldByName('borj').VALUE := 3;             adoquery1.Post ;
          end;
end;  procedure TForm1.BitBtn1Click(Sender: TObject);   var
    jpeg:tjpegimage;
      begin
       image1.Picture.Graphic :=nil;
            with adoquery1 do
                 begin
                    if adoquery1.FieldByName('borj').Value =3   // bmp
                    then
                     image2.Picture.Bitmap.Assign(fieldbyname('pic'))  ;                     if adoquery1.FieldByName('borj').Value =2  //jpge;                     then
                        begin
                               jpeg:=tjpegimage.Create ;
                                try
                                 jpeg.Assign(adoquery1.FieldByName('pic') );
                                  image2.Picture.Graphic:=jpeg;
                                   finally
                                   jpeg.Free ;
                                 end;
                        end;                 end ;
                    end;end.

DELPHI存取JPEG文件到SQL Server数据库(续文)
在”DELPHI存取JPEG文件到SQL Server数据库”发表之后，有许多网友来电表示支持和相关的技术咨询，在此首先对那些关心本文的朋友们表示衷心的感谢。
　　由于网友的需要做一个档案管理系统，存取jpeg文件到sql 2000数据库中，但在dbimage中及qrdbimage中均不能正常显示jpeg的文件，此为borland的限制，虽然使用第三方控件能达到要求，但我们还是来原始的实现一下这方面的技术，其实原理十分简单，既然我们在”DELPHI存取JPEG文件到SQL Server数据库”能存储jpeg文件，也能在image中显示，但一接触db类的图象显示控件就行不通了，我们可以在jpeg文件存入数据库之前转换成bmp文件再存入数据库即可，程序运行环境delphi5+ado+sql 2000桌面版+win98se2最终版，数据库中存放图片字段的类型为image，程序源代码如下：
unit Unit1;interfaceuses
Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
Db, DBCtrls, Grids, DBGrids, ADODB, ExtDlgs,jpeg, ExtCtrls, StdCtrls;type
TForm1 = class(TForm)
ADOConnection1: TADOConnection;
ADOQuery1: TADOQuery;
DataSource1: TDataSource;
DBGrid1: TDBGrid;
DBImage1: TDBImage;
ADOQuery1ID: TStringField;
ADOQuery1FIELD: TStringField;
ADOQuery1STYLE: TStringField;
ADOQuery1SYSTEM: TStringField;
ADOQuery1DATE: TDateTimeField;
ADOQuery1PERSON1: TStringField;
ADOQuery1PERSON2: TStringField;
ADOQuery1PERSON3: TStringField;
ADOQuery1PHOTO: TBlobField;
ADOQuery1DESCRIPTION: TStringField;
OpenPictureDialog1: TOpenPictureDialog;
Image1: TImage;
Button1: TButton;
Memo1: TMemo;
procedure DBImage1Click(Sender: TObject);
procedure Button1Click(Sender: TObject);
procedure FormShow(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.DFM}procedure TForm1.DBImage1Click(Sender: TObject);
var
picstream:tadoblobstream;
bmppic:tbitmap;
jpgpic:tjpegimage;
bmpstream:TMemoryStream;
begin
if form1.OpenPictureDialog1.Execute then
begin
if extractfileext(form1.openpicturedialog1.filename)=’.bmp’ then
begin
adoquery1.edit;
picstream:=tadoblobstream.Create(tblobfield(ADOQuery1.fieldbyname('PHOTO'),bmWrite);
//注：上句代码中的ADOQuery1.fieldbyname('PHOTO')是adoquery1中的固定字段photo的固定字段的name
//用户需要手工添加固定字段，也可用fields[i]来进行选择，这点在
//”DELPHI存取JPEG文件到SQL Server数据库”这篇文章中没有注释，至使许多朋友没有
//编译成功。
picstream.LoadFromFile(openpicturedialog1.filename);
picstream.Position:=0;
adoquery1.edit;
tblobfield(ADOQuery1.fieldbyname('PHOTO')).loadfromstream(picstream);
adoquery1.post;
adoquery1.edit;
picstream.free;
end
else
begin
jpgpic:=tjpegimage.Create;
bmppic:=tbitmap.Create;
bmpstream:=tmemorystream.Create;
jpgpic.LoadFromFile(openpicturedialog1.filename);
bmppic.Assign(jpgpic);
bmppic.SaveToStream(bmpstream);
adoquery1.edit;
picstream:=tadoblobstream.Create(tblobfield(ADOQuery1PHOTO),bmWrite);
//注：上句代码中的ADOQuery1PHOTO是adoquery1中的固定字段photo的固定字段的name
//用户需要手工添加固定字段，也可用fields[i]来进行选择，这点在
//”DELPHI存取JPEG文件到SQL Server数据库”这篇文章中没有注释，至使许多朋友没有
//编译成功。
picstream.LoadFromStream(bmpstream);
picstream.Position:=0;
adoquery1.edit;
tblobfield(ADOQuery1.fieldbyname('PHOTO')).loadfromstream(picstream);
adoquery1.post;
jpgpic.free;
bmppic.free;
bmpstream.free;
adoquery1.edit;
picstream.free;
end;
end;
end;procedure TForm1.Button1Click(Sender: TObject);
begin
memo1.Lines.Add(form1.openpicturedialog1.filter);
end;procedure TForm1.FormShow(Sender: TObject);
begin
form1.openpicturedialog1.filter:=’All *.jpg;*.jpeg;*.bmp;|*.jpg;*.jpeg;*.bmp;)’;
end;end.

使用Blob字段unit Unit1;interfaceuses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,jpeg,
  ExtDlgs, Db, DBTables, StdCtrls, ExtCtrls, ADODB;type
  TForm1 = class(TForm)
    Button1: TButton;
    OpenPictureDialog1: TOpenPictureDialog;
    Button2: TButton;
    Image1: TImage;
    ADOQuery1: TADOQuery;
    ADOQuery2: TADOQuery;
    Edit1: TEdit;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    filename:string;
    procedure SetPicture(pos:string;TempQuery:TADOQuery);     /////往数据库中插入图片
    procedure GetPicture(pos:string;TempQuery:TADOQuery);      ////得到图片
  end;var
  Form1: TForm1;implementation{$R *.DFM}{ TForm1 }procedure TForm1.GetPicture(pos:string;TempQuery: TADOQuery);
var
  MS_JpegStream:TMemoryStream;
begin
  try
    MS_JpegStream:=TMemoryStream.Create;
    with tempQuery do
      begin
        close;
        sql.clear;
        //修改这个语句
        sql.Add('select picture from table where no=:pos');
        Parameters.ParamByName('pos').value:=pos;
        Open;
      end;
    if tempquery.FieldByName('image').isnull then
      begin
        image1.Picture.Graphic:=nil;
      end
    else
      begin
         (tempQuery.FieldByName('image') as tblobfield).savetostream(MS_JpegStream);
         image1.Picture.Graphic:=nil;
         image1.Picture.Graphic:=TJpegImage.Create;
         MS_JpegStream.Position:=0;
         image1.Picture.Graphic.LoadFromStream(MS_JpegStream);
      end;  finally
    MS_JpegStream.Free;
  end;end;procedure TForm1.SetPicture(pos:string; TempQuery: TADOQuery);
var
  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('insert into table (no,IMage) values (:pos,:image)');
        Parameters.ParamByName('pos').Value:=pos;
        Parameters.ParamByName('image').LoadFromStream(MS_JpegStream,ftblob);        ExecSQL;
      end;
  finally
    MS_JpegStream.Free;
    M_BitMap.Free;
    M_Jpeg.Free;
  end;
end;procedure TForm1.Button1Click(Sender: TObject);//打开图片并写入数据库
begin
  if openpicturedialog1.Execute then
  begin
   filename:=openpicturedialog1.FileName;
   SetPicture(edit1.text,ADOQuery1);
  end
end;procedure TForm1.Button2Click(Sender: TObject);//显示图片
begin
  getpicture(edit1.text,ADOQuery2);
end;end.

TBlobField(FieldByName('aa')).LoadFromStream(Stream);

参考以下，包能达到你的要求http://www.yesky.com/SoftChannel/72342371928440832/20030929/1733136_1.shtml

调试易

怎样实现数据库中图片存储？？？

解决方案 »