dbandxml.~pas

用于将XML文件转化成关系数据库

unit DBandXML;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids, DB,StdCtrls,DBTables,SHDocVw, ExtCtrls,ActiveX,DBXML1,ADODB,OleCtrls;
type
  TForm1 = class(TForm)
    DBGrid1: TDBGrid;
    Label1: TLabel;
    Button2: TButton;
    Memo1: TMemo;
    ADODataSet1: TADODataSet;
    ADOConnection1: TADOConnection;
    DataSource1: TDataSource;
    Button1: TButton;
    Table: TTable;
    WebBrowser1: TWebBrowser;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
  end;

var

  Form1: TForm1;

  dbxml: TDBXml;

implementation
{$R *.dfm}

procedure TForm1.Button2Click(Sender: TObject);
begin
      dbxml:=TDBXml.create;
      try
         dbxml.DBtoXML(table);
      except
         on e:Exception do
         begin
         showmessage('数据库连接失败!');
         exit;
         end;
      end;
      memo1.lines.Append(dbxml.doc.xml);
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
        if not assigned(dbxml) then exit;
        dbxml.showXML;
        webbrowser1.Navigate(ExtractFilePath(Application.ExeName)+dbxml.root.nodeName+'.htm');
end;

procedure TForm1.FormClose(Sender: TObject; var Action: TCloseAction);
begin
    freeandnil(table);
    dbxml.Free;
end;

procedure TForm1.Button3Click(Sender: TObject);
var
    ole:variant;
begin
    if not assigned(dbxml) then exit;
    ole:=WebBrowser1.oleobject.document.all.item('fp',0);
    ole.Click;
end;

procedure TForm1.Button4Click(Sender: TObject);
var
    ole:variant;
begin
    if not assigned(dbxml) then exit;
    ole:=WebBrowser1.oleobject.document.all.item('pp',0);
    ole.Click;
end;

procedure TForm1.Button5Click(Sender: TObject);
var
    ole:variant;
begin
    if not assigned(dbxml) then exit;
    ole:=WebBrowser1.oleobject.document.all.item('np',0);
    ole.Click;
end;

procedure TForm1.Button6Click(Sender: TObject);
var
    ole:variant;
begin
    if not assigned(dbxml) then exit;
    ole:=WebBrowser1.oleobject.document.all.item('lp',0);
    ole.Click;
end;

end.