deletebook.pas

图书馆管理系统设计用delphi开发的系统

unit deletebook;

interface

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

type
  TdeletebookForm4 = class(TForm)
    DBGrid1: TDBGrid;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    book: TEdit;
    Button1: TButton;
    Panel2: TPanel;
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  deletebookForm4: TdeletebookForm4;

implementation

uses module;

{$R *.dfm}

procedure TdeletebookForm4.Button1Click(Sender: TObject);
begin
  with  datamodule1.bookADOQuery1 do
  begin
   close;
   sql.Clear;
     sql.Add('delete from books');
   sql.Add(' where 书号='''+book.text+'''');
   execsql;
   close;
   sql.Clear;
   sql.add('select * from books');
   open;

end;
end;

end.