urdmdynamicsqlserver.pas

就是这本书的随书代码。包括《实战Delphi 5.x-分布式多层应用系统篇》

unit urdmDynamicSQLServer;

interface

uses
  Windows, Messages, SysUtils, Classes, ComServ, ComObj, VCLCom, DataBkr,
  DBClient, PDynamicSQLDemo_TLB, StdVcl, Provider, Db, ADODB;

type
  TDynamicSQLDemoServer = class(TRemoteDataModule, IDynamicSQLDemoServer)
    adocDSQL: TADOConnection;
    ADOQuery1: TADOQuery;
    dspGeneral: TDataSetProvider;
  private
    { Private declarations }
  protected
    class procedure UpdateRegistry(Register: Boolean; const ClassID, ProgID: string); override;
    procedure GetAllTables(var vTables: OleVariant); safecall;
  public
    { Public declarations }
  end;

implementation

{$R *.DFM}

class procedure TDynamicSQLDemoServer.UpdateRegistry(Register: Boolean; const ClassID, ProgID: string);
begin
  if Register then
  begin
    inherited UpdateRegistry(Register, ClassID, ProgID);
    EnableSocketTransport(ClassID);
    EnableWebTransport(ClassID);
  end else
  begin
    DisableSocketTransport(ClassID);
    DisableWebTransport(ClassID);
    inherited UpdateRegistry(Register, ClassID, ProgID);
  end;
end;

procedure TDynamicSQLDemoServer.GetAllTables(var vTables: OleVariant);
var
  tblList : TStringList;
  iCount : Integer;
begin
  try
    tblList := TStringList.Create;
    adocDSQL.GetTableNames(tblList);
    vTables := VarArrayCreate([0, tblList.Count - 1], varVariant);
    for iCount := 0 to tblList.Count - 1 do
    begin
      vTables[iCount] := tblList.Strings[iCount];
    end;
  finally
    tblList.Free;
  end;
end;

initialization
  TComponentFactory.Create(ComServer, TDynamicSQLDemoServer,
    Class_DynamicSQLDemoServer, ciMultiInstance, tmApartment);
end.