datalookup.pas

《delphi数据库设计与实例开发》随书光盘

unit DataLookup;

interface

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

type
  TForm1 = class(TForm)
    Table1: TTable;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label7: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Memo1: TMemo;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    Label8: TLabel;
    Edit6: TEdit;
    procedure Table1AfterOpen(DataSet: TDataSet);
    procedure FormCreate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Table1AfterOpen(DataSet: TDataSet);
begin
  edit1.Text:=IntToStr(Table1['Species No']);
  edit2.Text:=Table1['Category'];
  edit3.Text:=Table1['Common_Name'];
  edit4.Text:=Table1['Species Name'];
  edit5.Text:=IntToStr(Table1['Length (cm)']);
  Memo1.Text:=Table1['Notes'];
end;

procedure TForm1.FormCreate(Sender: TObject);
begin
 try
  Table1.Active:=true;
 except
 On E:EdatabaseError do
  ShowMessage(E.Message);
 end;
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
 Table1.First;//移到第一条记录
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
 Table1.Prior;  //移到上一条记录
end;

procedure TForm1.Button3Click(Sender: TObject);
begin
 Table1.Next;  //移到下一条记录
end;

procedure TForm1.Button4Click(Sender: TObject);
begin
 Table1.Last;  //移到最后一条记录
end;

procedure TForm1.Button5Click(Sender: TObject);
begin
 Table1.MoveBy(StrtoInt(edit6.Text));
End;


end.