unit1.pas

《Delphi7编程100例》代码,书配资料

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    GroupBox1: TGroupBox;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    DataSource1: TDataSource;
    Query1: TQuery;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
  with Query1 do
  begin
    close;
    SQL.Clear;
    SQL.Add('select * from StudentInfo');
    Open;
  end;
end;

procedure TForm1.Button2Click(Sender: TObject);
var
  newint:string;
  clickedOK:boolean;
begin
  clickedOK:=InputQuery('输入框','请输入学生学号',newint);
  if clickedOK then
  with Query1 do
  begin
    close;
    SQL.Clear;
    SQL.Add('select * from StudentInfo where XH=:XH');
    ParamByName('XH').AsInteger:=strtoint(newint);
    Open;
  end;
end;

procedure TForm1.Button3Click(Sender: TObject);
var
  newstring:string;
  clickedOK:boolean;
begin
  newstring:='';
  clickedOK:=InputQuery('输入框','请输入所在系别',newstring);
  if clickedOK then
  with Query1 do
  begin
    close;
    SQL.Clear;
    SQL.Add('select * from StudentInfo where SZXB=:SZXB');
    ParamByName('SZXB').AsString:=newstring;
    Open;
  end;
end;

procedure TForm1.Button4Click(Sender: TObject);
begin
  Close;
end;

end.