unit4.pas

学生缴费管理系统是以面向对象的观点进行开发的。根据对学生缴费信息与软件要求所做分析然后利用DELPHI开发出来的软件

unit Unit4;

interface

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

type
  TForm4 = class(TForm)
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Query1: TQuery;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Edit1: TEdit;
    Edit2: TEdit;
    Button4: TButton;
    Button5: TButton;
    Label1: TLabel;
    Label2: TLabel;
    RadioGroup1: TRadioGroup;
    Label3: TLabel;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure RadioGroup1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form4: TForm4;

implementation
 uses unit2;
{$R *.dfm}

procedure TForm4.Button1Click(Sender: TObject);
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from 学生缴费');
query1.Prepare;
query1.open;
end;

procedure TForm4.Button2Click(Sender: TObject);
begin
form2.Show;
form4.close;
      end;

procedure TForm4.FormClose(Sender: TObject; var Action: TCloseAction);
begin
form2.Show;
     
end;

procedure TForm4.Button3Click(Sender: TObject);
begin
application.Terminate;
end;

procedure TForm4.Button4Click(Sender: TObject);
begin
if edit1.Text<>'' then
begin
    query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from 学生缴费');
query1.SQL.Add('where 学生编号='''+edit1.text+'''');
query1.Prepare;
query1.open;
end
else
showmessage('请输入学生编号');
end;

procedure TForm4.Button5Click(Sender: TObject);
begin
if edit2.Text<>'' then
begin
    query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from 学生缴费');
query1.SQL.Add('where 学生姓名='''+edit2.text+'''');
query1.Prepare;
query1.open;
end
else
showmessage('请输入学生姓名');
end;

procedure TForm4.RadioGroup1Click(Sender: TObject);
begin
       if RadioGroup1.ItemIndex=0 then
       begin
         query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from 学生缴费');
query1.SQL.Add('where 缴费=true');
query1.Prepare;
query1.open;
       end;

       if  RadioGroup1.ItemIndex=1 then
          begin
         query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from 学生缴费');
query1.SQL.Add('where 缴费=false');
query1.Prepare;
query1.open;
       end
       end;

end.