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Ä ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÓÐÒ»10*10¾ØÕ󣬳ýÈ¥µÚÒ»¸öµã£¨0£¬0£©ºÍ×îºóÒ»µã£¨9£¬9£©£¬»¹Óа˸öµãΪ1£¬ÆäËû¶¼Îª0£¬ÒªÇóÓöþάÊý×é±íʾ¡£°Ë¸öµãÊÇËæ»úÉú³ÉµÄ£¬±àдÏà¹Ø³ÌÐò±íʾ¾ØÕóËùÓпÉÄÜÇé¿ö¡£
ÕæÐÄÇó½Ì¸÷λ¸ßÊÖ£¬°¥£¡±¾ÈËÌ«²ËÁË£¡ºÇºÇ£¡
......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......