oracle_connect.py 文件源码

def connect(username='stock', password='123456', host='localhost', port=1521, sid='orcl'):
    # tns = cx_Oracle.makedsn(host, port, sid)
    # con = cx_Oracle.connect(username, password, tns)  # ?????
    # cursor = conn.cursor()  # ??cursor
    # return cursor
    cf = configparser.ConfigParser()
    cf.read("..\\config\\config.conf")
    oracleHost = str(cf.get("oracle", "ip"))
    oraclePort = int(cf.get("oracle", "port"))
    oracleUser = str(cf.get("oracle", "username"))
    oraclePassword = str(cf.get("oracle", "password"))
    oracleDatabaseName = str(cf.get("oracle", "databasename"))
    oracleConn = oracleUser + '/' + oraclePassword + '@' + oracleHost + '/' + oracleDatabaseName
    conn = cxo.connect(oracleConn)
    return conn


# ????????