python 链接 ORACLE 数据库,并打印数据.解决中文乱码问题

# -*- coding: utf-8 -*- import sys import os import cx_Oracle reload(sys) sys.setdefaultencoding('utf-8') os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8' class OracleHelp: def __init__(self, host, user, pwd, sid, port=1521): self.host = host self.port = port self.user = user self.pwd = pwd self.sid = sid self.conn = self.__get_conn__() def __get_conn__(self): return cx_Oracle.connect(self.user, self.pwd, '{0}:{1}/{2}'. format(self.host, self.port, self.sid)) def GetList(self, sql): cur = self.conn.cursor() cur.execute(sql) resList = cur.fetchall() self.conn.close() return resList def ExecNonQuery(self, sql): cur = self.conn.cursor() cur.execute(sql) self.conn.commit() self.conn.close() def GetList_test(self, sql): cur = self.conn.cursor() result = cur.execute(sql) #获取数据表的列名，并输出 title = [i[0] for i in cur.description] title.insert( 0, 'ROWNUM') #print title #格式化字符串 g = lambda k:"%-8s" % k title =map(g,title) for column_name in title: print column_name+'\t', print #输出查询结果,只查询100条 i=1 for row in result.fetchmany(100): #: result.fetchall() print str(i)+'\t', for k in map(g,row): print k+'\t', print i+=1 self.conn.close() sqlCa = OracleHelp('192.168.*.*','系统管理员','password','server') strsql = '''SELECT * FROM CLIMB.财务管理_实付款 ''' res = sqlCa.GetList_test(strsql) 结果如下