鎵撳紑
2007
鏁版嵁搴?/p>
澶栭儴鏁版嵁搴?/p>
1.
鎵撳紑
(
鈥?/p>
ODBC;DSN=MS Access Database;DBQ=
鈥?/p>
锛?/p>
鍙栬繍琛岀洰褰?/p>
()
锛?
鈥?
\
鏁?
鎹?
搴?
.accdb;Driver={Microsoft
Access
Driver
(*.mdb,
*.accdb)};;DriverId=25;FIL=MS
Access;MaxBufferSize=2048;PageTimeout=5;PWD=
鈥?/p>
, ,
鐪?/p>
)
鏄撹瑷�瀵?/p>
ACCESS
鏁版嵁搴?/p>
瀛︿範浣跨敤鏁版嵁搴擄紝闅惧厤瑕佷娇鐢?/p>
SQL
璇彞銆傚閮ㄦ暟鎹簱浣跨敤
SQL
璇彞鍙互蹇�熷湴瀹屾垚
瀵规暟鎹簱鐨勭绉嶆搷浣滐紝濡傦細鏌ヨ銆佷慨鏀广�佹彃鍏ヨ褰曘�佸垹闄よ褰曠瓑銆傝嚦浜庢洿澶氱殑锛屾瘮濡傦細鍒?/p>
寤鸿〃銆佸垹闄よ〃銆佸姞瀵嗘暟鎹瓑绛夛紝绛夋垜浠兘澶熸瘮杈冪啛缁冨湴鎺屾彙鏁版嵁搴撶殑鎿嶄綔鍐嶇爺绌躲�?/p>
涓�銆佸熀鏈懡浠ゆ牸寮?/p>
1
銆佹煡璇㈣褰?/p>
鍩烘湰鏍煎紡锛?/p>
select
瀛楁鍚?/p>
from
琛ㄥ悕
where
鏉′欢
渚嬪锛?/p>
瑕佹煡璇?/p>
鈥滃憳宸ヨ〃锛備腑
鈥滃紶涓夛紓鐨勪俊鎭紝
鍙互杩欎箞鍐欙細
鈥?/p>
select * from
鍛樺伐琛?/p>
where
濮撳悕
='
寮犱笁
'
锛傘�傝繖閲岋紝
鈥滃憳宸ヨ〃锛傛槸瑕佹煡璇㈢殑琛ㄧ殑鍚嶇О锛?/p>
鈥滃鍚嶏紓鏄瓧娈靛悕绉般�?/p>
濡傛灉瑕佹煡璇㈢殑鏄紶涓夌殑鐢佃瘽鍛紵灏卞緱杩欎箞鍐欙細
鈥?/p>
select
鐢佃瘽
from
鍛樺伐琛?/p>
where
濮?/p>
鍚?/p>
='
寮犱笁
'
锛傘�?/p>
鈥滅數璇濓紓涔熸槸璇ヨ〃涓殑瀛楁銆?/p>
濡傛灉瑕佹煡璇㈡暣涓〃鐨勪俊鎭紝灏变笉闇�瑕佸姞鈥?/p>
where
锛傘�傛瘮濡傦紝瑕佹煡璇⑩�滃憳宸ヨ〃锛備腑鎵�鏈?