¹ØÓÚOracleÊý¾Ý¿âÁ¬½Ó³¬Ê±ÎÊÌâ
ÎҵijÌÐòÐèÒªÁ¬½ÓÁíһ̨µçÄÔÉϵÄoracle·þÎñÆ÷£¬Èç¹û·þÎñÆ÷¿ªÆô£¬Á¬½Ó²Ù×÷Ò»ÇÐÕý³£¡£
µ«ÊÇÈç¹ûoracle·þÎñÆ÷ûÓпªÆô£¬³ÌÐòÒª½«½ü20²Å·µ»ØÎÞ·¨Á¬½ÓÊý¾Ý·¡£
VC³ÌÐòͨ¹ýADO·½Ê½·ÃÎÊoracleÊý¾Ý¿â
m_pConnection->ConnectionTimeout = 10; //10Ã볬ʱ
hr = m_pConnection->Open((_bstr_t)strConnection, "", "", adConnectUnspecified);
ÉÏÃæµÄ³¬Ê±Ê±¼äÉèÖúÃÏñ²»Æð×÷Óã¬ÎÞÂ۸ijɶàÉÙ£¬³ÌÐò¶¼Òª½«½ü20²Å·µ»Ø³¬Ê±¡£
´ò¸ö¶Ïµã£¬¿´¿´Ö´ÐÐÕâ¶Î³ÌÐòû£¿
¿Ï¶¨Ö´ÐÐÁË£¬¾ÍÔÚopenÕâ¸öº¯Êý×èÈûÁ˺ܾ㬴ó¸Å15Ãë
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ÔÚ´æÈ¡Ð¡Êý£¬ÀýÈç0.5µÄʱºò£¬ÎªÊ²Ã´´æÈ¡µ½Êý¾Ý¿âÖбä³É .5 µÄÐÎʽ£¿
½â¾ö·½°¸ÒѾÓÐÁË£¬ÎÒÖ÷Òª¹ØÐĵÄÊÇoracleΪʲô»áÕâô´æ´¢£¿
ÄãËù¿´µ½µÄÊÇ´æ´¢µÄÊý¾ÝµÄÏÔʾ·½Ê½£¬Ö»ÊÇÒ»¸ö±íÏ󣬲¢²»Ó°ÏìÊý¾ÝÔÚÊ ......
ÂÒÂë²úÉúÊÇÓÉÓÚ¼¸¸ö×Ö·û¼¯Ö®¼äת»»²»Æ¥ÅäÔì³É£¬·ÖÒÔϼ¸ÖÖÇé¿ö£º£¨×¢£º×Ö·û¼¯Ö®¼äÈç¹û²»´æÔÚ×Ó¼¯¡¢³¬¼¯¶ÔÓ¦¹ØÏµÊ±µÄÇé¿ö²»Ó迼ÂÇ£¬ÒòΪÕâÖÖÇé¿öÏÂ×Ö·û¼¯Ö®¼äת»»±Ø²úÉúÂÒÂ룩
1£©·þÎñÆ÷¶ËÊý¾Ý¿ ......
ÏÂÃæÕâ¶Î»°:
¿Í»§ÖÕ¶Ë×Ö·û¼¯£¬nls_lang»·¾³±äÁ¿×Ö·û¼¯£¬Êý¾Ý¿âʹÓõÄ×Ö·û¼¯¡£ÆäÖУ¬¿Í»§Öն˸÷ÖÖ¸÷Ñù£¬±ÈÈçwindowsÏÂcmd£¬unix/linuxÏÂterminal/console,ÉõÖÁÈçtoadµÈ¹¤¾ßÒ²¿ÉÒÔÀí½âΪһ¸öÖÕ¶Ë¡£ÎÒÃÇʹÓÃwindows ......
LY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.251)(PORT = 1521))
)
......