ÈçºÎ½«XMLÊý¾Ý´æÈëACCESSÊý¾Ý¿â
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡ ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë XML code: <?xml version="1.0" encoding="utf-8"?> <?xml-stylesheet type="text/xsl" href="inc/sq.xsl"?> <Information> <Station> <Company>³¤½</Company> <name>99Õ¾</name> <inflow>30200</inflow> <outflow>30200</outflow> <reslevel>147.72</reslevel> <output>17190</output> <time>2009-08-23 8:00:00</time> </Station> <Station> <Company>»ÆºÓ</Company> <name>33µçÕ¾</name> <inflow>30200</inflow> <outflow>25600</outflow> <reslevel>65.5</reslevel> <output>17789</output> <time>2009-08-24 8:01:00</time> </Station> </Information>
access²»Ö§³ÖxmlÎļþÀàÐÍ,Ö»ÄܶÁ³öÀ´xmlÊý¾ÝÓÃÑ»·insert½øaccess Òª²»¾ÍÉèΪ´ó×Ö¶ÎÀ´µ±×Ö·û´®´æ£¬SQL2005ÀïÓÐXMLÀàÐ͵Ä×ֶΣ¡ÒýÓà access²»Ö§³ÖxmlÎļþÀàÐÍ,Ö»ÄܶÁ³öÀ´xmlÊý¾ÝÓÃÑ»·insert½øaccess Õâ¸öÄܲ»ÄÜ˵Ïêϸµã°¡£¬ÎÒûÓÐ×ö¹ý£¬ÓÐÏêϸµÄ´úÂë¾ÍºÃÁË Õâ¸öÄܹ»Åжϵ±Ç°µÄXMLÎļþ¸üк󣬾ÍÀ´Ñ»·µÄ½«Êý
Ïà¹ØÎÊ´ð£º
<?php include("adodb/adodb.inc.php"); $db = &NewADOConnection("access"); $access = realpath("Data.mdb"); $dsn = "Provider=Microsoft.J ......
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ ±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ËüµÄ¶¨ÒåÊÇÕâÑùµÄ _CRTIMP __checkReturn int __cdecl _access(__in_z const char * _Filename, __in int _AccessMode); ´ó¸ç£¬¿´¸öº¯ÊýÉùÃ÷¾ÍÄÜ¿´³öËû¸ÉɶµÄ£¿ ´ÓÃüÃûÀ´¿´Ó¦¸ÃÊÇÅж ......
ÎÒ°ÑsqlµÄÊý¾Ý¿â»»ÎªaccessÊý¾Ý¿â£¬Ö»ÐÞ¸ÄÁËÁ¬½ÓÎļþ£¬ÆäËüµÄ¶¼Ã»Óиı䣬³öÏÖ´íÎó(0x80004005) 無·¨Ö¸³öµÄ錯誤¡£ function returnrsByParam(strsql,con,cursor_type,lock_type,options) ......