unit1.pas

Delphi数据库编程

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, DB, ADODB;

type
  TForm1 = class(TForm)
    ADOConnection1: TADOConnection;
    ADOCommand1: TADOCommand;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
var
   TableList:Tstrings;
   CurDir:String;
 begin
   GetDir(0,CurDir);
   ADOConnection1.ConnectionString :='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+Curdir+'\教学.mdb;Persist Security Info=False';
   ADOConnection1.Connected :=True;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  ADOCommand1.CommandType := CmdText;
  ADOCommand1.CommandText :='UPdate 教师表 SET 工资=工资*1.1';
  ADOCommand1.Execute ;
end;

procedure TForm1.Button3Click(Sender: TObject);
begin
 ADOConnection1.Close ;
 APPLication.Terminate ;
end;

end.