maxthin.pas

来自「漳大图书馆管理系统利用Delphi6.0和MS Server2000为主要开发工」· PAS 代码 · 共 106 行

unit maxthin;

interface

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

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

var
  Fm_maxindex: TFm_maxindex;
  sql:string;
implementation

uses data;

{$R *.dfm}

procedure TFm_maxindex.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_maxindex.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_maxindex.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_maxindex.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_maxindex.Button2Click(Sender: TObject);
begin
   sql:='select * from mag where auther 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_maxindex.Button3Click(Sender: TObject);
begin
   sql:='select * from mag where publish 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;

end.