unit5.pas

使用delphi编写的图书管理系统：实现查询

unit Unit5;

interface

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

type
  Ttscj = class(TForm)
    BitBtn1: TBitBtn;
    GroupBox1: TGroupBox;
    GroupBox2: TGroupBox;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    DateTimePicker1: TDateTimePicker;
    procedure BitBtn1Click(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  tscj: Ttscj;

implementation

{$R *.dfm}

procedure Ttscj.BitBtn1Click(Sender: TObject);
begin
close
end;

procedure Ttscj.DBGrid1CellClick(Column: TColumn);
begin
edit6.Text:=dbgrid1.Fields[0].AsString
end;

procedure Ttscj.BitBtn2Click(Sender: TObject);
var a,b,c,d,e,f:string;
begin
a:=edit1.Text+'%';
b:=edit2.Text+'%';
c:=edit3.Text+'%';
d:=edit4.Text+'%';
e:=edit5.Text+'%';
f:='在库';
with adoquery1 do
begin
close;
sql.Clear;
sql.Add('select tsbm.sh,tsbm.sm,tsbm.lb,tsbm.zz,tsbm.cbs from tsbm,tsjy');
sql.Add('where (tsbm.sh=tsjy.sh) and (tsjy.jcbz=:fn)and (tsbm.sh like :an)and(tsbm.sm like :bn)and(tsbm.lb like :cn)and(tsbm.zz like :dn)and(tsbm.cbs like :en)');
sql.Add('order by tsbm.sh');
Parameters.ParamByName('fn').Value:=f;
parameters.ParamByName('an').Value:=a;
Parameters.ParamByName('bn').Value:=b;
parameters.ParamByName('cn').Value:=c;
Parameters.ParamByName('dn').Value:=d;
parameters.ParamByName('en').Value:=e;
prepared;
open;
end;
edit1.Text:='';
edit2.Text:='';
edit3.Text:='';
edit4.Text:='';
edit5.Text:='';
end;
procedure Ttscj.BitBtn3Click(Sender: TObject);
var a,b,c,d,e:string;
begin
a:=edit6.Text;
b:=edit7.Text;
c:=datetostr(DateTimePicker1.Date);
d:='借出';
e:='在库';
with adoquery1 do
begin
close;
sql.Clear;
sql.Add('update tsjy');
sql.Add('set jcbz=:dn,jszh=:bn,jcrq=:cn');
sql.Add('where sh=:an');
Parameters.ParamByName('an').Value:=a;
Parameters.ParamByName('cn').Value:=c;
Parameters.ParamByName('bn').Value:=b;
Parameters.ParamByName('dn').Value:=d;
prepared;
ExecSQL;
end;
with adoquery1 do
begin
close;
sql.Clear;
sql.Add('select tsbm.sh,tsbm.sm,tsbm.lb,tsbm.zz,tsbm.cbs from tsbm,tsjy');
sql.Add('where (tsbm.sh=tsjy.sh) and (tsjy.jcbz=:en)');
sql.Add('order by tsbm.sh');
parameters.ParamByName('en').value:=e;
prepared;
open;
end;
edit6.Text:='';
edit7.Text:='';
end;

end.