unit2.pas.~5~

Delphi 2005 ADO 连接演示

unit Unit2;

interface

uses
  SysUtils, Classes, DB, ADODB,dialogs;

type
  TDataModule2 = class(TDataModule)
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    procedure DataModuleCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    function loginapp(username,passwd:string):boolean;
  end;
Const
  SConnectionString       = 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;'
                                +'Jet OLEDB:Database Password=%s;';

var
  DataModule2: TDataModule2;

implementation

{$R *.dfm}
function setadoaccess(mdbpath:string;passwd:string):string;
begin
mdbpath:=trim(mdbpath);
passwd:=trim(passwd);
result:=format(SConnectionString,[mdbpath,passwd]);
end;
procedure TDataModule2.DataModuleCreate(Sender: TObject);
begin
ADOConnection1.ConnectionString:=setadoaccess(extractfilepath(paramstr(0))+'tmp.mdb','');
end;
function tdatamodule2.loginapp(username,passwd:string):boolean;
begin
    with adoquery1 do
        begin
            close;
            sql.clear;
            sql.add('select * from logininfo where usernames=:username and passwd=:passwd');
            parameters.ParamByName('username').Value:=trim(username);
            parameters.ParamByName('passwd').Value:=trim(passwd);
            try
            open;
            except on e:exception do
                begin
                    showmessage(e.Message);
                end;
            end;
        end;
end;

end.