tzb.~pas

希望大家能多多指教这是我给我们同学编的系统

unit tzb;

interface

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

type
  Ttzbform = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Table1: TTable;
    Query1: TQuery;
    Query1BDEDesigner: TStringField;
    Query1BDEDesigner2: TStringField;
    Query1BDEDesigner3: TStringField;
    Query1BDEDesigner4: TStringField;
    Query1BDEDesigner5: TStringField;
    Table1BDEDesigner: TStringField;
    Table1BDEDesigner2: TStringField;
    Table1BDEDesigner3: TStringField;
    Table1BDEDesigner4: TStringField;
    Table1BDEDesigner5: TStringField;
    procedure BitBtn1Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Edit2KeyPress(Sender: TObject; var Key: Char);
    procedure Edit3KeyPress(Sender: TObject; var Key: Char);
    procedure Edit5Change(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  tzbform: Ttzbform;

implementation

{$R *.dfm}

procedure Ttzbform.BitBtn1Click(Sender: TObject);
begin
    Query1.Params.Clear ;
            Query1.SQL.Clear ;
            Query1.Params.CreateParam(ftstring,'xm',ptinput).AsString :=Edit1.Text ;
            Query1.Params.CreateParam(ftstring,'zw',ptinput).AsString :=Edit2.Text ;
            Query1.Params.CreateParam(ftstring,'bj',ptinput).AsString :=Edit3.Text ;
            Query1.Params.CreateParam(ftstring,'ss',ptinput).AsString :=Edit4.Text ;
            Query1.Params.CreateParam(ftstring,'dh',ptinput).AsString :=Edit5.Text ;

            Query1.SQL.Add('insert into classlist(xingming,zhiwu,banji,sushe,dianhua) values(:xm,:zw,:bj,:ss,:dh)');
            Query1.ExecSQL ;
           Edit1.Clear ;
           Edit2.Clear ;
           Edit3.Clear ;
           Edit4.Clear ;
           Edit5.Clear ;
           Edit1.SetFocus ;
           Edit1.Focused ;

end;

procedure Ttzbform.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
         if key =#13 then
 begin
 Edit2.SetFocus ;
 Edit2.Focused ;
  end;
end;

procedure Ttzbform.Edit2KeyPress(Sender: TObject; var Key: Char);
begin
          if key =#13 then
 begin
 Edit3.SetFocus ;
 Edit3.Focused ;
  end;
end;

procedure Ttzbform.Edit3KeyPress(Sender: TObject; var Key: Char);
begin
             if key =#13 then
 begin
 Edit4.SetFocus ;
 Edit4.Focused ;
  end;
end;

procedure Ttzbform.Edit5Change(Sender: TObject);
begin
bitbtn1.Enabled :=true;
end;

end.