unit1.pas

数据备份与恢复源码,给需要的一个参考,可以直接运行

{===========================================================
      ADOBackup组件应用实例程序
      Copyright Wolfsoft Studio 2002.08.06
      注意：目前ADOBackup组件不支持自增长类型的主键，请
            注意数据库的设计
      改组件支持SQL Server ，在SQL Server中添加数据库
      然后更改数据模块中ADOConnection1的ConnectionString为
      相应的SQL Server的连接，然后双击数据模块中ADODataSet1
      将字段全部删除，然后再添加进来即可
============================================================}
unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids, StdCtrls, ExtCtrls, DB, ADODB, Menus, ComCtrls,
  ToolWin, ImgList;

type
  TForm1 = class(TForm)
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    Memo1: TMemo;
    Button1: TButton;
    DataSource1: TDataSource;
    Label2: TLabel;
    Label3: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    ToolBar1: TToolBar;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    ImageList1: TImageList;
    procedure Button1Click(Sender: TObject);
    procedure ToolButton1Click(Sender: TObject);
    procedure ToolButton2Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
    bFlag: Boolean;
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

uses datafrm, DM;

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
var
  ADQ: TADOQuery;
  sID:string;
begin
  ADQ := TADOQuery.Create(Self);
  ADQ.Connection := DMMain.ADOConnection1;
  with ADQ do
  try
    Close;
    SQL.Text:='Select * From Test';
    Open;
    if RecordCount > 0 then
      Last;
    sID:=FieldByName('ID').AsString;
    sID:=Format('%.3d',[StrToInt(sID)+1]);
    Close;
    SQL.Text := 'Insert Into Test(ID,Name,Content) values(' + '''' +sID+''''+','+''''+ Edit1.Text + '''' + ',' + '''' + Edit2.Text + '''' + ')';
    ExecSQL;
    bFlag := True;
  finally
    ADQ.Free;
  end;
  if bFlag then
    DMMain.ADODataSet1.Requery();
end;

procedure TForm1.ToolButton1Click(Sender: TObject);
begin
  Show_Backup;
end;

procedure TForm1.ToolButton2Click(Sender: TObject);
begin
  if Show_Restore then
    DMMain.ADODataSet1.Requery();
end;

procedure TForm1.FormShow(Sender: TObject);
begin
  if not DMMain.ADODataSet1.Active then
    DMMain.ADODataSet1.Active:=True;
end;

end.