unit11.~pas

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

unit Unit11;

interface

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

type
  TclassForm = class(TForm)
    DataSource1: TDataSource;
    Table1: TTable;
    Query1: TQuery;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    Edit1: TEdit;
    SpeedButton6: TSpeedButton;
    GroupBox1: TGroupBox;
    SpeedButton7: TSpeedButton;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Label4: TLabel;
    Edit4: TEdit;
    Label5: TLabel;
    Edit5: TEdit;
    procedure SpeedButton6Click(Sender: TObject);
    procedure SpeedButton7Click(Sender: TObject);
    procedure SpeedButton5Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  classForm: TclassForm;

implementation

{$R *.dfm}

procedure TclassForm.SpeedButton6Click(Sender: TObject);
begin
if edit1.Text =''then
 begin
 showmessage('请输入班级名');
 end
else
  query1.SQL.Clear;
  query1.SQL.Add('select * from 班级信息');
  query1.SQL.Add('where 班级名='''+edit1.Text+'''');
  query1.Close;
  query1.open;
end;
procedure TclassForm.SpeedButton7Click(Sender: TObject);
begin
query1.SQL.Clear;
query1.SQL.Add('select * from 班级信息');
query1.Close;
query1.Open;
end;

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

procedure TclassForm.SpeedButton1Click(Sender: TObject);
begin
   if edit2.Text =''then
    begin
     showmessage('班级名不能为空!');
    end
   else
   with table1 do
    begin
     if locate('班级名;班主任',vararrayof([edit2.Text,edit3.text]),[]) then
      begin
        showmessage('班级名已经存在!');
      end
     else
     insertrecord([edit2.Text,edit3.Text,edit4.Text,edit5.text]);
     showmessage('成功添加!');
     edit2.Text:='';
     edit3.Text:='';
    end;
     
end;

procedure TclassForm.SpeedButton2Click(Sender: TObject);
var
bjm:string;
begin
  if table1.Locate('班级名',vararrayof([edit2.text]),[])then
   begin
   bjm:=table1.FieldValues['班级名'];
    if edit2.Text =bjm then
      begin
        if edit2.text<>''then
         begin
           table1.Edit;
           table1.FieldByName('班主任').AsString:=edit3.Text;
           table1.FieldByName('班级人数').AsString:=edit4.text;
            table1.FieldByName('班长').AsString:=edit5.text;
            table1.Post;
            showmessage('成功更改!');
         end
         else
          showmessage('班级名不能为空!');
      end
    else
      showmessage('不是有效的班级名!');
   end
 else
  showmessage('没有该班级名!');
end;

procedure TclassForm.SpeedButton3Click(Sender: TObject);
begin
 if edit2.Text ='' then
 begin
  showmessage('请输入要删除的班级名.');
  exit;
 end
else
with table1 do
 if not locate('班级名',vararrayof([edit2.text]),[])then
   begin
    showmessage('班级名不存在!');
    exit;
   end
 else
query1.SQL.Clear;
query1.SQL.Add('delete from 班级信息');
query1.SQL.Add('where 班级名='''+edit2.Text+'''');
query1.Close;
query1.ExecSQL;
showmessage('已删除!');
end;

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

end.