KVHTrend¿Ø¼þʹÓ÷½·¨

ÀúÊ·ÇúÏ߿ؼþʹÓ÷½·¨

KVHTrend¿Ø¼þʹÓ÷½·¨

KVHTrendÇúÏ߿ؼþÊÇ×é̬ÍõÒÔActive X¿Ø¼þÐÎʽÌṩµÄ»æÖÆÀúÊ·ÇúÏߺÍODBCÊý¾Ý¿âÇúÏߵŦÄÜÐÔ¹¤¾ß¡£Í¨¹ý¸Ã¿Ø¼þ£¬²»µ«¿ÉÒÔʵÏÖÀúÊ·ÇúÏߵĻæÖÆ£¬»¹¿ÉÒÔʵÏÖODBCÊý¾Ý¿âÖÐÊý¾Ý¼Ç¼µÄÇúÏß»æÖÆ£¬¶øÇÒÔÚÔËÐÐ״̬Ï£¬¿ÉÒÔʵÏÖÔÚÏß¶¯Ì¬Ôö¼Ó/ɾ³ýÇúÏß¡¢ÇúÏßͼ±íµÄÎÞ¼¶Ëõ·Å¡¢ÇúÏߵĶ¯Ì¬±È½Ï¡¢.ÇúÏߵĴòÓ¡µÈ¡£¸ÃÇúÏ߿ؼþ×î¶à¿ÉÒÔ»æÖÆ16ÌõÇúÏß¡£

1¡¢´´½¨ÀúÊ·ÇúÏ߿ؼþ£º

ÔÚ×é̬Íõ¿ª·¢ÏµÍ³ÖÐн¨»­Ã棬ÔÚ¹¤¾ßÏäÖе¥»÷¡°²åÈëͨÓÿؼþ¡±»òÑ¡Ôñ²Ëµ¥¡°±à¼­¡±

ϵġ°²åÈëͨÓÿؼþ¡±ÃüÁµ¯³ö¡°²åÈë¿Ø¼þ¡±¶Ô»°¿ò£¬ÔÚÁбíÖÐÑ¡Ôñ¡°ÀúÊ·Ç÷ÊÆÇúÏß¡±£¬µ¥»÷¡°È·¶¨¡±°´Å¥£¬¶Ô»°¿ò×Ô¶¯Ïûʧ£¬Êó±ê¼ýÍ·±äΪС¡°Ê®¡±×ÖÐÍ£¬ÔÚ»­ÃæÉÏÑ¡Ôñ¿Ø¼þµÄ×óÉϽǣ¬°´ÏÂÊó±ê×ó¼ü²¢Í϶¯£¬»­ÃæÉÏÏÔʾ³öÒ»¸öÐéÏߵľØÐοò£¬¸Ã¾ØÐοòΪ´´½¨ºóµÄÇúÏßµÄÍâ¿ò¡£µ±´ïµ½ËùÐè´óСʱ£¬ËÉ¿ªÊó±ê×ó¼ü£¬ÔòÀúÊ·ÇúÏ߿ؼþ´´½¨³É¹¦£¬»­ÃæÉÏÏÔʾ³ö¸ÃÇúÏߣ¬Èçͼ1Ëùʾ¡£

ͼ1 ÀúÊ·ÇúÏ߿ؼþ

2¡¢ÉèÖÿؼþ¹ÌÓÐÊôÐÔ£º

¿Ø¼þ´´½¨Íê³Éºó£¬ÔڿؼþÉϵ¥»÷ÓÒ¼ü£¬ÔÚµ¯³öµÄ¿ì½Ý²Ëµ¥ÖÐÑ¡Ôñ¡°¿Ø¼þÊôÐÔ¡±ÃüÁµ¯³öÀúÊ·ÇúÏ߿ؼþµÄ¹ÌÓÐÊôÐÔ¶Ô»°¿ò£¬Èçͼ2Ëùʾ¡£

±±¾©ÑǿؿƼ¼·¢Õ¹ÓÐÏÞ¹«Ë¾

ÀúÊ·ÇúÏ߿ؼþʹÓ÷½·¨

