access δָ¶¨´íÎó
access δָ¶¨´íÎó
·Åµ½IISÉÏˢм¸´Î¾Í»á³öÏÖ
ʹÓö¯ÈíµÄDbHelperOleDb.csÀà·ÃÎÊDatabase.accdbÊý¾Ý¿â
ˢм¸´Î¾Í»á³öÏÖ???
»¹ÓÐÕý³£µÄʱºò£¿
ÊÇ·ñ´ò¿ªÁËÊý¾Ý¿â£¬ÓÃÍêδ¶Ï¿ª£¨¹Ø±Õ£©Á¬½Ó£¿
ÓÑÇé°ï¶¥
×Ô¼º½â¾öÁË£¬ÊÇExecuteReaderÕâ¸öÔĶÁÆ÷£¬ËûÔÚUSINGÖв¢Ã»Óйرգ¬ÔÚËû¶ÁÈ¡µÄʱºóÒª±£³ÖÁ¬½Ó£¬¿ÉÊÇËû¶ÁÈ¡ºóUSING²¢Ã»Óм°Ê±µÄ»ØÊÕ£¬ËùÒÔ²ÅÕâÑù£¬ÎÒ×Ô¼º¸ø¹ØÁËһϾͺÃÁË
Óö¯ÈíµÄÀà¿ÉҪСÐÄÁË
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
ÎÒÊÖ¶¯Ìí¼Ó»ùÓÚCRecordSetÀàµÄÅÉÉúÀàCODBCDemoSetÀà,ÊÇÀûÓÃclass wizardÌí¼ÓµÄ¡£²¢ÇÒ¶¨ÒåÁËÒ»¸öÈ«¾Ö±äÁ¿CODBSDemoSet*m_pCommon.µ«ÊÇÎÒ³ÌÐò²»ÄÜÔËÐС£ÎÒ¸ú×ÙÁËһϣ¬µ½ÁËm_pCommon->Isopen£¨£©´¦·¢Éú´íÎ󣬣 ......