adoquery:TADOQuery; adoquery:=TADOQuery.Create(nil); adoquery.connectionstring:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..........'; with adoquery do Close; SQL.Clear; SQL.Add(''); .... .....
var MyValue : TmyValue; begin Application.Initialize; MyValue := TMyValue.create; //这样你其它单元都可以通过使用 MYValue.AdoConn 了。 with TfrmLogin.Create(Nil) do begin try ShowModal; finally Free; end; end; Application.Run; end. 这个地方你再单独建一个单元,建下面这样一个类,当然你也可以在里面加入更多你需要的东西。 uses SysUtils, Classes, DB, ADODB; TmyValue = class ADOConn: TADOConnection; constructor Create; end; constructor TmyValue.Create; begin AdoConn := TAdoConnection.create; adoconn.ConnectionString := '写下连接代码'; try AdoConn.COnnected := True; except Raise; end; end;
直接用ADO控件就可以了,把这些控件放在一个模块上,然后在别的窗口调用。很方便的。
procedure TForm1.Button1Click(Sender: TObject); const SConnectionStringAccess='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;Persist Security Info=False'; var FADOConnection:TADOConnection; begin FADOConnection:=TADOConnection.Create(nil); try FADOConnection.LoginPrompt:=False; FADOConnection.ConnectionString:=Format(SConnectionStringAccess,[ExtractFilePath(ParamStr(0))+'test.mdb']);; FADOConnection.Open; finally if FADOConnection.Connected then FADOConnection.Close; if Assigned(FADOConnection) then FreeAndNil(FADOConnection); end; end;
const Constr='Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=%s'; var FCon:TADOConnection; begin FCon:=TADOConnection.Create(nil); try FCon.LoginPrompt:=False;//取消验证 FCon.ConnectionString:=Format(Constr,[数据库路径]);; FCon.Open;//连接 finally FCon.Free;//使用完后,释放 end; end;
delphi提供的控件,就是对ado的包装。你不用它的话,就得自己实现对ado的包装。 你可以参考delphi是如何与ado的com对象进行交互,来实现连接。
adoquery:=TADOQuery.Create(nil);
adoquery.connectionstring:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..........';
with adoquery do
Close;
SQL.Clear;
SQL.Add('');
....
.....
MyValue : TmyValue;
begin
Application.Initialize;
MyValue := TMyValue.create; //这样你其它单元都可以通过使用 MYValue.AdoConn 了。
with TfrmLogin.Create(Nil) do
begin
try
ShowModal;
finally
Free;
end;
end; Application.Run;
end.
这个地方你再单独建一个单元,建下面这样一个类,当然你也可以在里面加入更多你需要的东西。
uses
SysUtils, Classes, DB, ADODB;
TmyValue = class
ADOConn: TADOConnection;
constructor Create;
end; constructor TmyValue.Create;
begin
AdoConn := TAdoConnection.create;
adoconn.ConnectionString := '写下连接代码';
try
AdoConn.COnnected := True;
except
Raise;
end;
end;
procedure TForm1.Button1Click(Sender: TObject);
const
SConnectionStringAccess='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;Persist Security Info=False';
var
FADOConnection:TADOConnection;
begin
FADOConnection:=TADOConnection.Create(nil);
try
FADOConnection.LoginPrompt:=False;
FADOConnection.ConnectionString:=Format(SConnectionStringAccess,[ExtractFilePath(ParamStr(0))+'test.mdb']);;
FADOConnection.Open;
finally
if FADOConnection.Connected then FADOConnection.Close;
if Assigned(FADOConnection) then FreeAndNil(FADOConnection);
end;
end;
Constr='Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=%s';
var
FCon:TADOConnection;
begin
FCon:=TADOConnection.Create(nil);
try
FCon.LoginPrompt:=False;//取消验证
FCon.ConnectionString:=Format(Constr,[数据库路径]);;
FCon.Open;//连接
finally
FCon.Free;//使用完后,释放
end;
end;
adoconnection.connectionstring:='driver={microsoft access driver (*.mdb);qdb=数据库路径/名字;uid;pwd=;';
adoconnection.open;
starluck的思路比较新颖,值得学习!
var
ADOConnection1:TADOConnection;
begin
ADOConnection1:=TADOConnection.Create(nil);
try
ADOConnection1.LoginPrompt:=False;//取消验证
ADOConnection1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+pathstr+';Persist Security Info=False'
ADOConnection1.Open;//连接
finally
ADOConnection1.Free;//使用完后,释放
end; end;//调用
adoconnected(ADOConnection1, 'E:\..\aa.mdb');
begin
ADOConnection1.LoginPrompt:=False;//取消验证
ADOConnection1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+pathstr+';Persist Security Info=False'
ADOConnection1.Open;//连接
end;//调用
adoconnected(ADOConnection1, 'E:\..\aa.mdb');
俺也贴一下。const
ADOString = 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;'+
'Jet OLEDB:Database Password=''''';
var
dataset: TADODataSet;
path: string;
begin
con := TAdoConnection.Create(nil);
path := ExtractFilePath(Application.ExeName);
con.ConnectionString := Format(AdoString,[path + '\Data.mdb']);
con.LoginPrompt := false;
con.Connected := true;
dataset.Connection := con;
dataset.CommandText := 'SELECT * FROM [t1] order by id';
dataset.Open();
....
end;