´´½¨µÄ¹ý³ÌÖгöÏÖdatabase login¶Ô»°¿ò£¬ÇëÎÊÔõôÑù²»ÈøöԻ°¿ò³öÏÖ£¿ÁíÍâÈçºÎ¶¨ÒåÈÕÆÚÐÍÊý¾ÝΪ¶ÌÈÕÆÚÐÍ£¿ºÃÏñÖ»Äܶ¨ÒåΪDatetime¡£
Ô´ÂëÈçÏ£º
£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½
procedure Tfrmweihu.btncjsjkClick(Sender: TObject);
var
path,StrSQL:string;
CreateAccess: OleVariant;
ADOConn: TADOConnection;
const
AConnectionString = 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s';
begin
//´´½¨Êý¾Ý¿âÎļþ
Path := ExtractFilePath(Application.ExeName);
if FileExists(Path + 'mydata.mdb') then
begin
showmessage('Êý¾Ý¿âÎļþÒѾ´æÔÚ£¡');
exit;
end;
CreateAccess:=CreateOleObject('ADOX.Catalog');
CreateAccess.Create('Provider=Microsoft.Jet.OLEDB.4.0;Data Source= '+Path+'mydata.mdb');
//´´½¨Êý¾Ý±í
ADOConn:=TADOConnection.create(self);
ADOConn.ConnectionString:=Format(AConnectionString,[Path +'mydata.mdb','']);
Strsql := 'create table mydata (ID autoincrement PRIMARY KEY not null,±êÇ©1 char(50) not null,±êÇ©2 char(50),±êÇ©3 char(50),±êÇ©4 char(50),±êÇ©5 char(50),±êÇ©6 char(50),ÕýÎÄ1 text not null,ÕýÎÄ2 text,ÈÕÆÚ Datetime not null)';
ADOConn.Execute(strsql);
ADOConn.Close;
ADOConn.Free;
Showmessage('Êý¾Ý±í´´½¨³É¹¦,'+#13#10+'ÇëÖØÐÂÆô¶¯±¾³ÌÐò£¡');
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......