bookindex.pas

来自「利用Delphi6.0和MS Server2000为主要开发工具」· PAS 代码 · 共 109 行

unit bookindex;

interface

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

type
  TFm_bookindex = class(TForm)
    Panel1: TPanel;
    Label3: TLabel;
    Label2: TLabel;
    Label1: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    DBGrid1: TDBGrid;
    procedure Edit1Click(Sender: TObject);
    procedure Edit2Click(Sender: TObject);
    procedure Edit3Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Fm_bookindex: TFm_bookindex;
   sql:string;
implementation

uses data;

{$R *.dfm}

procedure TFm_bookindex.Edit1Click(Sender: TObject);
begin
  edit2.Text:='';
  edit3.Text:='';
  edit1.Color:=clAqua;
  edit2.Color:=clGray;
  edit3.Color:=clGray;
  button1.Enabled:=true;
  button2.Enabled:=false;
  button3.Enabled:=false;
end;

procedure TFm_bookindex.Edit2Click(Sender: TObject);
begin
  edit1.Text:='';
  edit3.Text:='';
  edit1.Color:=clGray;
  edit2.Color:=clAqua;
  edit3.Color:=clGray;
  button1.Enabled:=false;
  button2.Enabled:=true;
  button3.Enabled:=false;
end;

procedure TFm_bookindex.Edit3Click(Sender: TObject);
begin
  edit1.Text:='';
  edit2.Text:='';
  edit1.Color:=clGray;
  edit2.Color:=clGray;
  edit3.Color:=clAqua;
  button1.Enabled:=false;
  button2.Enabled:=false;
  button3.Enabled:=true;
end;

procedure TFm_bookindex.Button1Click(Sender: TObject);
begin
   sql:='select * from book where bookname like '+'''%'+edit1.Text+'%''';
   fm_data.Cd_book.Close;
   fm_data.Cd_book.CommandText:=sql;
   fm_data.Cd_book.Execute;
   fm_data.Cd_book.Open;
end;

procedure TFm_bookindex.Button2Click(Sender: TObject);
begin
   sql:='select * from book where auther like '+'''%'+edit2.Text+'%''';
   edit1.Text:=sql;
   fm_data.Cd_book.Close;
   fm_data.Cd_book.CommandText:=sql;
   fm_data.Cd_book.Execute;
   fm_data.Cd_book.Open;
end;

procedure TFm_bookindex.Button3Click(Sender: TObject);
begin
   sql:='select * from book where publish like '+'''%'+edit3.Text+'%''';
   fm_data.Cd_book.Close;
   fm_data.Cd_book.CommandText:=sql;
   fm_data.Cd_book.Execute;
   fm_data.Cd_book.Open;
end;

end.