unit Sys;

interface

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

type
  TForm5 = class(TForm)
    Edit1: TEdit;
    Button1: TButton;
    Button2: TButton;
    Label1: TLabel;
    Label2: TLabel;
    Edit2: TEdit;
    SaveDialog1: TSaveDialog;
    OpenDialog1: TOpenDialog;
    Button4: TButton;
    Button5: TButton;
    Button3: TButton;
    Label3: TLabel;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form5: TForm5;

implementation

uses Main, Datamodule;

{$R *.dfm}

procedure TForm5.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  form1.show;
  DataModule1.adoquery1.Close;
  DataModule1.adoquery2.Close;
  DataModule1.adoquery3.Close;
  DataModule1.adoquery4.Close;
  DataModule1.adoquery5.Close;
  DataModule1.adoquery6.Close;
  DataModule1.adoquery7.Close;
  DataModule1.AdoTable1.Close;
  DataModule1.AdoTable2.Open;  
  DataModule1.adoquery1.Open;
  DataModule1.adoquery2.Open;
  DataModule1.adoquery3.Open;
  DataModule1.adoquery4.Open;
  DataModule1.adoquery5.Open;
  DataModule1.adoquery6.Open;
  DataModule1.adoquery7.Open;
end;

procedure TForm5.FormCreate(Sender: TObject);
begin
  form5.OpenDialog1.title:='打開一個ACCESS文件:';
  form5.opendialog1.Filter:='Access Files(*.mdb)|*.mdb';
  form5.SaveDialog1.Title:='保存文件:';
  form5.SaveDialog1.defaultExt:=string('mdb');
  form5.SaveDialog1.Filter:='Access Files(*.mdb)|*.mdb|All Files(*.*)|*.*';
end;

procedure TForm5.Button2Click(Sender: TObject);
begin
  if(savedialog1.Execute())then
  begin
    edit1.text:=saveDialog1.FileName;
  end;
end;

procedure TForm5.Button4Click(Sender: TObject);
begin
  edit1.text:='';
  edit2.text:='';
end;

procedure TForm5.Button5Click(Sender: TObject);
  var bakupfile,datafile:string;
begin
  bakupfile:=edit2.text;
  datafile:=ExtractFilePath(ParamStr(0))+'Data\lib.mdb';
  try
    copyfile(pchar(bakupfile),pchar(datafile),false);
    application.messagebox('數據庫還原成功!','提示',0+64);
   // DataModule1.ADOconnection1.connected:=false;
   // DataModule1.ADOconnection1.connected:=true;
  except
    application.messagebox('數據庫還原失敗!','提示',0+16);
    exit;
 end;
 end;

 
procedure TForm5.Button1Click(Sender: TObject);
  var bakupfile,datafile:string;
begin
  bakupfile:=edit1.text;
  datafile:=ExtractFilePath(ParamStr(0))+'Data\lib.mdb';
  try
    copyfile(pchar(datafile),pchar(bakupfile),false);
    application.messagebox('數據庫備份成功!','提示',0+64);
  except  
    application.messagebox('數據庫備份失敗!','提示',0+16);
    exit;
end;
end;
procedure TForm5.Button3Click(Sender: TObject);
begin
  if (opendialog1.Execute())then
  begin
    edit2.text:=openDialog1.FileName;
  end;
end;
end.