¶¨Ê±Ð´ÈëADO accessÊý¾Ý¿â ÄÚ´æÔö¼Ó
HRESULT hr=pApp->m_pRecordset->Open(sql.AllocSysString(),pApp->m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
if(!SUCCEEDED(hr))
{
AfxMessageBox("´³ö´í");
return false;
}
if(pApp->m_pRecordset!=NULL)
{
pApp->m_pRecordset->Close();
}
˵Ã÷:pApp->m_pRecordset,pApp->m_pConnection¶¼ÊÇÔÚ³ÌÐò¼ÓÔØÊ±³õʼ»¯µÄ£¬ÎÒ¶¨Ê±2ÃëÖÓÈ¥´ò¿ªºÍ¹Ø±ÕÒ»¸ö¼Ç¼¼¯£»
³ÌÐòÖ´ÐÐÁË100´ÎµÄʱºò£¬ÄÚ´æ´ó¸ÅÔö¼ÓÁË80K,ÓÉÓÚϵͳÊÇÒª24СʱÔÚÏߵģ¬ÇëÎʸ÷λ³öÏÖÕâÖÖÇé¿öµÄÔÒòÊÇʲô°¡£¿£¿£¿£¿£¿£¿£¿
ÏîÄ¿µ÷µ½ÕâÀ│סÁË£¬²âÊÔÁËÒ»Ì죬»¹ÊÇûÓÐɶ½øÕ¹°¡£¿£¿£¿
ÓÉÓڼǼ¼¯ÊÇÔÚ³ÌÐòÆô¶¯Ê±::CoInitialize(NULL);
HRESULT hr;
try
{
hr = m_pConnection.CreateInstance("ADODB.Connection");//´´½¨Connection¶ÔÏó
if(SUCCEEDED(hr))
{
hr = m_pConnection->Open(
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=m_data.mdb",
"","",adModeUnknown);
}
}
catch(_com_error e)/
{
CString errormessage;
AfxMessageBox(errormessage
return FALSE;
}
m_pRecordset.CreateIns
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()
¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...
Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!
(ÔÚA ......
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:
<?xml version="1.0" encoding="utf-8"? ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
²éÁ˺ó¤ºÃ³¤Ê±¼ä£¬ÎÊÌâÖÕÓÚ½â¾ö£¬Ï£ÍûÓÐÕâÑùµÄÎÊÌâµÄÅóÓÑÉÙ×ßЩÍä·¡£
×¢Ò⣬ÎÒÕâÀïʱºòËù˵µÄÊÇÖ»ÓÐÒýÓÃÊý¾Ý¿âµÄÖÐÎÄÂÒÂë£¬Ò³ÃæÆäËûÖÐÎÄÕý³££¬ÆäËûÇé¿öÔò²»Ò»¶¨ÊÊÓá£
ÔÚÏÖÊµÒ³Ãæ×î¶¥¶Ë¼ÓÈëÏÂÃæÁ½¾ä£º
......