pip install -i https://pypi.tuna.tsinghua.edu.cn/simple cx_Oracle

import cx_Oracle as oracle
#
def main():
    # cx_Oracle.connect("用戶名 /  密碼@ Oracle服務(wù)器IP  /  Oracle的SERVICE_NAME")
    db = oracle.connect('XXX/XXX@IP地址:端口/sid_name')#換成自己遠(yuǎn)程要連的庫
    c = db.cursor()  # 獲取cursor
    x = c.execute("select * from XXX WHERE XXX")  # 使用cursor進(jìn)行各種查詢操作
    rows = c.fetchall()
    for row in rows:
        for v in row:
            print(v)
    c.close()  # 關(guān)閉cursor
    db.close()  # 關(guān)閉連接
if __name__ == '__main__':
    main()

#運(yùn)行成功
import cx_Oracle as cx
import pandas as pd
def visitOracle(sql):
    # cx_Oracle.connect("用戶名 /  密碼@ Oracle服務(wù)器IP  /  Oracle的SERVICE_NAME")
    conn = cx.connect('XXX/XXX@IP地址:端口/sid_name')#換成自己遠(yuǎn)程要連的庫
    cursor = conn.cursor()
    cursor.execute(sql)  # 使用cursor進(jìn)行各種操作
    # 讀取字段名
    index = cursor.description
    row = list()
    for i in range(len(index)):
        row.append(index[i][0])
    # 獲取返回信息
    data = cursor.fetchall()
    result = pd.DataFrame(list(data), columns=row)
    # 關(guān)閉鏈接，釋放資源
    cursor.close()
    conn.close()
    return result
sql = "select * from XXX WHERE XXX'"
df = visitOracle(sql)
print(df)

#pip3 install flask-sqlalchemy -i https://pypi.tuna.tsinghua.edu.cn/simple
pip3 install sqlalchemy -i https://pypi.tuna.tsinghua.edu.cn/simple

#---------運(yùn)行成功
import pandas as pd
import cx_Oracle
from sqlalchemy import create_engine
# 數(shù)據(jù)庫連接信息
dsn_tns = cx_Oracle.makedsn('YOUR_HOST', 'YOUR_PORT', service_name='YOUR_SERVICE_NAME')
conn_string = f"oracle+cx_oracle://{YOUR_USERNAME}:{YOUR_PASSWORD}@{dsn_tns}"
# 創(chuàng)建數(shù)據(jù)庫引擎
engine = create_engine(conn_string)
# 構(gòu)建SQL查詢語句
query = f"select {number_column}, {clob_column} FROM {table_name} where rownum<=5"
# 使用pandas的read_sql_query方法執(zhí)行查詢并獲取結(jié)果
df = pd.read_sql_query(query, con=engine)
print(df)
# 關(guān)閉數(shù)據(jù)庫連接
engine.dispose()

##----運(yùn)行成功
import pandas as pd
import cx_Oracle as cx
from sqlalchemy import create_engine
def visitOracle(sql):
    # 數(shù)據(jù)庫連接信息
    dsn_tns = cx.makedsn(('YOUR_HOST', 'YOUR_PORT', service_name='YOUR_SERVICE_NAME')
    conn = f"oracle+cx_oracle://{YOUR_USERNAME}:{YOUR_PASSWORD}@{dsn_tns}"
    # 創(chuàng)建數(shù)據(jù)庫引擎
    engine = create_engine(conn)
    # 使用pandas的read_sql_query方法執(zhí)行查詢并獲取結(jié)果
    df = pd.read_sql_query(sql, con=engine)
    # 關(guān)閉數(shù)據(jù)庫連接
    engine.dispose()
    return df
##診療記錄
sql = "select {number_column}, {clob_column} FROM {table_name} where rownum<=5""
df = visitOracle(sql)
print(df)