-- coding: utf-8 --
@Time : 2022/3/21 10:36
@Author : GORKOR
@FileName: 分析2.py
@Software: PyCharm
@Blog :https://blog.csdn.net/mdaefsc?spm=1008.2028.3001.5343
import numpy as np
import matplotlib.pyplot as plt
import cx_Oracle
def ConnectOracle():
#登录数据库
conn = cx_Oracle.connect(‘system’, ‘RPG123456’, ‘localhost:1521/orcl.168.2.45’)
print(‘数据库登录成功!’)
#获取数据库数据
cur = conn.cursor()
sql = ‘’‘select S.ENAME,S.SAL from SCOTT.EMP S ‘’’
cur.execute(sql)
row = cur.fetchall() # 获取所有数据
list1 = []
list2 = []
for i in range(len(row)):
list1.append(row[i][0])
list2.append(row[i][1])
print(list1)
print(list2)
#画直方图
x = np.array(list1)
y = np.array(list2)
plt.barh(x, y, height=0.1)
plt.show()
#提交
conn.commit()
#关闭游标
cur.close()
#关闭数据库
conn.close()
ConnectOracle()