python的mysql、人大金仓数据库查询

import requests
## pip3 install beautifulsoup4
from bs4 import BeautifulSoup

## pip install mysql-connector-python
import mysql.connector

##人大金仓
import psycopg2

## Connect to the MYSQL --database
print("================================mysqlDB=========================")
conn = mysql.connector.connect(user='root', password='123456', host='127.0.0.1', database='test')
cursor = conn.cursor()
cursor.execute("select * from table1")
result = cursor.fetchall()
for row in result:
    print(row)

    ## Connect to the 人大金仓 --database
print("====================================kingDB=============================")
db = psycopg2.connect(database="dbName", user="root", password="111111", host="127.0.0.1", port="54321")
# 得到一个可以执行SQL语句的光标对象
kingCursor = db.cursor()

db.autocommit = False  ## 关闭字自动提交
selectSql = "select * from sys_user"
kingCursor.execute(selectSql)
kingResult = kingCursor.fetchall()
for kiongRow in kingResult:
    print(kiongRow)