python连接数据库程序包(Oracle Informix DB2)

Open Source Python/Oracle Utility - cx_Oracle cx_Oracle is a Python extension module that allows access to Oracle and conforms to the Python database API 2.0 specifications with a few exceptions. See http://www.python.org/topics/database/DatabaseAPI-2.0.html for more information on the Python database API specification. For comments, contact Anthony Tuininga at [email protected] or use the mailing list at http://lists.sourceforge.net/lists/listinfo/cx-oracle-users BINARY INSTALL: Place the file cx_Oracle.pyd or cx_Oracle.so anywhere on your Python path. SOURCE INSTALL: This module has been built with Oracle 8.1.7, 9.2.0 and 10.1.0 on Linux, Solaris, HP/UX, Tru64 Unix and Windows. It will likely build on other platforms and other Oracle versions but I haven't tried them. Use the provided setup.py to build and install the module which makes use of the distutils module. Note that on Windows, I have used mingw32 (http://www.mingw.org) and the module will not build with MSVC without modification. USAGE EXAMPLE: import cx_Oracle # connect via SQL*Net string or by each segment in a separate argument #connection = cx_Oracle.connect("user/password@TNS") connection = cx_Oracle.connect("user", "password", "TNS") cursor = connection.cursor() cursor.arraysize = 50 cursor.execute(""" select Col1, Col2, Col3 from SomeTable where Col4 = :arg_1 and Col5 between :arg_2 and :arg_3""", arg_1 = "VALUE", arg_2 = 5, arg_3 = 15) for column_1, column_2, column_3 in cursor.fetchall(): print "Values:", column_1, column_2, column_3 EXCEPTIONS: A couple of exceptions to the API specification as these reference features that I have never used or represent difficulties with the API specification: 1) The cursor method nextset() Not supported by Oracle. 2) The constructor Binary() Not implemented. Simply pass a string where a binary value is required and use setinputsizes(value = cx_Oracle.BINARY) or setinputsizes(value = cx_Oracle.LONG_BINARY) to indicate that a binary value is being passed. Please see the included documentation for additional information.