unit4.~pas

用delphi写的课堂作业

unit Unit4;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, 
  Dialogs, StdCtrls, Grids, DBGrids, DB, ADODB, RpRave, RpDefine, RpCon,
  RpConDS;

type
  TFrame4 = class(TFrame)
    DBGrid1: TDBGrid;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    GroupBox1: TGroupBox;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    RvDataSetConnection1: TRvDataSetConnection;
    RvProject1: TRvProject;
    Label1: TLabel;
    Label2: TLabel;
    Edit1: TEdit;
    Button7: TButton;
    Label3: TLabel;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Label1Click(Sender: TObject);
    procedure Label2Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

implementation

{$R *.dfm}

procedure TFrame4.Button1Click(Sender: TObject);
begin
   adoquery1.Close;
   adoquery1.SQL.Clear;
   adoquery1.SQL.add('select * from student where number order by truancy desc');
   adoquery1.Open;
   end;

procedure TFrame4.Button2Click(Sender: TObject);
begin
   adoquery1.Close;
   adoquery1.SQL.Clear;
   adoquery1.SQL.add('select * from student where number order by late desc');
   adoquery1.Open;
end;

procedure TFrame4.Button3Click(Sender: TObject);
begin
   adoquery1.Close;
   adoquery1.SQL.Clear;
   adoquery1.SQL.add('select * from student where number order by leave desc');
   adoquery1.Open;
end;

procedure TFrame4.Button4Click(Sender: TObject);
begin
   adoquery1.Close;
   adoquery1.SQL.Clear;
   adoquery1.SQL.add('select * from student where number order by qingjia desc');
   adoquery1.Open;
end;

procedure TFrame4.Button5Click(Sender: TObject);
begin
   adoquery1.Close;
   adoquery1.SQL.Clear;
   adoquery1.SQL.add('select * from student where number order by number desc');
   adoquery1.Open;
end;

procedure TFrame4.Button6Click(Sender: TObject);
begin
   adoquery1.Close;
   adoquery1.SQL.Clear;
   adoquery1.SQL.add('select * from student where number order by grade desc');
   adoquery1.Open;
end;

procedure TFrame4.Label1Click(Sender: TObject);
begin
Rvproject1.Execute;
end;

procedure TFrame4.Label2Click(Sender: TObject);
begin
  ADOQuery1.Close;
  ADOQuery1.SQL.Clear;
  ADOQuery1.SQL.Add('select *from student');
  ADOQuery1.Open;
end;

procedure TFrame4.Button7Click(Sender: TObject);
var
tiaojian:string;
begin
   if Edit1.Text<>'' then
  begin
    tiaojian := 'select * from student where sname like "%' + Edit1.Text + '%" or number like "%'+Edit1.Text+'%"or grade like "%'+Edit1.Text+'%" or sex like "%'+Edit1.Text+'%"';
    ADOQuery1.Close;
    ADOQuery1.SQL.Clear;
    ADOQuery1.SQL.Add(tiaojian);
    ADOQuery1.Open;
  end
  else
    messagebox(handle,'请输入查询条件！','检查输入',mb_iconwarning+mb_ok)

end;

end.