unit7.~pas

上次我同样上传了个score-manager

unit Unit7;

interface

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

type
  Tinsertform = class(TForm)
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Label4: TLabel;
    Edit4: TEdit;
    Label5: TLabel;
    Edit5: TEdit;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    DataSource1: TDataSource;
    Table1: TTable;
    UpdateSQL1: TUpdateSQL;
    SpeedButton6: TSpeedButton;
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton5Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton6Click(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  insertform: Tinsertform;

implementation

{$R *.dfm}



procedure Tinsertform.SpeedButton3Click(Sender: TObject);
begin
table1.Active:=not table1.Active;
end;

procedure Tinsertform.SpeedButton1Click(Sender: TObject);
begin
 table1.Edit;
  if (edit1.Text = '') and (edit2.Text ='')and(edit3.Text ='')and (edit4.Text ='')and(edit5.Text ='') then
  messagedlg('没有输入新记录的字段值!',mterror,[mbcancel],0)
  else
  {speedbutton1.Enabled:=true;
  speedbutton2.Enabled:=true;
  speedbutton6.Enabled:=true;}
  with table1 do
   begin
    if locate('学号;课程号',vararrayof([edit1.Text,edit3.text]),[]) then
    begin
    messagedlg('已经存在这条记录!',mterror,[mbcancel],0)
    end
    else
    insertrecord([edit1.text,edit2.Text,edit3.Text,edit4.Text,edit5.Text]);
    showmessage('已成功添加!');
    edit3.Text:='';
    edit4.Text:='';
    edit5.Text:='';
   end;
end;

procedure Tinsertform.SpeedButton5Click(Sender: TObject);
begin
close;
end;

procedure Tinsertform.SpeedButton2Click(Sender: TObject);
var
finded:boolean;
begin
  with table1 do
  begin
   finded:=false;
   first;
   repeat
     if locate('学号;课程号;课程名',vararrayof([edit1.Text,edit3.Text,edit4.Text]),[]) then
      begin
       delete;
       showmessage('删除成功!');
       finded:=true;
       exit;
      end
     else
     next;
   until((finded)or(eof));
   if not finded then
   showmessage('无此记录!');
  end;
end;

procedure Tinsertform.SpeedButton6Click(Sender: TObject);
begin
with table1 do
 begin
  if(edit1.Text ='')and(edit3.Text ='') then
    begin
     showmessage('没有要更新的记录!');
     exit;
    end;
  if locate('学号;课程号',vararrayof([edit1.Text,edit3.Text]),[])then
    begin
     edit;
     fieldbyname('成绩').AsString:=edit5.Text;
     post;
     showmessage('更新成功!');
    end
  else
  showmessage('无此记录!');
 end;
end;

procedure Tinsertform.SpeedButton4Click(Sender: TObject);
begin
edit1.text:='';
edit2.Text :='';
edit3.Text :='';
edit4.Text :='';
edit5.Text :='';
end;

procedure Tinsertform.FormClose(Sender: TObject; var Action: TCloseAction);
begin
action:=cafree;
end;

end.