unit8.pas

一个学生管理系统 这是我将自己sql2000版的东东转为access数据库的简化版本

unit Unit8;

interface

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

type
  Tsskxxcx = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    FlatSpeedButton1: TFlatSpeedButton;
    procedure FormShow(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FlatSpeedButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  sskxxcx: Tsskxxcx;

implementation

{$R *.dfm} uses datamodule, Unit9;

procedure Tsskxxcx.FormShow(Sender: TObject);
begin
label3.Caption:='';
with dm.ADOQuery6 do
  begin
  close;
  sql.Clear;
  sql.Add('select count(a.sslh) as sslhcount from (select distinct sslh from sskxx) as a ');
  open;
  label3.Caption:=dm.ADOQuery6.Fields[0].AsString;
  end;
with dm.ADOQuery6 do
  begin
  close;
  sql.Clear;
  sql.Add('select count(a.ssh) as sshcount from (select distinct ssh from sskxx) as a ');
  open;
  label4.Caption:=dm.ADOQuery6.Fields[0].AsString;
  end;

with dm.ADOQuery6 do
  begin
  close;
  sql.Clear;
  sql.Add('select count(a.xh) as stucount from (select distinct xh from xskxx) as a ');
  open;
  label6.Caption:=dm.ADOQuery6.Fields[0].AsString;
  end;

with dm.ADOQuery6 do
  begin
  close;
  sql.Clear;
  sql.Add('select count(a.xh) as sturzcount from (select distinct xh from zs) as a ');
  open;
  label8.Caption:=dm.ADOQuery6.Fields[0].AsString;
  end;
  sjcx.Close;
end;

procedure Tsskxxcx.FormClose(Sender: TObject; var Action: TCloseAction);
begin
sjcx.Close;
end;

procedure Tsskxxcx.FlatSpeedButton1Click(Sender: TObject);
begin
close;

end;

end.