unit3.pas

学生成绩管理系统

unit Unit3;

interface

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

type
  TForm3 = class(TForm)
    Label1: TLabel;
    DBGrid1: TDBGrid;
    Edit1: TEdit;
    Button1: TButton;
    Label2: TLabel;
    Label3: TLabel;
    Button2: TButton;
    Label4: TLabel;
    Label5: TLabel;
    Edit2: TEdit;
    Button3: TButton;
    Button4: TButton;
    Label6: TLabel;
    Label7: TLabel;
    Edit3: TEdit;
    DBNavigator1: TDBNavigator;
    Label8: TLabel;
    Edit4: TEdit;
    Edit5: TEdit;
    Table1: TTable;
    DataSource1: TDataSource;
    Button5: TButton;
    Button6: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Edit1Change(Sender: TObject);
    procedure Edit4Change(Sender: TObject);
    procedure Edit2Change(Sender: TObject);
    procedure Edit5Change(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form3: TForm3;

implementation

uses Unit1;

{$R *.dfm}

procedure TForm3.Button1Click(Sender: TObject);
var
i1:integer;
begin
if (Edit1.Text='') or (length(edit1.text)<>13) then
begin
showmessage('学号必须是13位数字');
exit;
end;
table1.Filter:='学号='+''''+edit1.Text+'''';
table1.Filtered:=true;
table1.Open;
i1:=table1.recordcount;
edit3.text:=inttostr(i1);
edit1.Text:='';
end;

procedure TForm3.Button2Click(Sender: TObject);
var
i2:integer;
begin
if (Edit4.Text='') or (length(edit4.text)<>6) then
begin
showmessage('班级的格式要类似AC0101');
exit;
end;
table1.Filter:='班级='+''''+edit4.Text+'''';
table1.Filtered:=true;
table1.Open;
i2:=table1.recordcount;
edit3.text:=inttostr(i2);
edit4.Text:='';
end;

procedure TForm3.Button3Click(Sender: TObject);
var
i3:integer;
begin
if (Edit2.Text='') or (length(edit2.text)>8) then
begin
showmessage('名字不能超过四个字');
exit;
end;
table1.Filter:='姓名='+''''+edit2.Text+'''';
table1.Filtered:=true;
table1.Open;
i3:=table1.recordcount;
edit3.text:=inttostr(i3);
edit2.Text:='';
end;

procedure TForm3.Button4Click(Sender: TObject);
var
i4:integer;
begin
if (Edit5.Text='') then
begin
showmessage('请输入正确的科目名称');
exit;
end;
table1.Filter:='科目='+''''+edit5.Text+'''';
table1.Filtered:=true;
table1.Open;
i4:=table1.recordcount;
edit3.text:=inttostr(i4);
edit5.Text:='';
end;

procedure TForm3.Edit1Change(Sender: TObject);
begin
button1.Enabled:=true;
button2.Enabled:=false;
button3.Enabled:=false;
button4.Enabled:=false;
end;

procedure TForm3.Edit4Change(Sender: TObject);
begin
button1.Enabled:=false;
button2.Enabled:=true;
button3.Enabled:=false;
button4.Enabled:=false;
end;

procedure TForm3.Edit2Change(Sender: TObject);
begin
button3.Enabled:=true;
button1.Enabled:=false;
button2.Enabled:=false;
button4.Enabled:=false;
end;

procedure TForm3.Edit5Change(Sender: TObject);
begin
button4.Default:=true;
button1.Default:=false;
button2.Default:=false;
button3.Default:=false;
end;

procedure TForm3.Button5Click(Sender: TObject);
var i5:integer;
begin
   table1.Filter:='成绩<=100';
   table1.Filtered:=true;
   table1.Open;
   i5:=table1.recordcount;
   edit3.text:=inttostr(i5);
   edit5.Text:='';
end;

procedure TForm3.Button6Click(Sender: TObject);
begin
Form3.Hide;
Form1.show;
end;

end.