utest.pas

连接sqlite数据库控件

unit Utest;

interface

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

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

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
var
  db : TASQLite3DB;
  sql : TASQLite3Query;
  i : integer;
  c : integer;
begin
  db := TASQLite3DB.Create(nil);
  db.DriverDLL := 'sqlite3.dll';

  db.Database := '我日.db';
  db.Connected := True;

  sql :=TASQLite3Query.Create(nil);
  sql.Connection := db;
  sql.SQL.Text := 'create table test ( personnr integer primary key,'+
                  '  name varchar(40),'+
                  '  address varchar(40) )';
  try
    sql.ExecSQL;
  except
    beep;
  end;

 // db.SQLite3_ExecSQL('pragma default_cache_size= 20000');
  c := gettickcount;
  sql.StartTransaction;
  //sql.StartTransaction;
  sql.SQL.Text := 'delete from test ';//where personnr = (select max(personnr)/3 from test)';
  sql.ExecSQL;
  for i := 0 to 100000 do
  begin
    sql.SQL.Text := 'insert into test(personnr,name,address)values('+inttostr(i)+','+'"'+inttostr(i)+'","'+inttostr(getcurrentprocessid)+'" )';
    sql.ExecSQL;
  end;
 // sleep(5000);
  sql.SQL.Clear;
  sql.SQL.Add('select * from test where (personnr=:0)');
  sql.Params[0].AsInteger := 300000;

  sql.Open;


  sql.Commit;
  caption := inttostr(gettickcount-c);

  sql.Free;
  db.free;
end;

end.