cw_fwysn.pas

结于初学者来说这对数据库是一个很好的例子

unit cw_fwysn;

interface

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

type
  TForm13 = class(TForm)
    Label1: TLabel;
    GroupBox1: TGroupBox;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    GroupBox2: TGroupBox;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Name: TEdit;
    sex: TComboBox;
    age: TMaskEdit;
    intime: TMaskEdit;
    address: TEdit;
    Method: TEdit;
    memo: TEdit;
    Button1: TButton;
    Button2: TButton;
    Q_waiter: TQuery;
    DataSource1: TDataSource;
    procedure NameKeyPress(Sender: TObject; var Key: Char);
    procedure sexKeyPress(Sender: TObject; var Key: Char);
    procedure ageKeyPress(Sender: TObject; var Key: Char);
    procedure intimeKeyPress(Sender: TObject; var Key: Char);
    procedure addressKeyPress(Sender: TObject; var Key: Char);
    procedure MethodKeyPress(Sender: TObject; var Key: Char);
    procedure memoKeyPress(Sender: TObject; var Key: Char);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form13: TForm13;

implementation

{$R *.dfm}

procedure TForm13.NameKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm13.sexKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm13.ageKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm13.intimeKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm13.addressKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm13.MethodKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm13.memoKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm13.Button1Click(Sender: TObject);
begin
 if (length(Name.text)=0) or (length(sex.Text)=0) or (length(age.Text)=0) then
  begin
   MessageDlg('输入不正确，请重新输入！',mtError,[mbok],0);
   end
  else
   begin
      q_waiter.Open;
      q_waiter.AppendRecord([Name.text,sex.text,age.text,Address.text,StrToDatetime(InTime.text),Method.text,Memo.text,0,now]);
      q_waiter.Close;
      q_waiter.Open;
      name.text:='';
      age.text:='';
      address.text:='';
      method.text:='';
      memo.text:='';
      name.SetFocus;
   end;

end;

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

end.