linux 编程如何连接数据库

import psycopg2

# 数据库连接参数
conn_params = {
    "host": "localhost",
    "database": "mydb",
    "user": "myuser",
    "password": "mypassword"
}

try:
    # 建立连接
    conn = psycopg2.connect(**conn_params)
    print("Connected to the database successfully!")
    
    # 创建一个cursor对象
    cur = conn.cursor()
    
    # 执行SQL查询
    cur.execute("SELECT version();")
    
    # 获取查询结果
    db_version = cur.fetchone()
    print(f"Database version: {db_version[0]}")
    
except (Exception, psycopg2.Error) as error:
    print(f"Error while connecting to PostgreSQL: {error}")
finally:
    # 关闭cursor和连接
    if cur:
        cur.close()
    if conn:
        conn.close()