unit1.~pas

三层数据库应用程序的例子,包括应用服务器和前台程序.

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Grids, DBGrids, ExtCtrls, DBCtrls, DBClientActns,
  DBActns, ActnList;

type
  TForm1 = class(TForm)
    DBGrid1: TDBGrid;
    Label1: TLabel;
    DBGrid2: TDBGrid;
    Label2: TLabel;
    Label3: TLabel;
    ActionList1: TActionList;
    DataSetInsert1: TDataSetInsert;
    DataSetDelete1: TDataSetDelete;
    DataSetEdit1: TDataSetEdit;
    DataSetCancel1: TDataSetCancel;
    DataSetRefresh1: TDataSetRefresh;
    ClientDataSetUndo1: TClientDataSetUndo;
    ControlBar1: TControlBar;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    Button7: TButton;
    DataSetPost1: TDataSetPost;
    CloseAP: TAction;
    Update: TAction;
    Button8: TButton;
    Memo1: TMemo;
    Label4: TLabel;
    Button9: TButton;
    ComboBox1: TComboBox;
    Button10: TButton;
    procedure CloseAPExecute(Sender: TObject);
    procedure UpdateExecute(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Button9Click(Sender: TObject);
    procedure Button10Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

uses Unit2;

{$R *.dfm}

procedure TForm1.CloseAPExecute(Sender: TObject);
begin
   Close;
end;

procedure TForm1.UpdateExecute(Sender: TObject);
begin
  Unit2.DataModule2.ClientDataSet1.ApplyUpdates(-1);
  //注目前暂知只能用此方法,用POST UpdateRecords都不行.
end;

procedure TForm1.Button8Click(Sender: TObject);
begin
  DataModule2.ClientDataSet2.Active:=False;
  DataModule2.ClientDataSet2.CommandText:=Memo1.Lines.Text;
  DataModule2.ClientDataSet2.Active:=True;

end;

procedure TForm1.Button9Click(Sender: TObject);
begin
  DataModule2.ClientDataSet1.Active:=True;
end;

procedure TForm1.Button10Click(Sender: TObject);
begin

  DataModule2.ClientDataSet2.Active:=False;
  DataModule2.ClientDataSet2.CommandText:=Memo1.Lines.Text;
  DataModule2.ClientDataSet2.Params.ParamByName('Sex').AsString:='男';
  DataModule2.ClientDataSet2.Active:=True;

end;

end.