new_book.~pas

该是一个比较好的图书馆系统,是现在大学生软件课程设计的好模板

unit new_book;

interface

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

type
  Tnewbook = class(TForm)
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Label4: TLabel;
    Edit3: TEdit;
    Label5: TLabel;
    Edit4: TEdit;
    Label6: TLabel;
    Edit5: TEdit;
    Label7: TLabel;
    Edit6: TEdit;
    Label8: TLabel;
    Label9: TLabel;
    ADOCommand1: TADOCommand;
    ADOQuery1: TADOQuery;
    ComboBox1: TComboBox;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    //procedure Button1Click(Sender: TObject);
    //procedure Button2Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  newbook: Tnewbook;

implementation

{$R *.dfm}

procedure Tnewbook.BitBtn1Click(Sender: TObject);
begin
 adoquery1.Close;
 adoquery1.SQL.Clear;
 adoquery1.SQL.Text:='select BookID from Book where BookID='''+edit1.Text+'''';
 adoquery1.Open;
 if adoquery1.FieldByName('BookID').AsString<>'' then
  begin
  showmessage('图书编号不能重复！');
  end
  else
  begin
  if Edit2.Text=''then
  begin
    showmessage('图书编号不能为空！');
  end
  else
    if Edit1.Text='' then
    begin
    showmessage('书名不能为空！');
    end
  else
  begin
  adocommand1.CommandText:='insert Book values('''+edit2.Text+''','''+ComboBox1.Text+''','''+Edit1.Text+''','''+Edit3.Text+''','''+Edit4.Text+''','''+edit5.Text+''','''+Edit6.Text+''',1)' ;
  adocommand1.Execute;
  showmessage('添加成功！');
  //adocommand1.CommandText:='insert login_User values('''+edit2.Text+''',3,'''+edit2.Text+''')' ;
  //adocommand1.Execute;
  //close;
  end
end
end;

procedure Tnewbook.BitBtn2Click(Sender: TObject);
begin
close;
end;

end.