¿Ø¼þ¹ÌÓÐÊôÐÔº¬ÓÐÁ½¸öÊôÐÔÒ³£ºÇúÏß¡¢×ø±êϵ¡£ÏÂÃæÏêϸ½éÉÜÿ¸öÊôÐÔÒ³Öеĺ¬Òå¡£

2¡¢1 ÇúÏßÊôÐÔÒ³

Èçͼ2Ëùʾ£¬ÇúÏßÊôÐÔÒ³ÖÐϰ벿·ÖΪ¶¨ÒåÔÚ»æÖÆÇúÏßʱ£¬ÀúÊ·Êý¾ÝµÄÀ´Ô´£¬¿ÉÒÔÑ¡Ôñ×é̬ÍõµÄÀúÊ·Êý¾Ý¿â»òÆäËüÊý¾Ý¿âΪÊý¾ÝÔ´¡£

ÇúÏßÊôÐÔÒ³ÖÐÉϰ벿·Ö¡°ÇúÏß¡±ÊǶ¨ÒåÇúÏßͼ±í³õʼ״̬µÄÇúÏß±äÁ¿¡¢»æÖÆÇúÏߵķ½Ê½¡¢ÊÇ·ñ½øÐÐÇúÏ߱Ƚϵȣº

? Áбí¿ò£ºÏÔʾÒѾ­Ìí¼ÓµÄ±äÁ¿µÄÃû³Æ¼°»æÖÆ·½Ê½¶¨ÒåµÈ¡£ ? ¡°Ôö¼Ó¡±°´Å¥£ºÔö¼Ó±äÁ¿µ½ÇúÏßͼ±í£¬²¢¶¨ÒåÇúÏß»æÖÆ·½Ê½¡£

µ¥»÷¸Ã°´Å¥£¬µ¯³öÈçͼ3ËùʾµÄ¶Ô»°¿ò¡£

ͼ2 ÀúÊ·ÇúÏ߿ؼþ¹ÌÓÐÊôÐÔ

±±¾©ÑǿؿƼ¼·¢Õ¹ÓÐÏÞ¹«Ë¾

ÀúÊ·ÇúÏ߿ؼþʹÓ÷½·¨

ͼ3 Ôö¼ÓÇúÏß

?

±äÁ¿Ãû³Æ£ºÔÚ¡°±äÁ¿Ãû³Æ¡±Îı¾¿òÖÐÊäÈëÒªÌí¼ÓµÄ±äÁ¿µÄÃû³Æ£¬»òÔÚ×ó²àµÄÁбí¿òÖÐÑ¡Ôñ£¬¸ÃÁбí¿òÖÐÁгöÁ˱¾¹¤³ÌÖÐËùÓж¨ÒåÁËÀúÊ·¼Ç¼ÊôÐԵıäÁ¿£¬µ¥»÷Êó±êÑ¡Ôñ£¬ÔòÑ¡ÖеıäÁ¿Ãû³Æ×Ô¶¯Ìí¼Óµ½¡°±äÁ¿Ãû³Æ¡±Îı¾¿òÖС£ ÇúÏß¶¨Ò壺

ÏßÀàÐÍ£ºµ¥»÷¡°ÏßÀàÐÍ¡±ºóµÄÏÂÀ­Áбí¿ò£¬Ñ¡Ôñµ±Ç°Ñ¡ÔñµÄ±äÁ¿»æÖÆÇúÏßʱµÄÏßµÄÀàÐÍ¡£

ÏßÑÕÉ«£ºµ¥»÷¡°ÏßÑÕÉ«¡±ºóµÄ°´Å¥£¬ÔÚµ¯³öµÄµ÷É«°åÖÐÑ¡Ôñ»æÖƵÄÇúÏßµÄÑÕÉ«¡£

»æÖÆ·½Ê½£ºÇúÏߵĻæÖÆ·½Ê½ÓÐËÄÖÖ£ºÄ£Äâ¡¢½×ÌÝ¡¢Âß¼­¡¢°ôͼ£¬¿ÉÒÔÈÎѡһÖÖ¡£

