ΪʲôÎÒÓÃVC+ADOÔÚ¶ÁÈ¡AccessÊý¾Ý¿âµÄ±í
ΪʲôÎÒÓÃVC+ADOÔÚ¶ÁÈ¡AccessÊý¾Ý¿âµÄ±íʱ£¬µ±¼Ç¼ÊýÉÙÓÚ15000Ìõʱû´í£¬¶ø¼Ç¼Êý´óÓÚ15000Ìõʱ¾Í¶Áȡʧ°Ü£¬±íÄÚÓÐVALUE£¬STIE_NAME,X,Y,LINE ÎåÁУ¬ÎÒÊÇÕâÑù×öµÄ£¬Ïȶ¨ÒåÒ»¸ö½á¹¹Ìå
struct BusPoint
{
CString m_VALUE[30000];
CString m_SITE_NAME[30000];
double m_X[30000],m_Y[30000];
CString m_LINE[30000];
};
ÔٰѶÁÈ¡µÄ×ֶδ洢ÔڽṹÌåBusPointÖУ¬
ÕâÊǶÁÈ¡Êý¾ÝµÄ´úÂ룺
_variant_t var;
long i=0,j=0,k=0,l=0,m=0; //ÓÃÓÚÑ»·
double m_X,m_Y;//·Ö±ðÓÃÓÚ´æ´¢XºÍY×ֶεĺÍ
//¶¨ÒåÁ½¸öBusPoint½á¹¹Ìå
BusPoint buspoint;
BusPoint1 buspoint1;
//ÓÃtry....catchÓï¾äÈ¥²¶×½³ÌÐòÖÐÔËÐеĴíÎó£¬ÒòΪ¿ÉÄÜ»áÓÐÒâÏë²»µ½µÄ´íÎó³öÏÖ
//¶ÁÈ¡±íÄÚµÄÊý¾Ý´æ´¢ÔÚbuspoint½á¹¹ÌåÖÐ---------------------------------------------------------------------------------
try
{
if(!m_pRecordset->BOF) //ÅжϼǼָÕëÊÇ·ñÊÇÖ¸ÔÚÊ׼Ǽ
m_pRecordset->MoveFirst(); //½«¼Ç¼ָÕëÒÆµ½Ê׼Ǽ
else
{
AfxMessageBox("±íÄÚÊý¾ÝΪ¿Õ");
return;
}
while(!m_pRecordset->adoEOF)
{
//¶ÁÈ¡VALUE×Ö¶ÎÖеÄÖµ
var = m_pRecordset->GetCollect("VALUE");
if(var.vt != VT_NULL)  
Ïà¹ØÎÊ´ð£º
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:
<?xml version="1.0" encoding="utf-8"? ......
jsp¿ª·¢µÄʱºòÄܹ»µ¼³öwordºÍexcel£¬µ«ÊÇÊÇ·ñÄܹ»Ö±½Óµ¼³öΪacess¸ñʽ¡¢dbf¸ñʽµÄÎļþ£¿
¸ßÊÖÖ¸µãÏ£¬×îºÃÄܹ»¸ø¸öÀý×Ó£¬Ð»Ð»£¡£¡£¡
javadbfÕâ¸öjarÒ»ÇÐÎÊÌâ½â¾öÁË¡£
ÏÂÔØµØÖ·Îª£ºhttp://sarovar.org/projects/ ......