unit1.pas

学习Delphi最好的教材。通过一个个简单而实用的实例

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    Label1: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    Button2: TButton;
    Label2: TLabel;
    Edit2: TEdit;
    Button3: TButton;
    Button4: TButton;
    Label3: TLabel;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    Button5: TButton;
    Label4: TLabel;
    ComboBox1: TComboBox;
    Button6: TButton;
    Label5: TLabel;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    Label6: TLabel;
    Button7: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
  ADOQuery1.Close;
  ADOQuery1.SQL.Text:='select * from 学生 where 学号="'+Edit1.Text+'"';
  ADOQuery1.Open;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  ADOQuery1.Close;
  ADOQuery1.SQL.Text:='select * from 学生 where 学号 like "%'+Edit1.Text+'%"';
  ADOQuery1.Open;
end;

procedure TForm1.Button3Click(Sender: TObject);
begin
  ADOQuery1.Close;
  ADOQuery1.SQL.Text:='select * from 学生 where 姓名="'+Edit2.Text+'"';
  ADOQuery1.Open;
end;

procedure TForm1.Button4Click(Sender: TObject);
begin
  ADOQuery1.Close;
  ADOQuery1.SQL.Text:='select * from 学生 where 姓名 like "%'+Edit2.Text+'%"';
  ADOQuery1.Open;
end;

procedure TForm1.Button5Click(Sender: TObject);
begin
  if RadioButton1.Checked then
  begin
    ADOQuery1.Close;
    ADOQuery1.SQL.Text:='select * from 学生 where 性别="男"';
    ADOQuery1.Open;
  end;
  if RadioButton2.Checked then
  begin
    ADOQuery1.Close;
    ADOQuery1.SQL.Text:='select * from 学生 where 性别="女"';
    ADOQuery1.Open;
  end;
end;

procedure TForm1.Button6Click(Sender: TObject);
begin
  ADOQuery1.Close;
  ADOQuery1.SQL.Text:='select * from 学生 where 籍贯="'+ComboBox1.Text+'"';
  ADOQuery1.Open;
end;

procedure TForm1.Button7Click(Sender: TObject);
begin
  ADOQuery1.Close;
  ADOQuery1.SQL.Text:='select * from 学生 where 出生日期>"'+ComboBox1.Text+'"';
  ADOQuery1.Open;
end;

end.