⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 readerq.pas

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

interface

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

type
  TForm6 = class(TForm)
    GroupBox1: TGroupBox;
    Image1: TImage;
    GroupBox2: TGroupBox;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    GroupBox3: TGroupBox;
    GroupBox4: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Label4: TLabel;
    Edit4: TEdit;
    Button1: TButton;
    GroupBox5: TGroupBox;
    GroupBox6: TGroupBox;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    RadioButton3: TRadioButton;
    Edit5: TEdit;
    Edit6: TEdit;
    ComboBox1: TComboBox;
    Button2: TButton;
    Button3: TButton;
    Panel1: TPanel;
    Label5: TLabel;
    Edit7: TEdit;
    Label6: TLabel;
    Edit8: TEdit;
    Label7: TLabel;
    Edit9: TEdit;
    Label8: TLabel;
    Edit10: TEdit;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    DBGrid2: TDBGrid;
    GroupBox7: TGroupBox;
    GroupBox8: TGroupBox;
    GroupBox9: TGroupBox;
    GroupBox10: TGroupBox;
    DBGrid3: TDBGrid;
    Label9: TLabel;
    Edit11: TEdit;
    Label10: TLabel;
    Edit12: TEdit;
    Label11: TLabel;
    Edit13: TEdit;
    Label12: TLabel;
    Edit14: TEdit;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    Button7: TButton;
    Button8: TButton;
    procedure DBGrid1CellClick(Column: TColumn);
    procedure TabSheet1Show(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button2Click(Sender: TObject);
    procedure DBGrid2CellClick(Column: TColumn);
    procedure Button3Click(Sender: TObject);
    procedure TabSheet2Show(Sender: TObject);
    procedure DBGrid3CellClick(Column: TColumn);
    procedure TabSheet3Show(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form6: TForm6;

implementation
Uses main;
{$R *.dfm}



procedure TForm6.DBGrid1CellClick(Column: TColumn);
begin
Edit1.Text:=Adoquery1.fieldbyname('ReaderID').AsString;
Edit2.Text:=Adoquery1.fieldbyname('Name').AsString;
Edit3.Text:=Adoquery1.fieldbyname('Sex').AsString;
Edit4.Text:=Adoquery1.fieldbyname('PersonID').AsString;
end;

procedure TForm6.TabSheet1Show(Sender: TObject);
begin
Adoquery1.Active:=True;
Adoquery1.SQL.Clear;
Adoquery1.SQL.Add('select * from Reader');
Adoquery1.Open;

end;

procedure TForm6.Button1Click(Sender: TObject);
begin
Form6.Close;
Form2.Show;
end;

procedure TForm6.FormClose(Sender: TObject; var Action: TCloseAction);
begin
form2.Show;
end;

procedure TForm6.Button2Click(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 Reader where ReaderID='''+Edit5.Text+'''';
     adoquery1.Open;
     if adoquery1.RecordCount=0 then
        begin showmessage('没有符合条件的记录!!');
              edit5.Text:='';
              Edit7.Text:='';
              Edit8.Text:='';
              Edit9.Text:='';
              Edit10.Text:='';

         end
       else
        begin
            showmessage('该记录已经找到了!!');
            edit5.Text:='';
            Edit7.Text:=Adoquery1.fieldbyname('ReaderID').AsString;
            Edit8.Text:=Adoquery1.fieldbyname('Name').AsString;
            Edit9.Text:=Adoquery1.fieldbyname('Sex').AsString;
            Edit10.Text:=Adoquery1.fieldbyname('PersonID').AsString;
       end;
    end;

    if radiobutton2.Checked then
   begin
     adoquery1.Active:=true;
     adoquery1.Edit;
     adoquery1.Close;
     adoquery1.SQL.Clear;
     adoquery1.SQL.Text:='select * from Reader where Name='''+edit6.Text+'''';
     adoquery1.Open;
     if adoquery1.RecordCount=0 then
        begin
        showmessage('没有符合条件的记录!!');
        edit6.Text:='';
        Edit7.Text:='';
        Edit8.Text:='';
        Edit9.Text:='';
        Edit10.Text:='';
        end
       else
        begin
            showmessage('该记录已经找到了');
            edit6.Text:='';
            Edit7.Text:=Adoquery1.fieldbyname('ReaderID').AsString;
            Edit8.Text:=Adoquery1.fieldbyname('Name').AsString;
            Edit9.Text:=Adoquery1.fieldbyname('Sex').AsString;
            Edit10.Text:=Adoquery1.fieldbyname('PersonID').AsString;

        end;
    end;
 if radiobutton3.Checked then
   begin
     adoquery1.Active:=true;
     adoquery1.Edit;
     adoquery1.Close;
     adoquery1.SQL.Clear;
     adoquery1.SQL.Text:='select * from Reader where Sex='''+Combobox1.Text+'''';
     adoquery1.Open;
     if adoquery1.RecordCount=0 then
        begin
        showmessage('没有符合条件的记录!!');
        Combobox1.Text:='';
        Edit7.Text:='';
        Edit8.Text:='';
        Edit9.Text:='';
        Edit10.Text:='';
        end
       else
        begin
            showmessage('该记录已经找到了');
            Combobox1.Text:='';
            Edit7.Text:=Adoquery1.fieldbyname('ReaderID').AsString;
            Edit8.Text:=Adoquery1.fieldbyname('Name').AsString;
            Edit9.Text:=Adoquery1.fieldbyname('Sex').AsString;
            Edit10.Text:=Adoquery1.fieldbyname('PersonID').AsString;

        end;
    end;
end;

procedure TForm6.DBGrid2CellClick(Column: TColumn);
begin
Edit7.Text:=Adoquery1.fieldbyname('ReaderID').AsString;
Edit8.Text:=Adoquery1.fieldbyname('Name').AsString;
Edit9.Text:=Adoquery1.fieldbyname('Sex').AsString;
Edit10.Text:=Adoquery1.fieldbyname('PersonID').AsString;
end;

procedure TForm6.Button3Click(Sender: TObject);
begin
Form6.Close;
Form2.Show;
end;

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

procedure TForm6.DBGrid3CellClick(Column: TColumn);
begin
Edit11.Text:=Adoquery1.fieldbyname('ReaderID').AsString;
Edit12.Text:=Adoquery1.fieldbyname('Name').AsString;
Edit13.Text:=Adoquery1.fieldbyname('Sex').AsString;
Edit14.Text:=Adoquery1.fieldbyname('PersonID').AsString;
end;

procedure TForm6.TabSheet3Show(Sender: TObject);
begin
Adoquery1.Active:=true;
Adoquery1.SQL.Clear;
Adoquery1.SQL.Add('select * from Reader');
Adoquery1.Open;
end;

procedure TForm6.Button4Click(Sender: TObject);
begin
Form6.Close;
Form2.Show;
end;

procedure TForm6.Button5Click(Sender: TObject);
begin
Adoquery1.First;
Edit11.Text:=Adoquery1.fieldbyname('ReaderID').AsString;
Edit12.Text:=Adoquery1.fieldbyname('Name').AsString;
Edit13.Text:=Adoquery1.fieldbyname('Sex').AsString;
Edit14.Text:=Adoquery1.fieldbyname('PersonID').AsString;
end;

procedure TForm6.Button6Click(Sender: TObject);
begin
Adoquery1.Next;
Edit11.Text:=Adoquery1.fieldbyname('ReaderID').AsString;
Edit12.Text:=Adoquery1.fieldbyname('Name').AsString;
Edit13.Text:=Adoquery1.fieldbyname('Sex').AsString;
Edit14.Text:=Adoquery1.fieldbyname('PersonID').AsString;
end;

procedure TForm6.Button7Click(Sender: TObject);
begin
Adoquery1.Prior;
Edit11.Text:=Adoquery1.fieldbyname('ReaderID').AsString;
Edit12.Text:=Adoquery1.fieldbyname('Name').AsString;
Edit13.Text:=Adoquery1.fieldbyname('Sex').AsString;
Edit14.Text:=Adoquery1.fieldbyname('PersonID').AsString;
end;

procedure TForm6.Button8Click(Sender: TObject);
begin
Adoquery1.Last;
Edit11.Text:=Adoquery1.fieldbyname('ReaderID').AsString;
Edit12.Text:=Adoquery1.fieldbyname('Name').AsString;
Edit13.Text:=Adoquery1.fieldbyname('Sex').AsString;
Edit14.Text:=Adoquery1.fieldbyname('PersonID').AsString;
end;

end.

⌨️ 快捷键说明

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