·¢ÏÖACCESSµÄBUG
ÏÈ´´½¨Ò»¸ö±í,
È»ºóÆôÓÃÊÂÎñ,
½Ó×Åɾ³ýÒ»¸ö²»´æÔڵļǼ,
ÔÙɾ³ý±í,
×îºó½áÊøÊÂÎñ,
ÔËÐÐʱÔÚɾ³ý±íʱ³ö´í£¬
ADOµÄ±¨´íÐÅÏ¢ÊÇ£º
ÓÉÓÚ±í 'ssss' Õý±»±ðµÄÓû§»ò½ø³ÌʹÓã¬Êý¾Ý¿âÒýÇæÎÞ·¨Ëø¶¨Ëü¡£
ÒÔÉÏ´úÂëÔÚʹÓÃOracleʱ˳ÀûÔËÐÐͨ¹ý£¬
Ψ¶ÀACCESS²»ÐУ¬
Èç¹ûÈ¥µôÊÂÎñµÄ´úÂë¾ÍûÎÊÌ⣬
Èç¹ûֻȥµôɾ³ý¼Ç¼µÄ´úÂëҲûÎÊÌ⣬
Èç¹û°Ñɾ³ý¼Ç¼µÄ´úÂë¸ü»»³É¼ìË÷¼Ç¼ҲûÎÊÌ⣬
µ«ÊÂÎñºÍɾ³ý¼Ç¼µÄ´úÂëͬʱ´æÔÚ¾ÍÓÐÎÊÌ⣬
ÎÒÊÇÔÚVS2008ÉÏʹÓÃADO£¬
Microsoft.Jet.OLEDB.4.0ºÍMicrosoft.ACE.OLEDB.12.0¶¼ÊÔ¹ý£¬
¶¼ÓÐÕâ¸öÎÊÌ⣬
Ôõô¿´¶¼ÏñÊÇACCESSµÄBUG¡£
´úÂëÈçÏ£º
#include <locale.h>
#include <atlstr.h>
#include <atlcom.h>
#import "c:\Program Files\Common Files\System\ado\msado15.dll" rename_namespace("ADO_ns") rename("EOF","ADO_EOF")
#import "c:\Program Files\Common Files\system\ado\msadox.dll" rename_namespace("ADO_EX_ns")
void Init(ADO_ns::_ConnectionPtr& clConnection)
{
if (FAILED(clConnection.CreateInstance(__uuidof(ADO_ns::Connection))))
{
throw 0;
}
try
{
ADO_EX_ns::_CatalogPtr clLocal = NULL;
if (FAILED(clLocal.CreateInstance((
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......