userut.pas

用delphi+access给单位做的实用,简单的.

unit userut;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DB, ADODB, ExtCtrls, StdCtrls, Buttons, GridsEh,
  DBGridEh;

type
  Tuserfm = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    BitBtn4: TBitBtn;
    BitBtn5: TBitBtn;
    BitBtn6: TBitBtn;
    DBGridEh1: TDBGridEh;
    procedure BitBtn6Click(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  userfm: Tuserfm;

implementation

{$R *.dfm}

procedure Tuserfm.BitBtn6Click(Sender: TObject);
begin
close;
end;

procedure Tuserfm.BitBtn5Click(Sender: TObject);
begin
adoquery1.Cancel;
bitbtn4.Enabled:=false;
bitbtn5.Enabled:=false;
end;

procedure Tuserfm.BitBtn4Click(Sender: TObject);
begin
adoquery1.Post;
bitbtn4.Enabled:=false;
bitbtn5.Enabled:=false;
end;

procedure Tuserfm.BitBtn1Click(Sender: TObject);
begin
adoquery1.Append;
bitbtn4.Enabled:=true;
bitbtn5.Enabled:=true;
end;

procedure Tuserfm.BitBtn2Click(Sender: TObject);
begin
adoquery1.Edit;
bitbtn4.Enabled:=true;
bitbtn5.Enabled:=true;
end;

procedure Tuserfm.BitBtn3Click(Sender: TObject);
begin
adoquery1.Delete;
end;

procedure Tuserfm.FormCreate(Sender: TObject);
begin
 with adoquery1 do
   begin
     close;
     sql.Clear;
     sql.Add('select * from 用户表');
     open;
   end;
end;

end.