unit6.pas

delphi开发的图书馆管理系统

unit Unit6;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, dem, jpeg, ExtCtrls;

type
  TForm6 = class(TForm)
    GroupBox1: TGroupBox;
    Button1: TButton;
    Button2: TButton;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Button3: TButton;
    Image1: TImage;
    Button4: TButton;
    Button5: TButton;
    procedure Button3Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form6: TForm6;
var
  a:integer=1;
  sql:string;

implementation

{$R *.dfm}

procedure TForm6.Button3Click(Sender: TObject);
begin
close;
end;

procedure TForm6.Button2Click(Sender: TObject);
begin
edit1.Clear;
edit2.Clear;
edit3.Clear;
edit4.Clear;
edit5.Clear;
end;

procedure TForm6.Button1Click(Sender: TObject);
begin
if a=1 then
begin
if edit1.Text=''then
begin
showmessage('请你输入的书号!');
abort;
end;
if edit2.Text=''then
begin
showmessage('请你输入的书名!');
abort;
end;
if edit3.Text=''then
begin
showmessage('请你输入的作者!');
abort;
end;
if edit4.Text=''then
begin
showmessage('请你输入的数量!');
abort;
end;
if edit5.Text=''then
begin
showmessage('请你输入的定价!');
abort;
end;
dem.dm.conn.Open;
dem.dm.addbook.Append;
dem.dm.addbook.FieldByName('bno').AsString:=edit1.Text;
dem.dm.addbook.FieldByName('bname').AsString:=edit2.Text;
dem.dm.addbook.FieldByName('author').AsString:=edit3.Text;
dem.dm.addbook.FieldByName('leftno').AsString:=edit4.Text;
dem.dm.addbook.FieldByName('price').AsString:=edit5.Text;
dem.dm.addbook.Post;
showmessage('图书信息录入成功!') ;
abort;
end;
if a=2 then
begin
if edit1.Text=''then
begin
showmessage('请你输入的书号!');
abort;
end;

dem.dm.query2.Close;
dem.dm.query2.SQL.Clear;
sql:='delete from book where bno='''+edit1.Text+'''';
dem.dm.query2.SQL.Add(sql);
dem.dm.query2.ExecSQL;

showmessage('图书信息注销成功!') ;
end;

end;


procedure TForm6.Button4Click(Sender: TObject);
begin
a:=1;
groupbox1.Caption:='新书信息录入';
groupbox1.Color:=clsilver;
end;

procedure TForm6.Button5Click(Sender: TObject);
begin
a:=2;
groupbox1.Caption:='旧书信息注销';
groupbox1.Color:=clfuchsia;
end;

end.