Python Á¬½Ó Oracle Êý¾Ý¿â
¸÷λºÃ£¬Ð¡µÜÎÒÓöµ½Ò»¸öÎÊÌ⣬ÎÒÊÔ×ÅÓÃPython´ÓÎÒµÄLinuxÉÏÈ¥Á¬½Óһ̨Զ³ÌµÄOracleÊý¾Ý¿â·þÎñÆ÷£¬È»ºóÔÚÍøÉÏÕÒÁËÒ»¸ö½Ð×öcx_OracleµÄÒ»¸ölib£¬¿ÉÔÚÎÒÖ´ÐÐsetup³ÌÐòµÄʱºò±¨ÁËÒ»¸ö´í£º
Traceback (most recent call last):
File "setup.py", line 123, in ?
raise DistutilsSetupError("cannot locate an Oracle software " \
distutils.errors.DistutilsSetupError: cannot locate an Oracle software installation
ÎÒ¶ÙʱɵÑÛÁË£¬Ôõô»¹ÒªÎÒÔÚ±¾µØ×°ÓÐOracleÂð£¿ÎÒÐÄÏëÓ¦¸Ã²»»áÓÐÕâÖÖÏÞÖÆÑ¾£¬ÓÐÄÇλ´óϺ¿ÉÒÔ¸æËßÎÒÔõô½â¾öÕâ¸öÎÊÌ⣿
лл¡£
±¾µØÒª×°Oracle Client
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
¿ÉÊÇ¡£ÎұȽÏÄÉÃÆµÄÊÇΪʲôJDBCÁ¬½ÓµÄʱºò²»ÐèÒªinstantclientÄØ£¿
ÄãÓ¦¸ÃÏȸãÒ»¸ãoracle×î»ù´¡µÄ¶«Î÷£¬±ÈÈçoracle net¡£
Èç¹û¾OCIÈ¥Á¬oracle serverµÄ£¬ÒªÓÃinstant client¡£¶øthin client¾Í²»ÐèÒª¡£ËùÒÔJDBC OCI Ò²ÒªÓÃinstant client¡£¶øJDBC thin drivers £¬¾Í²»ÐèÒª£¨Ó¦¸ÃÊÇͨ¹ýsocket£©
ÊÇÕâÑùµÄ£®¡¡ÄãµÃÔÚ±¾µØ°²×°cx_Oracle¡¡¿Í·þ¶Ë£®£®
ÎÒÃǹ«Ë¾·þÎñÆ÷ÉÏ×°µÄÊÇ£±£°£Ç¡¡¡¡£¬
ÎÒ±¾µØ×°µÄÊÇcx_Oracle-5.0.2-10g.win32-py2.5.msi£®
µ½¹ÙÍøÈ¥ÏÂÒ»¸ö°É£¬¡¡¶ÔÓ¦ÄãÒªÁ¬µÄ·þÎñÆ÷Oracle°æ±¾ÒÔ¼°Äã±¾»úPython°æ±¾£®
¶àл¸÷λ½â´ð£¬¿´À´¹é¸ù½áµ×»¹ÊÇOracleÌ«Èõ¡£
Ïà¹ØÎÊ´ð£º
ÒÑÖªPython ÖУº
s = unicode("²âÊÔ", "gb2312")
s = u'\u6d4b\u8bd5'
print s
²âÊÔ
ÔÚDelphiÀïÃæÈçºÎ½«\u6d4b\u8bd5ÕâÑùµÄ»¹Ô³ÉGb2312µÄºº×ÖÄØ£¿
ÕÒµ½¸ö·½·¨
......
±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......
ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©
ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿
¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡
Ò»°ã ......
Ï뿼¸öocpÈÏÖ¤£¬µ±È»£¬Ò²ÏëºÃºÃѧµã¶«Î÷¡£
¿ÉÒÔ×ÔѧµÄ£¡
¸öÈ˾õµÃÖ»ÒªÕÆÎÕÁËÊý¾Ý¿âµÄ»ù±¾ÀíÂÛ£¬Âò²Î¿¼Êé×Ôѧ±È½Ïʵ¼Êµã£¬
ÌØ±ðÊÇÅàѵ̫¹ó²¢ÇÒ²»¿ÉÄÜѧµ½ºÜ¶à¶«Î÷£¡
Êý¾Ý¿âÊǸö³¤ÆÚµÄѧϰ¹ý³Ì£¬Â¥Ö÷¿ÉÒÔÂý ......