unit1.pas.~87~

《Delphi程序员成长攻略》-蒙祖强龚涛的源代码

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Buttons, StdCtrls,Unit2,Unit3,Unit4,Unit5, DB, DBTables;

type
  TForm1 = class(TForm)
    GroupBox1: TGroupBox;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    Button1: TButton;
    Label1: TLabel;
    Query1: TQuery;
    Button2: TButton;
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.SpeedButton1Click(Sender: TObject);
begin
    Form2.Show;
end;

procedure TForm1.SpeedButton2Click(Sender: TObject);
begin
    Form3.Show;
end;

procedure TForm1.SpeedButton3Click(Sender: TObject);
begin
    Form4.Show;
end;

procedure TForm1.SpeedButton4Click(Sender: TObject);
begin
    Form5.Show;
end;

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

procedure TForm1.Button2Click(Sender: TObject);
var name,sp,cl:string;
begin
    name := '宋远桥';
    cl:= '计网043';

    //query1.Text:='insert into student values(982256, '+ name + ', 98, 79, 0, '+ cl+')';
    //query1.Text:='select * from student';
   // query1.Text :=

     query1.SQL.Clear;
    query1.SQL.Add('delete from student');
    query1.SQL.Add('insert into student values(982256, '+ name + ', 98, 79, 0, '+ cl+')');




     query1.Active := true;




end;

end.