unit1.pas

本光盘是《Delphi 7应用教程》一书的配套光盘

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    DBGrid1: TDBGrid;
    Memo1: TMemo;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    DataSource1: TDataSource;
    Query1: TQuery;
    GroupBox1: TGroupBox;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    Table1: TTable;
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure RadioButton1Click(Sender: TObject);
    procedure RadioButton2Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.FormCreate(Sender: TObject);
  var
    CurDir:String;
begin
   Getdir(0,CurDir);
   Table1.DatabaseName :=CurDir;
   Table1.TableName :='通讯录';
   Query1.DatabaseName :=CurDir;
   Memo1.Clear ;
end;
procedure TForm1.RadioButton1Click(Sender: TObject);
begin
   //如果选择“SELECT 语句”单选钮，让DBGrid1显示Query1查询形成的数据集
   DataSource1.DataSet :=Query1;
   DBGrid1.DataSource :=DataSource1;
end;
procedure TForm1.RadioButton2Click(Sender: TObject);
begin
  //如果选择“其它数据操纵语句”单选钮，就让DBGrid1显示与Table1关联在一起的通讯录表中的数据
   DataSource1.DataSet :=Table1;
   DBGrid1.DataSource :=DataSource1;
   Table1.Open ;
end;
procedure TForm1.Button1Click(Sender: TObject);
begin
    Query1.SQL.Clear ;  //清除Query1组件中原来的SQL语句
    Query1.SQL.add(Memo1.Text ); //添加当前输入的SQL语句
    Query1.Prepare ;   //优化
    If RadioButton1.Checked then  //如果选择了“Select 语句”单选钮
         Query1.Open  //执行SQL语句，形成数据集并显示出来
    else    //如果选择了“其它数据操纵语句”单选钮
        begin
           Query1.ExecSQL  ;  //执行该SQL数据操纵语句
           table1.Refresh ;   //刷新Table1组件，把执行的结果显示出来
        End;
 end;
procedure TForm1.Button2Click(Sender: TObject);
begin
  Memo1.clear;   //清除输入的语句
end;
procedure TForm1.Button3Click(Sender: TObject);
begin
  Query1.Close ; //关闭Query1组件
  Table1.Close ; //关闭Table1组件
  Application.Terminate ;//结束应用程序的运行
end;

end.