Òþ²ØÇúÏߣºÊÇ·ñÔÚ»æÖÆÇúÏßʱ³õʼÉèÖÃÒþ²Øµ±Ç°»æÖƵÄÇúÏß¡£ ?

ÇúÏ߱ȽϣºÍ¨¹ýÉèÖÃÇúÏ߱ȽÏʱ¼ä²î£¬Ê¹ÇúÏß»æÖÆÎ»ÖÃÓÐÒ»¸öʱ¼äÖáÉÏµÄÆ½ÒÆ£¬ÕâÑùͨ¹ý¹ØÁªµÄ±äÁ¿ÃûÏàͬ£¬µ«Ò»¸öÊÇÏÔʾÓëʱ¼äÖáÏàͬµÄʱ¼äµÄÊý¾Ý£¬ÁíÒ»¸ö×÷±È½ÏµÄÇúÏßÏÔʾÓëʱ¼äÖáµÄʱ¼ä²îΪij¸öÖµµÄÊý¾Ý£¨ÈçÒ»Ììǰ£©£¬´Ó¶ø´ïµ½ÓÃÁ½ÌõÇúÏßÀ´ÊµÏÖÁËÇúÏ߱ȽϵÄÄ¿µÄ¡£ ?

Êý¾ÝÀ´Ô´£ºÑ¡ÔñÇúÏßʹÓõÄÊý¾ÝÀ´Ô´£¬¿Éͬʱ֧³Ö×é̬ÍõÀúÊ·¿âºÍODBCÊý¾ÝÔ´¡£ÈôÑ¡ÔñODBCÊý¾ÝÔ´£¬±ØÐëÏÈÅäÖÃÊý¾ÝÔ´.¾ßÌåÅäÖ÷½·¨ÈçÏ£º

1¡¢ Æô¶¯¿ØÖÆÃæ°åÖеÄÊý¾ÝÔ´ODBC¡£µ¥»÷¡°ÏµÍ³DSN¡±Ïî¡£µ¥»÷¡°Ôö

¼Ó¡±£¬µ¯³ö¡°´´½¨ÐÂÊý¾ÝÔ´¡±¶Ô»°¿ò¡£

2¡¢ Ñ¡ÔñËùÐèÊý¾ÝÔ´µÄÇý¶¯Èç¡°Microsoft Accress Driver(*.mdb)¡±£¬µ¥»÷¡°Íê³É¡±°´Å¥¡£µ¯³ö¡°ODBC Microsoft Accress°²×°¡±¶Ô»°¿ò¡£ 3¡¢ ÔÚ¡°Êý¾ÝÔ´Ãû¡±Öж¨ÒåÒ»¸öÊý¾ÝÔ´Ãû³Æ£¬Êý¾Ý¿â¡°Ñ¡Ôñ¡±ÖÐÑ¡Ôñ

ÇúÏßÊý¾ÝËùÔÚµÄÊý¾Ý¿â£¬´ËÊý¾Ý¿âµÄ±íÖÁÉÙÓÐÈý¸ö×ֶΣºÊ±¼ä×ֶΡ¢Êý¾Ý×ֶΡ¢ºÁÃë×ֶΡ£µ¥»÷¡°È·¶¨¡±£¬Ð´´½¨µÄÊý¾ÝÔ´¾ÍÌí¼Óµ½¡°ÏµÍ³DSN¡±ÁбíÖС£

Êý¾ÝÔ´£ºÑ¡ÔñÇúÏßʹÓõÄÊý¾Ý¿â£¬ÔÚµ¯³öµÄ¡°Select Data Source¡±ÖÐ

