unit8.~pas

学生管理系统

unit Unit8;

interface

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

type
  TForm8 = class(TForm)
    CheckBox1: TCheckBox;
    Edit1: TEdit;
    Label1: TLabel;
    Edit2: TEdit;
    DBGrid1: TDBGrid;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    Button1: TButton;
    Button2: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form8: TForm8;

implementation

{$R *.dfm}

procedure TForm8.Button1Click(Sender: TObject);
begin
adoquery1.close;
adoquery1.sql.clear;
 adoquery1.sql.add('select * from study ');
     if checkbox1.checked=true then
     adoquery1.sql.add('where  学号 between '+''''+edit1.text+''''+'and '+''''+edit2.text+'''');
     adoquery1.sql.add('select * from study ');
     adoquery1.open;



end;

procedure TForm8.Button2Click(Sender: TObject);
begin
close;
end;

end.