unit6.pas

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

unit Unit6;

interface

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

type
  TForm6 = class(TForm)
    DataSource1: TDataSource;
    Query1: TQuery;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Label6: TLabel;
    Edit6: TEdit;
    Button1: TButton;
    Label7: TLabel;
    Edit7: TEdit;
    Button2: TButton;
    Button3: TButton;
    DBGrid1: TDBGrid;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    Label8: TLabel;
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form6: TForm6;

implementation
 uses unit2;
{$R *.dfm}

procedure TForm6.Button2Click(Sender: TObject);
begin
if query1.RecordCount>0 then
begin
query1.SQL.Clear;
query1.SQL.Add('update 学生缴费');
query1.SQL.Add('set 学生编号='''+edit7.text+''',学生姓名='''+edit1.text+''',年级='''+edit2.text+''',班级='''+edit3.text+''',学年年度='''+edit4.text+''',应缴费用='''+edit5.text+'''');
query1.SQL.add('where 学生编号='''+edit6.text+'''');
query1.ExecSQL;
 
end
else showmessage('输入有误！！！');
end;

procedure TForm6.Button1Click(Sender: TObject);
begin
if   edit6.Text<>'' then
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from 学生缴费');
query1.SQL.Add('where  学生编号='''+edit6.text+'''');
query1.Prepare;
query1.open;
if query1.RecordCount>0 then
  begin

    edit7.Text:=edit6.Text;
  edit1.Text:=query1['学生姓名'];
  edit2.Text:=query1['年级'];
  edit3.Text:=query1['班级'];
  edit4.Text:=query1['学年年度'];
  edit5.Text:=query1['应缴费用'];
  if query1['缴费']=false then
    begin
    button3.Enabled:=true;
     button2.Enabled:=true;
     end
     end
   else
   begin
   showmessage('输入有误！！！');
   button2.Enabled:=false;
   button3.Enabled:=false;
   end
   end
   else
   showmessage('请输入学生编号');
   end;

procedure TForm6.FormCreate(Sender: TObject);
begin
button2.Enabled:=false;
button3.Enabled:=false;
end;

procedure TForm6.Button4Click(Sender: TObject);
begin
  form2.Show;
  form6.close;
end;

procedure TForm6.Button5Click(Sender: TObject);
begin
application.Terminate;
end;

procedure TForm6.Button3Click(Sender: TObject);
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('delete from 学生缴费');
query1.SQL.Add('where  学生编号='''+edit6.text+''';');
query1.ExecSQL;


end;

procedure TForm6.Button6Click(Sender: TObject);
begin
    query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from 学生缴费');
query1.SQL.Add('where  学生编号='''+edit6.text+'''');
query1.Prepare;
query1.open;
end;

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

end.