servermain.pas

delphi 三层结构的例子

unit servermain;

{$WARN SYMBOL_PLATFORM OFF}

interface

uses
  Windows, Messages, SysUtils, Classes, ComServ, ComObj, VCLCom, DataBkr,
  DBClient, Projects_TLB, StdVcl, Provider, DB, ADODB;

type
  Tsl = class(TRemoteDataModule, Isl)
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    DataSetProvider1: TDataSetProvider;
    ADOQuery1: TADOQuery;
    DataSetProvider2: TDataSetProvider;
  private
    { Private declarations }
  protected
    class procedure UpdateRegistry(Register: Boolean; const ClassID, ProgID: string); override;
    procedure inster(var type_, top: WideString; var neirong: OleVariant);
      safecall;
    procedure select(var type_: WideString); safecall;
    procedure select1(var top: WideString); safecall;
  public
    { Public declarations }
  end;

implementation

uses DateUtils;

{$R *.DFM}

class procedure Tsl.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 Tsl.inster(var type_, top: WideString; var neirong: OleVariant);
begin
   with ADOTable1 do
  begin
     Open;
     Append;
     FieldByName('类型').AsString:= type_;
     FieldByName('标题').asstring:=top;
     FieldValues['内容']:=neirong;
  
     Post;
  end;
end;

procedure Tsl.select(var type_: WideString);
begin
  with ADOQuery1 do
begin
  Close;
  SQL.Clear;
  SQL.Add('select * from da where 类型 = ''' + type_ + '''');
  Open;

end;
end;

procedure Tsl.select1(var top: WideString);
begin
   with ADOQuery1 do
begin
  Close;
  SQL.Clear;
  SQL.Add('select * from da where 标题 = ''' + top + '''');
  Open;

end;
end;

initialization
  TComponentFactory.Create(ComServer, Tsl,
    Class_sl, ciMultiInstance, tmApartment);
end.