在Python中分别通过pypyodbc和cx_Oracle来访问数据库

import cx_Oracle
import pypyodbc

#[以下使用pypyodbc方式进行查询
db_conn = pypyodbc.connect ('DSN=NEWDEVDB;PWD=xxx')
db_curs = db_conn.cursor()
db_curs.execute('select * from kdcust.t_kfzl where zllsh > %d' % (20))
for d in db_curs.description:
    print (d[0], end=" ")
print ('\n')

for row in db_curs.fetchall():
    for field in row:
        print (field, end=" ")
    print ('')

db_curs.close()
db_conn.close()
#]

#[以下使用cx_oracle方式进行查询
print ('\n----------cx_Oracle----------')
db_conn = cx_Oracle.connect('xxx', 'xxx', '17x.16x.12x.18x:1521/newdevdb')
print (db_conn.version)

db_curs = db_conn.cursor()
db_curs.execute('select * from kdcust.t_kfzl where zllsh > %d' % (20))
for d in db_curs.description:
    print (d[0], end=" ")
print ('\n')

for row in db_curs.fetchall():
    for field in row:
        print (field, end=" ")
    print ('')

db_curs.close()
db_conn.close()

#]

说明：

1) 通过pypyodbc方式访问，须先建立ODBC。如图所示：（图示未能上传）

2) 通过cx_Oracle方式访问，目前结果中的中文仍为乱码。但已查阅到解决方案，参考点击打开链接