zsdy.pas

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

unit zsdy;

interface

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

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

var
  zsdyform: Tzsdyform;

implementation

{$R *.dfm}

procedure Tzsdyform.BitBtn1Click(Sender: TObject);
begin
  Query1.Params.Clear ;
            Query1.SQL.Clear ;
            Query1.Params.CreateParam(ftstring,'bj',ptinput).AsString :=Edit1.Text ;
            Query1.Params.CreateParam(ftstring,'xm',ptinput).AsString :=Edit2.Text ;
            Query1.Params.CreateParam(ftstring,'zhcpmc',ptinput).AsString :=Edit3.Text ;
            Query1.Params.CreateParam(ftstring,'bjjfmc',ptinput).AsString :=Edit4.Text ;
            Query1.Params.CreateParam(ftstring,'hjqk',ptinput).AsString :=Edit5.Text ;

            Query1.SQL.Add('insert into zhengshidangyuan(banji,xingming,zonghecepingmingci,banjijunfenmingci,huojiangqingkuang) values(:bj,:xm,:zhcpmc,:bjjfmc,:hjqk)');
            Query1.ExecSQL ;
           Edit1.Clear ;
           Edit2.Clear ;
           Edit3.Clear ;
           Edit4.Clear ;
           Edit5.Clear ;
           Edit1.SetFocus ;
           Edit1.Focused ;

end;

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

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

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

procedure Tzsdyform.Edit4KeyPress(Sender: TObject; var Key: Char);
begin
      if key =#13 then
 begin
 Edit5.SetFocus ;
 Edit5.Focused ;
  end;
end;

procedure Tzsdyform.Edit5KeyPress(Sender: TObject; var Key: Char);
begin
        if key =#13 then
 begin
 bitbtn1.SetFocus ;
 bitbtn1.Focused ;
  end;
end;

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

end.