u_form1.pas

很好地delphi书籍源码

unit U_Form1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ComCtrls, ExtCtrls, DBCtrls, ToolWin, DB, ADODB, Menus, Grids,
  DBGrids, Buttons, StdCtrls;

type
  TForm1 = class(TForm)
    DBGrid1: TDBGrid;
    ADOConnection1: TADOConnection;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    ToolBar1: TToolBar;
    DBNavigator1: TDBNavigator;
    Memo1: TMemo;
    ComboBox1: TComboBox;
    SpeedButton1: TSpeedButton;
    CheckBox1: TCheckBox;
    procedure FormCreate(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;
implementation

{$R *.dfm}

procedure TForm1.FormCreate(Sender: TObject);
begin
  with  DBGrid1 do
  begin
    Columns[2].PickList.Add('火车');
    Columns[2].PickList.Add('汽车');
    Columns[2].PickList.Add('轮船');
    Columns[2].PickList.Add('飞机');
    Columns[7].PickList.Add('正在办理');
    Columns[7].PickList.Add('结束');
    Columns[7].PickList.Add('已经定上');
    Columns[7].PickList.Add('没定上');
  end;
  ADOConnection1.GetFieldNames('tbBookTicket',ComboBox1.Items);
end;


procedure TForm1.SpeedButton1Click(Sender: TObject);
begin
  ADOQuery1.Close;
  ADOQuery1.SQL.Text:=Memo1.Text;
  if CheckBox1.Checked then
    ADOQuery1.Open
  else
    ADOQuery1.ExecSQL;
end;

end.