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方式访问,目前结果中的中文仍为乱码。但已查阅到解决方案,参考点击打开链接