pycharm_Oracle 链接

import  cx_Oracle

# con=cx_Oracle.connect('sdc','sdc','10.1.160.223:1521/orcl')
# cur=con.cursor()
# print("连接成功")
# sql=''' select orderid from cs_rec_order t where t.orderid=:oid '''
# param={'oid':'B888A327-791E-4B15-84DD-0162480A19E8',''}
# cur.execute(sql,oid='B888A327-791E-4B15-84DD-0162480A19E8')
# rs=cur.fetchall()[0][0]
# cur.close()
# con.commit()
# con.close()
# print(rs)

class ConOracle:
    def __init__(self,name,Orcalpwd,host):
        self.con=cx_Oracle.connect(name,Orcalpwd,host)
        self.cur=self.con.cursor()
        print("连接数据库成功！！")

    def select_sql(self,sql,param):
        self.cur.execute(sql,param)
        rs=self.cur.fetchall()
        self.cur.close()
        self.con.close()
        return rs


if __name__=="__main__":
    sql = ''' select t.orderid,t.roomid from cs_rec_order t where t.orderid=:oid and t.roomid=:roomid'''
    param = {'oid': 'B888A327-791E-4B15-84DD-0162480A19E8', 'roomid':'91F4F264-7ADA-45A9-B39E-561D2305742E'}
    con=ConOracle('sdc','sdc','10.1.160.223:1521/orcl')
    rs=con.select_sql(sql,param)
    dic={}
    a=2
    for x,y in rs:
        dic['orderid']=x
        dic['roomid']=y

    print(dic)