📄 bookq.pas

📁 图书管理系统(Delphi),可作毕业设计
💻 PAS
字号:
unit Bookq;

interface

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

type
  TForm5 = class(TForm)
    GroupBox1: TGroupBox;
    Image1: TImage;
    Panel1: TPanel;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet4: TTabSheet;
    Panel2: TPanel;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Label4: TLabel;
    Edit4: TEdit;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    Label5: TLabel;
    Edit5: TEdit;
    BitBtn1: TBitBtn;
    GroupBox2: TGroupBox;
    TabSheet2: TTabSheet;
    GroupBox3: TGroupBox;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    RadioButton3: TRadioButton;
    RadioButton4: TRadioButton;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit9: TEdit;
    Button1: TButton;
    Button2: TButton;
    Panel3: TPanel;
    Panel4: TPanel;
    DBGrid2: TDBGrid;
    Label6: TLabel;
    Edit10: TEdit;
    Label7: TLabel;
    Edit11: TEdit;
    Label8: TLabel;
    Edit12: TEdit;
    Label9: TLabel;
    Edit13: TEdit;
    Label10: TLabel;
    Edit14: TEdit;
    GroupBox4: TGroupBox;
    GroupBox5: TGroupBox;
    GroupBox6: TGroupBox;
    DBGrid3: TDBGrid;
    Label11: TLabel;
    Edit15: TEdit;
    Label12: TLabel;
    Edit16: TEdit;
    Label13: TLabel;
    Edit17: TEdit;
    Label14: TLabel;
    Edit18: TEdit;
    Label15: TLabel;
    Edit19: TEdit;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    Button7: TButton;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure BitBtn1Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure DBGrid2CellClick(Column: TColumn);
    procedure Button2Click(Sender: TObject);
    procedure TabSheet1Show(Sender: TObject);
    procedure TabSheet2Show(Sender: TObject);
    procedure DBGrid3CellClick(Column: TColumn);
    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
  Form5: TForm5;

implementation
Uses main;
{$R *.dfm}

procedure TForm5.FormClose(Sender: TObject; var Action: TCloseAction);
begin
Form2.Show;
end;

procedure TForm5.DBGrid1CellClick(Column: TColumn);
begin
Edit1.Text:=Adoquery1.fieldbyname('Booknum').AsString;
Edit2.Text:=Adoquery1.fieldbyname('Bookname').AsString;
Edit3.Text:=Adoquery1.fieldbyname('Author').AsString;
Edit4.Text:=Adoquery1.fieldbyname('Press').AsString;
Edit5.Text:=Adoquery1.fieldbyname('Price').AsString;
end;

procedure TForm5.BitBtn1Click(Sender: TObject);
begin
Form5.Close;
Form2.Show;
end;

