Oracle~python连接数据库（连接成功）

# -*- coding: utf-8 -*-
import cx_Oracle as cx
import os


os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'
#第一种：
con = cx.connect('ymuser', 'ymuser', '10.215.136.209/orcl')
#第二种
# con = cx.connect('ymuser/ymuser@10.215.136.209/orcl',charset='utf8')
#第三种
# dsn = cx.makedsn('10.215.136.209', '1521', 'orcl')
# connection = cx.connect('ymuser', 'ymuser', dsn)
cursor = con.cursor()       #创建游标
cursor.execute("select orgname from au_orginfo where orgid= '21'")  #执行sql语句
data = cursor.fetchone()        #获取一条数据
print(data)     #打印数据