cw_dk.~pas

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

unit cw_dk;

interface

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

type
  TForm8 = class(TForm)
    Label1: TLabel;
    SpeedButton1: TSpeedButton;
    GroupBox1: TGroupBox;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    GroupBox2: TGroupBox;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    In_khbh: TEdit;
    In_khmc: TEdit;
    In_lxff: TEdit;
    In_bz: TEdit;
    Button1: TButton;
    T_service: TTable;
    DS_service: TDataSource;
    Q_repeat: TQuery;
    procedure In_khbhExit(Sender: TObject);
    procedure In_khbhKeyPress(Sender: TObject; var Key: Char);
    procedure In_lxffKeyPress(Sender: TObject; var Key: Char);
    procedure In_khmcKeyPress(Sender: TObject; var Key: Char);
    procedure In_bzKeyPress(Sender: TObject; var Key: Char);
    procedure Button1Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form8: TForm8;

implementation

{$R *.dfm}

procedure TForm8.In_khbhExit(Sender: TObject);
begin
  Q_repeat.Close;
  Q_repeat.SQL.Clear;
  Q_repeat.SQL.Add('select * from UserInfo where UserNo='''+In_khbh.Text+'''');
  Q_repeat.Open;
  if not Q_repeat.Eof then
    begin
      In_khbh.Clear;
      In_khbh.SetFocus;
      MessageDlg('您输入的编号有重复，请重新输入！',mtError,[mbok],0);
    end;

end;

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

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

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

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

procedure TForm8.Button1Click(Sender: TObject);
begin
 if (length(In_khbh.text)=0) or (length(In_khmc.Text)=0) or (length(In_lxff.Text)=0) or (length(In_bz.Text)=0) then
  begin
   MessageDlg('输入不能为空，请重新输入！',mtError,[mbok],0);
   end
  else
   begin
    T_service.Open;
    T_service.AppendRecord([In_khbh.text,In_khmc.text,In_lxff.text,0,In_bz.text]);
    T_service.Close;
    T_service.Open;
    T_service.Active:=True;
    end;

end;

procedure TForm8.SpeedButton1Click(Sender: TObject);
begin
 close;
end;

end.