c++ÔÚlinuxÏÂÔõôÑùÁ¬½ÓoracleÊý¾Ý¿â£¿
1¡¢Á¬½ÓÊý¾Ý¿âµÄÅäÖÃÎļþ¶¼ÐèÒªÄÄЩÄÚÈÝ£¿ ÎÒÖªµÀµÄÓÐÍøÂç·þÎñÃû¡¢Óû§ÃûºÍÃÜÂë¡£»¹ÐèÒªÆäËûµÄÂð£¿×îºÃ¸ø³öÀý×Ó£¡ 2¡¢ËÄܸø³öÒ»·Ýc++ÔÚlinuxÏÂÁ¬½ÓoracleµÄ´úÂëʵÀý£¬Ð»Ð»£¡
ÎÒÖ»ÖªµÀoracleÅäÖõ½ODBC. È»ºóOTL·ÃÎÊODBC¡£ oracle ÓÐAPIº¯Êý¿ÉÒÔÖ±½ÓÓᣠ¥Ö÷¿´¿´°É¡£ PROCÒýÓà PROC ÄÜ·ñ¸ø¸ö¾ßÌåÀý×Ó°¡£¿ proc»òÓÃoci¿â¶¼¿ÉÒÔ£¬oracle for linuxÏÂÁ½¸öµÄÀý×Ó¶¼ÓÐ ÅäÖÆÓëwindowsÒ»Ñù£¬ÔÚoracle_homeÏÂÓÐnetwork/admin/tnsnames.oraÎļþ£¬°ÑwindowsµÄÕâ¸öÅäÖÆÎļþCOPY¹ýÈ¥Ò²¿ÉÓá£ÒýÓà ÎÒÓÐÒ»·Ý¿ªÔ´µÄC++·â×°µÄOCI½Ó¿Ú£¬Ê¹Ó÷½Ê½ºÜ¼òµ¥£¬ÓëjavaµÄjava.sql.*ʹÓ÷½Ê½ºÜÀàËÆ¡£ÐèÒªµÄ»°Áô¸öÓÊÏä¡£ ÒÔÏÂÊDz¿·ÖÍ·Îļþ£¬¹©Ô¤ÀÀ¡£ C/C++ code/* #ifdef ORACALL32_EXPORTS #define __declspec(dllexport) #else #define __declspec(dllimport) #endif*/ #include<time.h>struct OCIEnv;struct OCIError;struct OCISvcCtx;struct OCIStmt;struct OCIDescribe;struct OCILobLocator;class CStatement;class CResultSet;/* * This class represents a connection to ORACLE database.*/class CConnection { friendclass CStatement; friendclass CResultSet;public: CConnection();virtual~CConnection();int connect(constchar*username,constchar*password,constchar*dblink);int disconnect();int commit();int rollback(); CStatement* createStatement(); CResultSet* getTableComments();
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
SHIFT¼ÓF10ÓëÄǸö¼üÓÒctrl±ßÉϵÄÄǸö¼ü¹¦ÄÜÒ»Ñù£¬ÏëÆÁÕâ¸ö µ«²»ÖªÒªÔõôдÄǸö×éºÏ¼ü£¡ ÓÐûÄĸö´óÏÀ·ÅÒ»¶ÎÕâ¸öµÄ´úÂë»òдһ¶Î http://topic.csdn.net/u/20090609/15/7dc9fb70-243f-4070-9cfd-34e48b66e6c6.html
......
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡ ·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£ ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......