Question

python读取数据库怎么把列名显示出来

Answer 1

def query(self, sql):
connect = self.connect()
cur = connect.cursor()
cur.execute(sql)
index = cur.description
result = []
for res in cur.fetchall():
row = {}
for i in range(len(index)-1):
row[index[i][0]] = res[i]
result.append(row)
connect.close()
return result
这个方法返回查询结果就是带字段名的{‘字段名’：‘值’}

Answer 2

select column_name from all_tab_columns
where TABLE_NAME = 'your_table '

import cx_Oracle
con = cx_Oracle.connect( "picc", "181818","orcl")
cursor = con.cursor()
column_data_types = cursor.execute('select * from tradesummary')
result = cursor.fetchall()
for record in result:
print record
cursor.close()
con.close()

Answer 3

df = pd.DataFrame(......)
df.columns 获得列名