unit1.pas

DELPHI7编程百例 DELPHI7编程百例 DELPHI7编程百例

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    ListBox1: TListBox;
    ComboBox1: TComboBox;
    Label1: TLabel;
    Label2: TLabel;
    ListBox2: TListBox;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Table1: TTable;
    Label3: TLabel;
    Edit1: TEdit;
    Label4: TLabel;
    procedure ListBox1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure ComboBox1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;
  str1,str2:string;
implementation

{$R *.dfm}


procedure TForm1.FormCreate(Sender: TObject);
begin
  with ComboBox1 do
  begin
    Items.Clear;
    Session.GetAliasNames(Items);
    Text:=Items[0];
  end;
end;

procedure TForm1.ComboBox1Click(Sender: TObject);
begin
  str1:=ComboBox1.Items.Strings[ComboBox1.Itemindex];
  with ListBox1 do
  begin
    Items.Clear;
    Session.GetTableNames(str1,'',true,true,ListBox1.Items);
  end;
end;

procedure TForm1.Button3Click(Sender: TObject);
begin
  Application.Terminate;
end;
procedure TForm1.ListBox1Click(Sender: TObject);
begin
  with Table1 do
  begin
    Close;
    DatabaseName:=str1;
    TableName:=ListBox1.Items.Strings[ListBox1.ItemIndex];
    Open;
  end;
  with ListBox2 do
  begin
    Items.Clear;
    Items:=Table1.FieldList;
    str2:=Items.Strings[0];
    Label4.Caption:='请输入要查询的'+str2+'值';
  end;
end;
procedure TForm1.Button1Click(Sender: TObject);
begin
  Table1.Prior;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  Table1.Next;
end;

procedure TForm1.Button4Click(Sender: TObject);
begin
  with Table1 do
  begin
    Close;
    Open;
    if FindKey([Edit1.Text]) then
    begin
      Showmessage('查找成功!');
    end
    else
    begin
      Showmessage('查找失败!');
    end;
  end;
end;

end.