unit2.pas

来自「oracle基础知识讲义」· PAS 代码 · 共 50 行

unit Unit2;

interface

uses
  SysUtils, Classes, HTTPApp, HTTPProd, DB, ADODB, DBWeb;

type
  TWebModule2 = class(TWebModule)
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    PageProducer1: TPageProducer;
    DataSetTableProducer1: TDataSetTableProducer;
    procedure WebModule2WebActionItem2Action(Sender: TObject;
      Request: TWebRequest; Response: TWebResponse; var Handled: Boolean);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  WebModule2: TWebModule2;

implementation

uses WebReq;

{$R *.DFM}

procedure TWebModule2.WebModule2WebActionItem2Action(Sender: TObject;
  Request: TWebRequest; Response: TWebResponse; var Handled: Boolean);
begin
  ADOQuery1.Parameters.ParamByName('code').Value := Request.QueryFields.Values['code'];
  ADOQuery1.Prepared;
  ADOQuery1.Open;
  if ADOQuery1.RecordCount > 0 then
    Response.Content := DataSetTableProducer1.Content
    else
      Response.Content := 'No record match!';

  ADOQuery1.Close;
end;

initialization
  if WebRequestHandler <> nil then
    WebRequestHandler.WebModuleClass := TWebModule2;

end.