ÈçºÎ¸ü»»Êý¾ÝÔ´(Access)
ÀýÈçÓÐ2¸öÊý¾Ý¿â£¬a.mdbºÍb.mdb£¬¸Õ¿ªÊ¼ÓõÄa.mdb,ÈçºÎд³ÌÐòÑ¡Ôñb.mdb¿ÉÓÃ
³ÌÐòÓÐÓû§µÇ¼ÓëûÓû§µÇ¼ÊDz»ÊÇÓÐÇø±ð
Çл»Êý¾Ý¿â¾ÍÊǸıäadoconnectionµÄconnectionstringÖеÄÊý¾ÝÔ´¾ÍÊÇÁË
ÓÃÁ½¸öÁ¬½Ó»ò¸ü¸ÄÁ¬½Ó´®
adoconnection
jf
data source='+OpenDialog1.FileName+';
adoconnection.connectionstring:=data source;
ÕâÑùд
ÕâÊÇɶ£¿data source£¬lz¿ÉÄÜÓÐЩ¶«Î÷û¸ãÇå³þ¡£
Constr : string;
Constr= 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\Data.mdb;Persist Security Info=False';
adoconnection.connectionstring:=Constr;
ÏòÕâÑù×¼±¸2¸öÁ´½Ó×Ö·û´®£¬·Ö±ðÖ¸ÏòÄã2¸ö²»Í¬µÄÊý¾Ý¿â
ÎÒÊÇÏëÔËÐгÌÐòʱ¸Ä±äÊý¾Ý¿â
Êý¾Ý¿âÃû³Æ²»¹Ì¶¨
»»ÁËÊý¾Ý¿âÔõô²»ÏÔʾÊý¾Ý£¬ÎÒ¿âÀïÃæÓÐÊý¾Ý°¡£¬»»»ØÔÀ´µÄÊý¾Ý¿âÒ²²»ÏÔʾÄÚÈÝÁË
Ïà¹ØÎÊ´ð£º
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡¡
xx.aspΪ£º
<html>
<hea ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´ ......