DELPHI 查找，增加，修改，删除

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids, DB, ADODB, StdCtrls;

type
  TForm1 = class(TForm)
    Edit1: TEdit;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    DBGrid1: TDBGrid;
    Button4: TButton;
    procedure FormCreate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.FormCreate(Sender: TObject);
var
s:string;
begin
s:='select id,sj from fsjl';
form1.ADOQuery1.Close;
form1.ADOQuery1.Sql.Clear;
form1.ADOQuery1.SQL.Add(s);
form1.ADOQuery1.open;
end;

procedure TForm1.Button1Click(Sender: TObject);   //add
var
s:string;
begin
s:='insert into fsjl (sj) values ('''+Edit1.Text+''')';
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Text:=s;
ADOQuery1.ExecSQL;

Form1.ADOQuery1.Close;
Form1.ADOQuery1.SQL.Clear;
Form1.ADOQuery1.SQL.Add('select * from fsjl');
Form1.ADOQuery1.Open;
end;

procedure TForm1.Button2Click(Sender: TObject);  //edit
var
s:string;
begin
s:='update fsjl set sj ='''+Edit1.Text+''' where id ='''+Form1.ADOQuery1.fieldbyname('id').asstring+'''';
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Text:=s;
ADOQuery1.ExecSQL;

Form1.ADOQuery1.Close;
Form1.ADOQuery1.SQL.Clear;
Form1.ADOQuery1.SQL.Add('select * from fsjl');
Form1.ADOQuery1.Open;
end;

procedure TForm1.Button3Click(Sender: TObject);   //del
var
str:string;
id:string;
begin
//得到dbgrid某行记录的id
id:=Form1.ADOQuery1.fieldbyname('id').asstring;
if id_no=application.MessageBox(pchar('真的要删除ID='+id+'数据吗？'),'确认信息',mb_YesNo) then
exit;
try
Form1.ADOQuery1.Close;
Form1.ADOQuery1.SQL.Clear;
str:='delete from fsjl where id='+id;
Form1.ADOQuery1.SQL.Add(str);
Form1.ADOQuery1.ExecSQL;
showmessage('数据删除成功');
//在dbgrid中显示数据
Form1.ADOQuery1.Close;
Form1.ADOQuery1.SQL.Clear;
Form1.ADOQuery1.SQL.Add('select * from fsjl');
Form1.ADOQuery1.Open;
except
end;
end;

procedure TForm1.Button4Click(Sender: TObject);   //search
var
s:string;
begin
s:='select id,sj from fsjl where sj='''+Edit1.Text+'''';
form1.ADOQuery1.Close;
form1.ADOQuery1.Sql.Clear;
form1.ADOQuery1.SQL.Add(s);
form1.ADOQuery1.open;
end;

procedure TForm1.DBGrid1CellClick(Column: TColumn);     //单击事件
begin
Edit1.Text:=Form1.ADOQuery1.fieldbyname('sj').asstring;
end;

end.