unit3.pas

这是一个关于delphi数据库方面的源程序

unit Unit3;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, DBTables, DBCtrls, StdCtrls, Unit4, Unit5, Unit6, Unit7;

type
  TFormMaster = class(TForm)
    Button2: TButton;
    Button3: TButton;
    DataSource1: TDataSource;
    DBLookupComboBox1: TDBLookupComboBox;
    Table1: TTable;
    Button4: TButton;
    Button1: TButton;
    Button5: TButton;
    procedure Button3Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Init;
    procedure Button1Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FormMaster: TFormMaster;

implementation

{$R *.dfm}

procedure TFormMaster.Button3Click(Sender: TObject);
var
  id :string;
begin
  if DBLookupComboBox1.Text='' then
  begin
    ShowMessage('请选择课程');
    Exit;
  end;
  id := Table1.Lookup('课程名称',DBLookupComboBox1.Text,'课程编号');
  FormRep.Query1.ParamByName('id').AsString := id;
  FormRep.Query1.Open;
  FormRep.QRSysData1.Text := DBLookupComboBox1.Text + '课程选课学生报表';
  FormRep.QuickRep1.Preview;
  FormRep.Query1.Close;
end;

procedure TFormMaster.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Table1.Close;
  Application.Terminate;
end;

procedure TFormMaster.Init;
begin
  Table1.Open;
end;

procedure TFormMaster.Button1Click(Sender: TObject);
begin
  FormRep.Query1.ParamByName('id').AsString := '%';
  FormRep.Query1.Open;
  FormRep.QRSysData1.Text := '所有课程选课学生报表';
  FormRep.QuickRep1.Preview;
  FormRep.Query1.Close;
end;

procedure TFormMaster.Button4Click(Sender: TObject);
begin
  FormChart.DecisionQuery1.Open;
  FormChart.ShowModal;
  Formchart.DecisionQuery1.Close;
end;

procedure TFormMaster.Button2Click(Sender: TObject);
begin
  FormChPwd.User := '0000';
  FormChPwd.ShowModal;
end;

procedure TFormMaster.Button5Click(Sender: TObject);
begin
  FormFChPwd.Table1.Open;
  FormFChPwd.ShowModal;
  FormFChPwd.Table1.Close;
end;

end.