通过InstallShield 还原数据库的DLL(DELPHI)

library DBInstall;

{ Important note about DLL memory management: ShareMem must be the
  first unit in your library's USES clause AND your project's (select
  Project-View Source) USES clause if your DLL exports any procedures or
  functions that pass strings as parameters or function results. This
  applies to all strings passed to and from your DLL--even those that
  are nested in records and classes. ShareMem is the interface unit to
  the BORLNDMM.DLL shared memory manager, which must be deployed along
  with your DLL. To avoid using BORLNDMM.DLL, pass string information
  using PChar or ShortString parameters. }

uses
  ComServ,
  SysUtils,
  Classes,
  Forms,
  uFrmMain in 'uFrmMain.pas' {FrmMain};

{ Open the MainForm, the entertance of Library}
function OpenForm():integer; stdcall;
var
  FrmMain: TFrmMain;
begin
  FrmMain:=TFrmMain.Create(nil);
  FrmMain.ShowModal();
  result:=0;
  FrmMain.Free;
end;

exports
  DllGetClassObject,
  DllCanUnloadNow,
  DllRegisterServer,
  DllUnregisterServer,
  OpenForm;
{$R *.res}

begin
end.

unit uFrmMain;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, DB, ADODB;

type
  TFrmMain = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    txtUserName: TEdit;
    txtPassword: TEdit;
    btnOK: TButton;
    dbConn: TADOConnection;
    ADOQuery1: TADOQuery;
    procedure FormShow(Sender: TObject);
    procedure btnOKClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

implementation

{$R *.dfm}

procedure TFrmMain.FormShow(Sender: TObject);
begin
  txtUserName.Text:='sa';
  txtPassword.Text:='';
end;

procedure TFrmMain.btnOKClick(Sender: TObject);
var
  isErrRetry: bool;
begin
  isErrRetry:=false;
  dbConn.ConnectionString:='Provider=SQLOLEDB.1;'
        +'Password='+Trim(txtPassword.Text)+';Persist Security Info=True;User ID='+Trim(txtUserName.Text)+';Data Source=localhost';
  try
    dbConn.Open();
    ADOQuery1.SQL.Text:='RESTORE DATABASE MyNwind FROM MyNwind_1';
    ADOQuery1.ExecSQL;
  except on E:Exception do
  begin
    if MessageDlg('存在错误:'+E.Message+'是否忽略',mtError,[mbRetry,mbIgnore],0)=mrRetry then
      isErrRetry:=true
    else
      isErrRetry:=false;
    end;
  end;
  dbConn.Close();

  if not isErrRetry then ModalResult:=mrOK;
end;

end.

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值