seek_book.~pas

来自「该是一个比较好的图书馆系统,是现在大学生软件课程设计的好模板」· ~PAS 代码 · 共 124 行

unit seek_book;

interface

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

type
  Tseekbook = class(TForm)
    RadioGroup1: TRadioGroup;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    GroupBox2: TGroupBox;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    DBGrid1: TDBGrid;
    Button2: TButton;
    BitBtn1: TBitBtn;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  seekbook: Tseekbook;

implementation

{$R *.dfm}

procedure Tseekbook.Button1Click(Sender: TObject);
begin
if RadioGroup1.ItemIndex=-1 then
 begin
 showmessage('请选择一种查询方式！');
 end
 else
 begin
 if Edit1.Text='' then
   begin
   showmessage('请输入关键字！');
   end
   else
   begin
   if RadioGroup1.ItemIndex=0 then
    begin
    ADOQuery1.Close;
    ADOQuery1.SQL.Clear;
    ADOQuery1.SQL.Text:='select BookName from Book where BookName='''+Edit1.Text+'''';
    ADOQuery1.Open;
    if adoquery1.FieldByName('BookName').AsString='' then
      begin
      showmessage('对不起，未找到该书！');
      end
      else
      begin
      adoquery1.Close;
      adoquery1.SQL.Clear;
      adoquery1.SQL.Text:='select BookID as ''图书编号'',BookName as ''书名'',Type as''类别'',Auther as ''作者'',Public_data ''出版日期'',press ''出版社'',price ''价格'' from Book where BookName='''+Edit1.text+'''';
      adoquery1.Open;
      end;
    end;
    end;
    if RadioGroup1.ItemIndex=1 then
    begin
    ADOQuery1.Close;
    ADOQuery1.SQL.Clear;
    ADOQuery1.SQL.Text:='select BookName from Book where Auther='''+Edit1.Text+'''';
    ADOQuery1.Open;
    if adoquery1.FieldByName('BookName').AsString='' then
      begin
      showmessage('对不起，未找到该书！');
      end
      else
      begin
      adoquery1.Close;
      adoquery1.SQL.Clear;
      adoquery1.SQL.Text:='select BookID as ''图书编号'',BookName as ''书名'',Type as''类别'',Auther as ''作者'',Public_data ''出版日期'',press ''出版社'',price ''价格'' from Book where Auther='''+Edit1.text+'''';
      adoquery1.Open;
      end;
    end;
    if RadioGroup1.ItemIndex=2 then
    begin
    ADOQuery1.Close;
    ADOQuery1.SQL.Clear;
    ADOQuery1.SQL.Text:='select BookName from Book where Type='''+Edit1.Text+'''';
    ADOQuery1.Open;
    if adoquery1.FieldByName('BookName').AsString='' then
      begin
      showmessage('对不起，未找到该书！');
      end
      else
      begin
      adoquery1.Close;
      adoquery1.SQL.Clear;
      adoquery1.SQL.Text:='select BookID as ''图书编号'',BookName as ''书名'',Type as''类别'',Auther as ''作者'',Public_data ''出版日期'',press ''出版社'',price ''价格'' from Book where Type='''+Edit1.text+'''';
      adoquery1.Open;
      end;
    end;
 end;
end;

procedure Tseekbook.Button2Click(Sender: TObject);
begin
close;
end;

procedure Tseekbook.BitBtn1Click(Sender: TObject);
begin
 adoquery1.Close;
 adoquery1.SQL.Clear;
 adoquery1.SQL.Text:='select BookID as ''图书编号'',BookName as ''书名'',Type as''类型'',Auther as ''作者'',Press ''出版社'',Public_data ''出版日期'',price ''价格'' from Book';
 adoquery1.Open;
end;

end.