procedure TForm5.Button1Click(Sender: TObject);
begin
Adoquery1.Edit;
  if radiobutton1.Checked then
   begin
     adoquery1.Active:=true;
     adoquery1.Edit;
     adoquery1.Close;
     adoquery1.SQL.Clear;
     adoquery1.SQL.Text:='select * from Book where Booknum='''+Edit6.Text+'''';
     adoquery1.Open;
     if adoquery1.RecordCount=0 then
        begin showmessage('没有符合条件的记录!!');
              edit6.Text:='';
         end
       else
        begin
            showmessage('该记录已经找到了!!');
            edit6.Text:='';
            Edit10.Text:=Adoquery1.fieldbyname('Booknum').AsString;
            Edit11.Text:=Adoquery1.fieldbyname('Bookname').AsString;
            Edit12.Text:=Adoquery1.fieldbyname('Author').AsString;
            Edit13.Text:=Adoquery1.fieldbyname('Press').AsString;
            Edit14.Text:=Adoquery1.fieldbyname('Price').AsString;

        end;
    end;

    if radiobutton2.Checked then
   begin
     adoquery1.Active:=true;
     adoquery1.Edit;
     adoquery1.Close;
     adoquery1.SQL.Clear;
     adoquery1.SQL.Text:='select * from Book where Bookname='''+edit7.Text+'''';
     adoquery1.Open;
     if adoquery1.RecordCount=0 then
        begin
        showmessage('没有符合条件的记录!!');
        edit7.Text:='';
        Edit10.Text:='';
        Edit11.Text:='';
        Edit12.Text:='';
        Edit13.Text:='';
        Edit14.Text:='';
         end
       else
        begin
            showmessage('该记录已经找到了');
            edit7.Text:='';
            Edit10.Text:=Adoquery1.fieldbyname('Booknum').AsString;
            Edit11.Text:=Adoquery1.fieldbyname('Bookname').AsString;
            Edit12.Text:=Adoquery1.fieldbyname('Author').AsString;
            Edit13.Text:=Adoquery1.fieldbyname('Press').AsString;
            Edit14.Text:=Adoquery1.fieldbyname('Price').AsString;
        end;
    end;
 if radiobutton3.Checked then
   begin
     adoquery1.Active:=true;
     adoquery1.Edit;
     adoquery1.Close;
     adoquery1.SQL.Clear;
     adoquery1.SQL.Text:='select * from Book where Author='''+Edit8.Text+'''';
     adoquery1.Open;
     if adoquery1.RecordCount=0 then
        begin
        showmessage('没有符合条件的记录!!');
        edit8.Text:='';
        Edit10.Text:='';
        Edit11.Text:='';
        Edit12.Text:='';
        Edit13.Text:='';
        Edit14.Text:='';
         end
       else
        begin
            showmessage('该记录已经找到了');
            edit8.Text:='';
            Edit10.Text:=Adoquery1.fieldbyname('Booknum').AsString;
            Edit11.Text:=Adoquery1.fieldbyname('Bookname').AsString;
            Edit12.Text:=Adoquery1.fieldbyname('Author').AsString;
            Edit13.Text:=Adoquery1.fieldbyname('Press').AsString;
            Edit14.Text:=Adoquery1.fieldbyname('Price').AsString;
        end;
    end;
     if radiobutton4.Checked then
   begin
     adoquery1.Active:=true;
     adoquery1.Edit;
     adoquery1.Close;
     adoquery1.SQL.Clear;
     adoquery1.SQL.Text:='select * from Book where Press like'''+edit9.Text+'''';
     adoquery1.Open;
     if adoquery1.RecordCount=0 then
        begin
        showmessage('没有符合条件的记录!!');
        edit9.Text:='';
        Edit10.Text:='';
        Edit11.Text:='';
        Edit12.Text:='';
        Edit13.Text:='';
        Edit14.Text:='';
         end
       else
        begin
            showmessage('该记录已经找到了');
            edit9.Text:='';
            Edit10.Text:=Adoquery1.fieldbyname('Booknum').AsString;
            Edit11.Text:=Adoquery1.fieldbyname('Bookname').AsString;
            Edit12.Text:=Adoquery1.fieldbyname('Author').AsString;
            Edit13.Text:=Adoquery1.fieldbyname('Press').AsString;
            Edit14.Text:=Adoquery1.fieldbyname('Price').AsString;
        end;
    end;
end;

procedure TForm5.DBGrid2CellClick(Column: TColumn);
begin
Edit10.Text:=Adoquery1.fieldbyname('Booknum').AsString;
Edit11.Text:=Adoquery1.fieldbyname('Bookname').AsString;
Edit12.Text:=Adoquery1.fieldbyname('Author').AsString;
Edit13.Text:=Adoquery1.fieldbyname('Press').AsString;
Edit14.Text:=Adoquery1.fieldbyname('Price').AsString;
end;

procedure TForm5.Button2Click(Sender: TObject);
begin
Form5.Close;
Form2.Show;
end;

procedure TForm5.TabSheet1Show(Sender: TObject);
begin
Adoquery1.Active:=True;
Adoquery1.SQL.Clear;
Adoquery1.SQL.Add('select Booknum,Bookname,Author,Press,Price from Book');
Adoquery1.Open;
end;

procedure TForm5.TabSheet2Show(Sender: TObject);
begin
Adoquery1.Active:=True;
Adoquery1.Open;
end;

procedure TForm5.DBGrid3CellClick(Column: TColumn);
begin
Edit15.Text:=Adoquery1.fieldbyname('Booknum').AsString;
Edit16.Text:=Adoquery1.fieldbyname('Bookname').AsString;
Edit17.Text:=Adoquery1.fieldbyname('Author').AsString;
Edit18.text:=Adoquery1.fieldbyname('Press').AsString;
Edit19.Text:=Adoquery1.fieldbyname('Price').AsString;

end;

procedure TForm5.Button3Click(Sender: TObject);
begin
form5.Close;
Form2.Show;
end;

procedure TForm5.Button4Click(Sender: TObject);
begin
Adoquery1.First;
Edit15.Text:=Adoquery1.fieldbyname('Booknum').AsString;
Edit16.Text:=Adoquery1.fieldbyname('Bookname').AsString;
Edit17.Text:=Adoquery1.fieldbyname('Author').AsString;
Edit18.Text:=Adoquery1.fieldbyname('Press').AsString;
Edit19.Text:=Adoquery1.fieldbyname('Price').AsString;
end;

procedure TForm5.Button5Click(Sender: TObject);
begin
Adoquery1.Next;
Edit15.Text:=Adoquery1.fieldbyname('Booknum').AsString;
Edit16.Text:=Adoquery1.fieldbyname('Bookname').AsString;
Edit17.Text:=Adoquery1.fieldbyname('Author').AsString;
Edit18.Text:=Adoquery1.fieldbyname('Press').AsString;
Edit19.Text:=Adoquery1.fieldbyname('Price').AsString;
end;

procedure TForm5.Button6Click(Sender: TObject);
begin
Adoquery1.Prior;
Edit15.Text:=Adoquery1.fieldbyname('Booknum').AsString;
Edit16.Text:=Adoquery1.fieldbyname('Bookname').AsString;
Edit17.Text:=Adoquery1.fieldbyname('Author').AsString;
Edit18.Text:=Adoquery1.fieldbyname('Press').AsString;
Edit19.Text:=Adoquery1.fieldbyname('Price').AsString;
end;

procedure TForm5.Button7Click(Sender: TObject);
begin
Adoquery1.Last;
Edit15.Text:=Adoquery1.fieldbyname('Booknum').AsString;
Edit16.Text:=Adoquery1.fieldbyname('Bookname').AsString;
Edit17.Text:=Adoquery1.fieldbyname('Author').AsString;
Edit18.Text:=Adoquery1.fieldbyname('Press').AsString;
Edit19.Text:=Adoquery1.fieldbyname('Price').AsString;
end;

end.
💿 文件大小 764 K
👤 上传用户 wangdatouay
📂 所属分类 Delphi控件源码
🏷️ 相关标签

#Delphi #图书管理 #毕业设计
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -