unit10.~pas

学生成绩管理系统

unit Unit10;

interface

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

type
  Tsort = class(TForm)
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    Query1: TQuery;
    GroupBox1: TGroupBox;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    GroupBox2: TGroupBox;
    Button1: TButton;
    ComboBox1: TComboBox;
    Button2: TButton;
    procedure Button1Click(Sender: TObject);
    procedure RadioButton1Click(Sender: TObject);
    procedure RadioButton2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  sort: Tsort;
 i:integer;

implementation

{$R *.dfm}

procedure Tsort.Button1Click(Sender: TObject);

begin
if i=0 then
begin
query1.SQL.Clear;
query1.SQL.Add ('select studentid,'+' '+combobox1.text
+' '+'from grade order by '+ComboBox1.Text);
query1.Open ;
end
else
begin
query1.SQL.Clear;
query1.SQL.Add ('select studentid,'+' '+combobox1.text
+' '+'from grade order by '+ComboBox1.Text+' desc');
query1.Open ;
end;
end;

procedure Tsort.RadioButton1Click(Sender: TObject);
begin
i:=0;
end;

procedure Tsort.RadioButton2Click(Sender: TObject);
begin
i:=1;
end;

procedure Tsort.FormCreate(Sender: TObject);
begin
i:=0;
end;

procedure Tsort.FormClose(Sender: TObject; var Action: TCloseAction);
begin
action:=cafree;
end;

procedure Tsort.Button2Click(Sender: TObject);
begin
if i=0 then
begin
query1.SQL.Clear;
query1.SQL.Add ('select * from grade order by '+ComboBox1.Text);
query1.Open ;
end
else
begin
query1.SQL.Clear;
query1.SQL.Add ('select * from grade order by '+ComboBox1.Text+' desc');
query1.Open ;
end;
end;

end.