unit1.pas

精彩编程百例75～100 其中有媒体播放器 SQL语言编辑器 ADO方法连接多个数据库 用户密码验证系统 获取Man地址 信史服务 ping命令等待

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Table1: TTable;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    procedure FormCreate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.FormCreate(Sender: TObject);
begin
  Table1.Open;
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
  try
    table1.Append;
  finally
    table1.Post;
    table1.Refresh;
  end;
end;


procedure TForm1.Button2Click(Sender: TObject);
begin
  try
    table1.Edit;
  finally
    table1.Post;
    table1.Refresh;
  end;
end;



procedure TForm1.Button3Click(Sender: TObject);
begin
  if table1.RecordCount>0
    then if application.MessageBox('确认要删除本记录吗?','确定',MB_YESNOCANCEL+MB_ICONINFORMATION)=IDYes
      then table1.Delete;

end;


procedure TForm1.Button4Click(Sender: TObject);
var
  mystring:string;
  YesOrNo:boolean;

begin
  mystring:='a';
  YesOrNo:=InputQuery('输入查询条件','查询姓名为',mystring);
  if YesOrNo then
     begin
       table1.Filter:='Name='+''''+mystring+'''';
       table1.Filtered:=true;
     end
  else
     begin
       table1.Filter:='';
       table1.Filtered:=False;

     end;
end;

end.