main.pas

Delphi7数据库开发教程,包含该书21套实例

unit main;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids, DB, ADODB, StdCtrls, DBXpress, FMTBcd, SqlExpr,
  ExtCtrls, DBCtrls, Mask;

type
  TForm1 = class(TForm)
    DataSource1: TDataSource;
    btnClose: TButton;
    btnConnect: TButton;
    btnDisconnect: TButton;
    SQLConnection1: TSQLConnection;
    SQLDataSet1: TSQLDataSet;
    DBEdit1: TDBEdit;
    Label1: TLabel;
    DBNavigator1: TDBNavigator;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    Label3: TLabel;
    DBEdit4: TDBEdit;
    Label4: TLabel;
    Shape1: TShape;
    procedure btnCloseClick(Sender: TObject);
    procedure btnConnectClick(Sender: TObject);
    procedure btnDisconnectClick(Sender: TObject);
    procedure SQLConnection1BeforeConnect(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.btnCloseClick(Sender: TObject);
begin
  Close;
end;

procedure TForm1.btnConnectClick(Sender: TObject);
begin
  SQLDataSet1.Active := True;
  //如果连接成功则设置按钮状态
  if SQLConnection1.Connected then
  begin
    btnConnect.Enabled := False;
    btnDisconnect.Enabled := True;
  end;
end;

procedure TForm1.btnDisconnectClick(Sender: TObject);
begin
  SQLDataSet1.Active := False;
  SQLConnection1.Close; 
  //如果成功断开连接则设置按钮状态
  if not SQLConnection1.Connected then
  begin
    btnConnect.Enabled := True;
    btnDisconnect.Enabled := False;
  end;

end;

end.