unit3.pas

利用数据库后SQL台操作的

unit Unit3;

interface

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

type
  TForm3 = class(TForm)
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    GroupBox1: TGroupBox;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    ADOQuery1: TADOQuery;
    Button6: TButton;
    ActionList1: TActionList;
    DataSetDelete1: TDataSetDelete;
    Button5: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form3: TForm3;

implementation

uses Unit4, Unit5;

{$R *.dfm}

procedure TForm3.Button1Click(Sender: TObject);
begin
adoquery1.Prior;
end;

procedure TForm3.Button2Click(Sender: TObject);
begin
adoquery1.next;
end;

procedure TForm3.Button3Click(Sender: TObject);
begin
form4.show;
end;

procedure TForm3.Button4Click(Sender: TObject);
begin
form3.close;
end;

procedure TForm3.Button6Click(Sender: TObject);
begin
form5.show;
form5.close;
showmessage('修改成功！');

end;

procedure TForm3.Button7Click(Sender: TObject);
begin
if application.MessageBox('确实要删除次数据吗？','提示',mb_yesno)=idyes then
begin
with adoquery1 do
begin
close;
sql.Clear;
sql.add('delete from login where name='''+trim(dbedit2.text)+'''');
execsql;
end;

end;
end;
end.