manager.pas

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

unit manager;

interface

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

type
  TForm24 = class(TForm)
    Label1: TLabel;
    GroupBox1: TGroupBox;
    GroupBox2: TGroupBox;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Q_manager: TQuery;
    DataSource1: TDataSource;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    ID: TEdit;
    Name: TEdit;
    sex: TComboBox;
    address: TEdit;
    Intime: TMaskEdit;
    ManagerRight: TComboBox;
    Button1: TButton;
    Button2: TButton;
    Q_repeat: TQuery;
    Label14: TLabel;
    Passw: TMaskEdit;
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure IDKeyPress(Sender: TObject; var Key: Char);
    procedure NameKeyPress(Sender: TObject; var Key: Char);
    procedure sexKeyPress(Sender: TObject; var Key: Char);
    procedure addressKeyPress(Sender: TObject; var Key: Char);
    procedure IntimeKeyPress(Sender: TObject; var Key: Char);
    procedure ManagerRightKeyPress(Sender: TObject; var Key: Char);
    procedure IDExit(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form24: TForm24;

implementation

{$R *.dfm}

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

procedure TForm24.Button1Click(Sender: TObject);
begin
 if (length(ManagerRight.Text)=0) or (length(Name.text)=0) or (length(sex.Text)=0) or (length(ID.Text)=0) then
  begin
   MessageDlg('输入不正确，请重新输入！',mtError,[mbok],0);
   end
  else
   begin
      q_manager.Open;
      q_manager.AppendRecord([ID.text,Name.text,passw.text,sex.text,Address.text,StrToDatetime(InTime.text),StrToInt(ManagerRight.Text)]);
      q_manager.Close;
      q_manager.Open;
      ID.Text:='';
      name.text:='';
      address.text:='';
   end;

end;

procedure TForm24.FormCreate(Sender: TObject);
begin
  InTime.Text:=datetimetostr(date);
end;

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

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

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

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

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

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

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

end.