《Python连接oracle》

接上一篇win安装mysql、sqlserver、oracle、数据库

在此基础上使用python连接oracle并判断是否连接成功

#!/usr/bin/env python
# -*- coding: UTF-8 -*-
'''
@Project ：MQTT_Test
@File ：oracle_conn.py
@IDE ：PyCharm
@Author ：Cayon_L
@Date ：2021/4/26 10:30
@User ：liuky
'''
import cx_Oracle, os


def main():
os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'
host = "****"
port = "1521"
sid = "orcl"
user = "scott"
pwd = "****"
sn = cx_Oracle.makedsn(host, port, sid)
conn = cx_Oracle.connect(user, pwd, sn)
c = conn.cursor()
c.execute("select * from dual")
# row=x.fetchone()
result = c.fetchall()
print(result) # result list
conn.commit()
for ele in result:
# print(ele[1])
# if ele=="('X',)":
# print("连接成功")
# else:
# print("连接失败")
print(ele) # ele tuple
if ele == ('X',):
print("连接成功")
else:
print("连接失败")
print(ele)
c.close()
conn.close()

main()

参考：https://blog.csdn.net/hyj_king/article/details/103011999