C++ÔõôÁ¬½ÓoracleÊý¾Ý¿â
ÎÒÐèÒªÓÃC++Á¬½ÓoracleÊý¾Ý¿â£¬ÓÐÄÄλ¸ßÈËÄÜÖ¸µãһϣ¬ÎÒÖ»ÐèÒªÁ¬½Ó³É¹¦£¬Íê³É»ù±¾µÄ²éѯÐÅÏ¢¾ÍºÃÁË¡£
Êý¾Ý¿âÊÇoracle9i£¬Êý¾Ý¿âÃû£ºshensuoyao£¬Êý¾Ý¿â±í£ºshensuoyao,×ֶΣºname varchar2(10),age number
Êý¾Ý¿âÓû§Ãû ssy,ÃÜÂ룺ssy
²»¹ÜÓÃʲô·½·¨£¬ÄÜÁ¬ÉÏoracle¾ÍºÃ¡£
×îºÃ¸ø³ö´úÂ룬ÓÃVC++6.0»òÕßVS2008»òVS2005±àд£¬ÐèҪд³öÏêϸµÄÅäÖá£
odbc,ado¶¼¿ÉÒÔÁ¬½Ó£¬ºÃÏñ»¹ÓÐÆäËûµÄ·½Ê½¡«
ÎÒÏëÖªµÀ¾ßÌåÒ»µãµÄ·½·¨£¬Á¬½ÓµÄʱºòÐèÒªÅäÖÃʲô£¿
Â¥ÉϵijÌÐòÎÒÄÜ×öµ½ÁË£¬ÎÒÓÃOCCIÁ¬µÄ£¬ÅäÖÃÌ«·³£¬Â¥Éϵķ½·¨¼òµ¥£¬ÎÒÏÖÔڸ㶨ÁË£¬ºÜ¸Ðл¡£
µ«ÊÇÂ¥ÉϵÄûÓÐ˵Ã÷Ôõô°Ñoci.libÎļþ°üº¬½øÈ¥¡£¿ÉÄÜÊÇĬÈÏÎÒÖªµÀµÄ°É¡£ÎÒ×òÌì²Å¿ªÊ¼Ñ§C++µÄ¡£»¹ÊÇ·ÑÁ˵ãʱ¼ä¡£
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÔÚ¸ùĿ¼/libÖдæ·ÅÒ»¸ölog.c£¬log.h£¬²¢ÓÃÏÂÃæµÄÓï¾ä£º
gcc -c log.c
ar crv liblog.a log.o
±àÒë³öÒ»¸öliblog.a¾²Ì¬¿â£¬È»ºóÔÚÎļþ¼Ð£º/testfileÖд´½¨Ò»¸ötest.cºÍtestc.c£¬test.cÖÐÒýÓÃÁËtestc.cÖж¨ÒåµÄ·½·¨ ......