接上一篇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()