delphi中用adoquery实现查询

1.adoquery需要配置好connection或是connectionstring
2.
adoquery.close;
adoquery.sql.clear;
adoquery.sql.add('select * from table');
adoquery.open;

三个控件ADOConnection ADOQuery ADOTable
procedure TDataModule1.DataModuleCreate(Sender: TObject);//Path为数据库文件路径，MyPassw为数据库密码
begin
ADOConnection1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+
Path;Jet OLEDB:Database Password='+
MyPassW+';Persist Security Info=False';
ADOQuery1.Connection:=ADOConnection1;
ADOTable1.Connection:=ADOConnection1;
ADOConnection1.LoginPrompt:=False;、、
end;