unit8.~pas

这是本人网络数据库实习的程序,编程语言选择DELPHI7.0,完全个人编写.本程序一些界面还不够完善,功能不大,还有很多地方需要改进,望有兴趣的朋友一起探讨或通过电子邮箱与我联系!

unit Unit8;

interface

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

type
  Tdadd = class(TForm)
    Edit1: TEdit;
    Edit2: TEdit;
    Label1: TLabel;
    Label2: TLabel;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    Edit3: TEdit;
    Edit4: TEdit;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Button1: TButton;
    Button2: TButton;
    ComboBox3: TComboBox;
    Label7: TLabel;
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  dadd: Tdadd;

implementation
   uses Unit2;
{$R *.dfm}

procedure Tdadd.Button2Click(Sender: TObject);
begin
  dadd.Close;
  main.ADOquery1.SQL.Clear;
  main.ADOQuery1.SQL.Add('select * from 报刊信息');
  main.ADOQuery1.Open;
  main.Show;


end;

procedure Tdadd.Button1Click(Sender: TObject);
begin
  if edit1.Text<>'' then
    begin
    main.adotable1.First;
    while not main.adotable1.Eof do
      begin
      if main.adotable1.FieldByName('报刊代号').AsString=edit1.Text then
        begin
        application.MessageBox('此报刊已存在!','输入错误',0);
        edit1.SetFocus;
        exit;
        end
      else if main.adotable1.FieldByName('报刊名称').AsString=edit2.Text then
        begin
        application.MessageBox('此报刊已存在!','输入错误',0);
        edit2.SetFocus;
        exit;
        end;
      main.adotable1.Next;
      end;
    main.adotable1.Open;
    main.adotable1.Append;
    main.adotable1.FieldByName('报刊代号').AsString:=edit1.Text;
    main.adotable1.FieldByName('报刊名称').AsString:=edit2.Text;
    main.adotable1.FieldByName('刊期').AsString:=combobox1.Text;
    main.adotable1.FieldByName('整订期').AsString:=combobox2.Text;
    main.adotable1.FieldByName('整订价').AsCurrency:=strtofloat(edit3.Text);
    main.adotable1.FieldByName('全年价').AsCurrency:=strtofloat(edit4.Text);
    main.adotable1.FieldByName('所属类型').AsString:=combobox3.Text;
    main.adotable1.Post;
    main.adotable1.Close;
    if application.MessageBox('录入成功!是否继续录入信息?','提示',1)=1  then
      begin
      edit1.Text:='';edit2.Text:='';edit3.Text:='';edit4.Text:='';edit1.SetFocus;
      end
    else
      begin
      dadd.Close;
      main.ADOquery1.SQL.Clear;
      main.ADOQuery1.SQL.Add('select * from 报刊信息');
      main.ADOQuery1.Open;
      main.Show;
     
      end;
    end
  else
    begin
    showmessage('报刊代号不能为空!');
    edit1.SetFocus;
    end;
end;

end.