mrxtcsh.pas

Delphi数据库开发系统例子

unit MRXTCSH;

interface

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

type
  TFRM_XTCSH = class(TForm)
    Button1: TButton;
    Label1: TLabel;
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FRM_XTCSH: TFRM_XTCSH;

implementation
  uses data;
{$R *.dfm}

procedure TFRM_XTCSH.Button1Click(Sender: TObject);
var
  yi : integer;
  ssp : string;
begin
  try
  yi := 1;
  if application.MessageBox('你真的要初始化吗？','提示',mb_yesno)=idyes then
  begin
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_user');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
       begin
         close;
         sql.Clear;
         sql.Add('select * from tb_user');
         open;
       end;
       database.ADO_bb.Insert;
       database.ADO_bb.FieldByName('user_id').AsString := 'CY'+formatdatetime('yyyymm',now())+'000001';
       database.ADO_bb.FieldByName('user_name').AsString := 'mingrisoft';
       database.ADO_bb.FieldByName('user_mm').AsString := 'www.mingrisoft.com';
       database.ADO_bb.FieldByName('user_yhjs').AsString := '高级用户';
       database.ADO_bb.FieldByName('user_ms').AsDateTime := now();
       while yi>0 do
       begin
         ssp := inttostr(yi);
         database.ADO_bb.fieldbyname(ssp).AsVariant := True;
         yi := yi+1;
         if yi = 32 then
           break;
       end;
       database.ADO_bb.Post;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_khxx');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_Client_sfzy');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_Client_qyzx');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_Client_qyxz');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_Client_qyxx');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_Client_qylx');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_Client_mydtj');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_Client_lxrxx');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_Client_khts');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_Client_khmyd');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_Client_khjb');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_Client_khfk');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_Client_gzbw');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_Client_cpxs');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       with database.ADO_bb do
         begin
             close;
             sql.Clear;
             sql.Add('delete tb_bdwxx');
             execsql;
         end;
/////////////////////////////////////////////////////////////////
       showmessage('初始化成功');
  end;
  except
    showmessage('数据库连接发生错误')
  end;
end;

end.