Ñ¡ÔñÉÏÃæ¶¨ÒåµÄÊý¾ÝÔ´¡£ ±íÃû³Æ£ºÑ¡ÔñÇúÏßʹÓõÄÊý¾ÝÀ´×ÔËùÑ¡Êý¾Ý¿âµÄijһ¸ö±í ʱ¼ä×ֶΣºÑ¡ÔñÇúÏßÊý¾Ý¶ÔÓ¦µÄʱ¼ä¼Ç¼£¬ÈÕÆÚ/ʱ¼äÀàÐÍ Êý¾Ý×ֶΣºÑ¡ÔñÇúÏß¶ÔÓ¦µÄÊý¾ÝÖµ£¬³¤ÕûÐÍ»ò¸¡µãÐÍ ºÁÃë×ֶΣºÑ¡ÔñÇúÏßÊý¾Ý¶ÔÓ¦µÄºÁÃë¼Ç¼£¬Êý×ÖÀàÐÍ

ÎÞЧֵ£ºÃ¿Ò»ÌõÇúÏß¶¼ºÍ±íÖÐÒ»¸ö±íʾÆäÖµµÄ×ֶιØÁª£¬Õâ¸ö×ֶεÄÖµÔÚijһʱµã¿ÉÄÜÊÇÎÞЧµÄ£¬µ«±íµÄ½á¹¹¾ö¶¨ÁËÕâ¸ö×Ö¶ÎÔÚÒ»Ìõ¼Ç¼ÖеÄÖµ²»ÄÜΪ¿Õ°×£¬ËùÒÔ¾ÍÓÐÁËÎÞЧֵµÄ¶¨Òå¡£

±ÈÈ磺1£©µ±±íÖÐÊýÖµ×ֶεÄֵΪNULLʱ±íʾ¸ÃµãÊý¾ÝÎÞЧ£¬ÄÇô

ÅäÖÃÎÞЧֵʱ¾Í¿ÉÒÔ¿Õ¡£

2£©µ±±íÖÐÊýÖµ×ֶεÄֵΪ0ʱ±íʾ¸ÃµãÊý¾ÝÎÞЧ£¬ÄÇôÅäÖÃÎÞ

Чֵʱ¾Í¿ÉÒÔд0¡£

3£©µ±±íÖÐÊýÖµ×ֶεÄֵΪ¡°abcd¡±Ê±±íʾ¸ÃµãÊý¾ÝÎÞЧ£¬ÄÇô

±±¾©ÑǿؿƼ¼·¢Õ¹ÓÐÏÞ¹«Ë¾

?

ÀúÊ·ÇúÏ߿ؼþʹÓ÷½·¨

ÅäÖÃÎÞЧֵʱ¾Í¿ÉÒÔд¡°abcd¡±¡£

Ñ¡ÔñÍê±äÁ¿²¢ÅäÖÃÍê³Éºó£¬µ¥»÷¡°È·¶¨¡±£¬ÔòÇúÏßÃû³ÆÌí¼Óµ½¡°ÇúÏßÁÐ

±í¡±ÖС£Èçͼ4Ëùʾ£º

ͼ4 Ôö¼Ó±äÁ¿µ½ÇúÏßÁбí

ÈçÉÏËùÊö£¬¿ÉÒÔÔö¼Ó¶à¸ö±äÁ¿µ½ÇúÏßÁбíÖС£

? ¡°É¾³ý¡±°´Å¥£ºÉ¾³ýµ±Ç°Áбí¿òÖÐÑ¡ÖеÄÇúÏß¶¨Òå¡£ ? ¡°Ð޸ġ±£ºÐ޸ĵ±Ç°Áбí¿òÖÐÑ¡ÖеÄÇúÏß¶¨Òå¡£

? ¡°ÏÔʾÁÐ±í¡±Ñ¡ÏÊÇ·ñÏÔʾÈçͼ1ÖеÄÇúÏß±äÁ¿ÁÐ±í¡£ ? Êý¾ÝÔ´£ºÏÔʾÇúÏßʹÓÃÊý¾ÝÔ´µÄÐÅÏ¢¡£

2.2 ×ø±êϵÊôÐÔÒ³

Èçͼ2£¬µ¥»÷¡°×ø±êϵ¡±±êÇ©£¬½øÈë×ø±êϵÊôÐÔÉèÖÃÒ³£¬Èçͼ5Ëùʾ¡£

±±¾©ÑǿؿƼ¼·¢Õ¹ÓÐÏÞ¹«Ë¾

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ìæ»»Îª@)