python 使用jaydebeapi 读取表头

JayDeBeApi是一个Java到Python的桥接库，它允许你在Python中直接操作JDBC（Java Database Connectivity）连接，包括读取数据库表头。以下是使用JayDeBeApi读取Oracle或其他SQL数据库表头的基本步骤：

from jaydebeapi import JDBCConnection

# 配置参数：driver、url、username、password
driver_name = "com.oracle.jdbc.OracleDriver"
jdbc_url = "jdbc:oracle:thin:@hostname:port/service_name"
username = "your_username"
password = "your_password"

# 创建连接
connection = JDBCConnection(driver_name, jdbc_url, [username, password])

try:
    # 执行查询获取表头 (假设表名为table_name)
    with connection.cursor() as cursor:
        cursor.execute("SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME='table_name'")
        
        # 获取结果集的第一行作为表头，因为通常第一行是列名
        table_header = cursor.fetchone()
        
except Exception as e:
    print(f"Error occurred: {e}")
finally:
    # 关闭连接
    if connection:
        connection.close()

if table_header:
    print("Table headers:", table_header)
else:
    print("No table header found.")