unit1.pas.~27~

《Delphi程序员成长攻略》-蒙祖强龚涛的源代码

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Button1: TButton;
    Table1: TTable;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    Edit1: TEdit;
    Label7: TLabel;
    Edit2: TEdit;
    Edit3: TEdit;
    procedure SpeedButton5Click(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
   var x:integer;
begin
    
    //
   // table1.DatabaseName := 'MyDSN';
   // table1.TableName := 'dbo.stu';
   // table1.Active := true;

   {
   //select name, grade from stu
   x:=90;

   //query1.SQL.Add('select stu_id, name, grade from stu where grade>80');

  // query1.Active := true;
    table1.DatabaseName := 'MyDSN';
    table1.TableName := 'dbo.stu';

    DataSource1.DataSet := table1;

   DBGrid1.DataSource := DataSource1;

    table1.Active := true;
   }

   //x:=table1.RecordCount;     //数据库行数
   //x:=table1.FieldCount; //数据库列数

   //x:=table1.r
   if table1.Bof then
       Edit2.Text := 'Bof=  true'
   else
       Edit2.Text := 'Bof=  false';


   if table1.Eof then
       Edit3.Text := 'Eof=  true'
   else
       Edit3.Text := 'Eof=  false';

    
end;

procedure TForm1.SpeedButton1Click(Sender: TObject);
begin
    table1.First;
end;

procedure TForm1.SpeedButton2Click(Sender: TObject);
begin
    table1.Next;
end;

procedure TForm1.SpeedButton3Click(Sender: TObject);
begin
    table1.Prior;
end;

procedure TForm1.SpeedButton4Click(Sender: TObject);
begin
    table1.Last;
end;

procedure TForm1.SpeedButton5Click(Sender: TObject);
begin
    table1.MoveBy(StrToInt(Edit1.Text))
end;

end.