Python连接oracle数据库

2019-11-08 01:53:21

字体：大中小

来源：转载

供稿：网友

import cx_Oracle#连接数据库conn = cx_Oracle.connect('账号/密码@地址/数据库名字') #创建声明cursor = conn.cursor()#执行查询cursor.execute ("select * from ck10_cfmx where rownum<=10")#获取结果row = cursor.fetchone()for a in row: PRint(a)

实验结果：

7512042130177_11301771C化验费1.0项5.05.05.02011-07-18 17:28:002011-07-19 08:20:39250303002血清甘油三酯测定14119None

fetchone()函数返回一条结果。

import cx_Oracle#连接数据库conn = cx_Oracle.connect('账号/密码@地址/数据库名') #创建声明cursor = conn.cursor()#执行查询cursor.execute ("select * from ck10_cfmx where rownum<=10")#获取结果row = cursor.fetchone()# for a in row:# print(a)for row in cursor.fetchall(): print(row)

实验结果：

(7512043, '130177_1', 130177, 1, 'C', '化验费', 1.0, '项', 9.0, 9.0, 9.0, datetime.datetime(2011, 7, 18, 17, 28), datetime.datetime(2011, 7, 19, 8, 20, 39), '250303004', '血清高密度脂蛋白胆固醇测定', 14121, None)(7512044, '130177_1', 130177, 1, 'C', '化验费', 1.0, '项', 9.0, 9.0, 9.0, datetime.datetime(2011, 7, 18, 17, 28), datetime.datetime(2011, 7, 19, 8, 20, 39), '250303005', '血清低密度脂蛋白胆固醇测定', 14123, None)(7512045, '130177_1', 130177, 1, 'C', '化验费', 1.0, '项', 5.0, 5.0, 5.0, datetime.datetime(2011, 7, 18, 17, 28), datetime.datetime(2011, 7, 18, 18, 37, 25), '250304001', '钾测定', 14172, None)(7512046, '130177_1', 130177, 1, 'C', '化验费', 1.0, '项', 5.0, 5.0, 5.0, datetime.datetime(2011, 7, 18, 17, 28), datetime.datetime(2011, 7, 18, 18, 37, 25), '250304002', '钠测定', 14173, None)(7512047, '130177_1', 130177, 1, 'C', '化验费', 1.0, '项', 5.0, 5.0, 5.0, datetime.datetime(2011, 7, 18, 17, 28), datetime.datetime(2011, 7, 18, 18, 37, 25), '250304003', '氯测定', 14174, None)(7512048, '130177_1', 130177, 1, 'C', '化验费', 1.0, '项', 5.0, 5.0, 5.0, datetime.datetime(2011, 7, 18, 17, 28), datetime.datetime(2011, 7, 18, 18, 37, 25), '250304004', '钙测定', 14175, None)(7512049, '130177_1', 130177, 1, 'C', '化验费', 1.0, '项', 7.0, 7.0, 7.0, datetime.datetime(2011, 7, 18, 17, 28), datetime.datetime(2011, 7, 18, 18, 37, 25), '250304010', '血清碳酸氢盐(HCO3) 测定', 14182, None)(7512050, '130177_1', 130177, 1, 'C', '化验费', 1.0, '项', 5.0, 5.0, 5.0, datetime.datetime(2011, 7, 18, 17, 28), datetime.datetime(2011, 7, 19, 8, 20, 39), '250305001', '血清总胆红素测定', 14185, None)(7512051, '130177_1', 130177, 1, 'C', '化验费', 1.0, '项', 5.0, 5.0, 5.0, datetime.datetime(2011, 7, 18, 17, 28), datetime.datetime(2011, 7, 19, 8, 20, 39), '250305002', '血清直接胆红素测定', 14186, None)

fetchall函数返回所有结果。

上一篇：Python基本数据结构：列表

下一篇：Python 任务调度-APScheduler