Çë½ÌDRIVER={Microsoft ODBC for Oracle} Á¬½ÓÎÊÌ⣡
ÊÇÕâÑùµÄÎÒ×°ÁËһ̨2003µÄÐéÄâ»ú£¡
ÐéÄâ»úIP£º192.168.1.108
±¾»úIP£º192.168.1.100
ÎÒÔÚÐéÄâ»úÉÏ×°ÁËoracle 10G ,ÏÖÔÚÏë±àд¸ö³ÌÐò¶ÁÈ¡oracleÊý¾Ý¿âÀïµÄ¼Ç¼£¬
ÎÒÔÚ±¾»ú×°Á˸öoracle XE Client£¬ÇëÎʸÃÈçºÎÁ¬½Ó ÐéÄâ»úÉϵÄoracle
ÎÒÓà DRIVER={Microsoft ODBC for Oracle};UID=¡°system¡°;PWD=¡±5897577¡°;SERVER=¡±Êý¾Ý¿âÃû×Ö ;¡±
°ÑÎÒдµÄ³ÌÐò·Åµ½ÐéÄâ»úÉÏ¿ÉÒÔÁ¬½Ó£¬·Åµ½±¾»úÕâÑù¾Í²»ÄÜÁ¬½ÓÁË£¡
ÇëÎÊÈçºÎÐ޸ģ¬»òÕßÆäËû·½·¨£¡
ÄÇÎÒÈí¼þÖÐÔõôдÄØ£¿
ÂÛ̳ÈËÆøÔõôÕâôÉÙ
Ïà¹ØÎÊ´ð£º
ÊÇÕâÑùµÄ£¬Ç°Ð©ÌìÎÒ·¢ÁËÒ»¸öoracle¸ÄmysqlµÄÌùô£¬ÏÖÔÚÓÖÓöµ½Á˵ãÎÊÌâ¡£¡£¡£Çë´ó¼Ò°ï°ïæ
oracleÀï±ßµÄlongÐÍ Ó³Éäµ½hibernateÀï±ßÊÇlongÐ굀 £¬µ«Êǵ½ÁËmysqlÓ³ÉähibernateµÄʱºò¾ÍûÓÐlongÐÍÁË £¬¶¼ÊÇint ......
ÄÜ·ñÓÃÓï¾äʵÏÖ¡£¶ø²»ÊÇÏֳɵŤ¾ß£¿
Â¥ÉϵÄÐֵܿÉÒÔÏêϸһЩÂð£¿
×£Äã½ÚÈÕ¿ìÀÖ£¡¹þ¹þ
½ÚÈÕ¿ìÀÖ
SQL code:
Ò». µ¼³ö¹¤¾ß exp
1. ËüÊDzÙ×÷ϵͳÏÂÒ»¸ö¿ÉÖ´ÐеÄÎļþ ´æ·ÅĿ¼/ORACLE_HOME/bin
......
ÎÒÓõÄÊÇPreparedStatementÀ´·¢ËÍÌá½»£¬²¢ÇÒÊý¾ÝÁ¿·Ç³£ÅÓ´ó¡£
Ò»´ÎÐèÒªÖ´ÐÐ8900¶àÌõ¸üÐÂÓï¾ä£¬Ò²¾ÍÊÇUpdateÓï¾ä¡£
ÎÒÊÔ¹ý·Ö¿ª£¬Ò»²¿·ÖÒ»²¿·ÖÀ´Ö´ÐÐÌá½»£¬µ«»¹ÊÇÒ»ÑùµÄËÙ¶ÈÂý£¬¶øÇÒÔ½Ö´ÐÐÔ½Âý¡£ÊµÔÚÊÇûÓÐʲô ......
ORACLE´Ó9201Éý¼¶µ½9208Ö®ºó
»·¾³±äÁ¿ÖÐORACLE_HOMEûÓÐÉèÖà ÊÖ¹¤Ìí¼Óºó
ϵͳ·þÎñÀïËùÓÐORACLE·þÎñ¶¼Æð²»À´
ÃüÁîÐÐÀïÊäÈë EXP»òÕßLSNRCTL±¨ÌáʾÎÞ·¨¶¨Î»³ÌÐòÊäÈëµã lxhlcmod ÓÚ¶¯Ì¬Á´½Ó¿â oranls9.dllÉÏ
......
ÔÚ´æȡСÊý£¬ÀýÈç0.5µÄʱºò£¬ÎªÊ²Ã´´æÈ¡µ½Êý¾Ý¿âÖбä³É .5 µÄÐÎʽ£¿
½â¾ö·½°¸ÒѾÓÐÁË£¬ÎÒÖ÷Òª¹ØÐĵÄÊÇoracleΪʲô»áÕâô´æ´¢£¿
ÄãËù¿´µ½µÄÊÇ´æ´¢µÄÊý¾ÝµÄÏÔʾ·½Ê½£¬Ö»ÊÇÒ»¸ö±íÏ󣬲¢²»Ó°ÏìÊý¾ÝÔÚÊ ......