VCÖÐ odbc·ÃÎÊaccessÄÚ´æÔö³¤
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨Ê±Æ÷¼ä¸ô2s¡£
if(nIDEvent==1)
{
cserverrecord serverrecord(&g_datasource);
str.Format("select * from ·þÎñÆ÷¹ÜÀí where ·þÎñÆ÷±àºÅ=%d",i);
serverrecord.Open(CRecordset::snapshot,str);
strtwo=serverrecord.m_column2;
serverrecord.Close();
GetDlgItem(IDC_STATICone)->SetWindowText(strtwo);
i++;
if (i>5)
{
i=1;
}
}
m_column2cserverrecordÊǼ̳ÐÓÚcrecordsetµÄÒ»¸öÀ࣬Õâ¶ÎÓï¾äµÄ×÷ÓþÍÊDzéÃûΪ·þÎñÆ÷¹ÜÀíµÄ±í£¬°Ñ·þÎñÆ÷±àºÅСÓÚ5µÄ¼Ç¼µÄm_column2ÖµÔÚIDC_STATIConeÏÔʾ³öÀ´£¬Êý¾ÝÔ´ÔÚ³ÌÐòÍ˳öʱ¹Ø±Õ¡£ÎÊÌâʱÕâ¶Î³ÌÐòÅÜ4Сʱ³ÌÐòÄÚ´æÔö³¤176k£¬Çë½Ì¸ßÊÖÄÄÀïÓÐÎÊÌâ¡£
4¸öСʱ²Å 176K£¬ÄǾͷÅÐĵĽÐËûÕǺÃÁË¡£
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÎÒдÁËÒ»¸öÈí¼þ£¬ÒªÓõ½ACCESSÊý¾Ý¿â£¬ÎÒÔÙ·ÃÎÊACCESSµÄʱºò£¬ÎÒÐèÒª´Ó±íÀï¶Á³öÒ»ÐÐÊý¾Ý£¬ÎҵijÌÐòÊÇÕâÑùдµÄ£¬SQLSTRING="SELECT * from '" &ME.TEXTBOX1.TEXT &"' WHERE ID = '"& ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......